--- /dev/null	Thu Jan 01 00:00:00 1970 +0000
+++ b/UnitTests/CS/Data/ExecuteScalarDictionaryTest.cs	Thu Mar 27 21:46:09 2014 +0400
@@ -0,0 +1,370 @@
+using System.Collections;
+using System.Collections.Generic;
+
+using NUnit.Framework;
+
+using BLToolkit.Common;
+using BLToolkit.Data;
+using BLToolkit.DataAccess;
+using BLToolkit.Mapping;
+
+namespace Data
+{
+	[TestFixture]
+	public class ExecuteScalarDictionaryTest
+	{
+		public class Person
+		{
+			[MapField("PersonID"), PrimaryKey]
+			public int    ID;
+			public string LastName;
+			public string FirstName;
+			public string MiddleName;
+		}
+
+		[TestFixtureSetUp]
+		public void SetUp()
+		{
+			var da = new SqlQuery();
+
+			foreach (Person p in da.SelectAll(typeof(Person)))
+				if (p.ID > 10 || p.FirstName == "Crazy")
+					da.DeleteByKey(typeof(Person), p.ID);
+		}
+
+		[Test]
+		public void ScalarDictionaryTest()
+		{
+			using (var db = new DbManager())
+			{
+				var table = db
+#if SQLITE || SQLCE
+					.SetCommand("SELECT * FROM Person")
+#else
+					.SetSpCommand("Person_SelectAll")
+#endif
+					.ExecuteScalarDictionary("PersonID", typeof(int),
+						"FirstName", typeof(string));
+
+				Assert.IsNotNull(table);
+				Assert.IsTrue(table.Count > 0);
+			}
+		}
+
+		[Test]
+		public void ScalarDictionaryTest2()
+		{
+			using (var db = new DbManager())
+			{
+				var table = new Hashtable();
+					db
+					.SetCommand("SELECT * FROM Person")
+					.ExecuteScalarDictionary(table,
+						"PersonID", typeof(int), "FirstName", typeof(string));
+
+				Assert.IsNotNull(table);
+				Assert.IsTrue(table.Count > 0);
+			}
+		}
+
+		[Test]
+		public void ScalarDictionaryTest3()
+		{
+			using (var db = new DbManager())
+			{
+				var table = db
+					.SetCommand("SELECT * FROM Person")
+					.ExecuteScalarDictionary(0, typeof(int), 1, typeof(string));
+
+				Assert.IsNotNull(table);
+				Assert.IsTrue(table.Count > 0);
+			}
+		}
+
+		[Test]
+		public void ScalarDictionaryTest4()
+		{
+			using (var db = new DbManager())
+			{
+				var table = new Hashtable();
+					db
+					.SetCommand("SELECT * FROM Person")
+					.ExecuteScalarDictionary(table,0, typeof(int), 1, typeof(string));
+
+				Assert.IsNotNull(table);
+				Assert.IsTrue(table.Count > 0);
+			}
+		}
+
+		[Test]
+		public void ScalarDictionaryMapIndexTest()
+		{
+			using (var db = new DbManager())
+			{
+				var table = db
+					.SetCommand("SELECT * FROM Person")
+					.ExecuteScalarDictionary(new MapIndex("PersonID"),
+						"FirstName", typeof(string));
+
+				Assert.IsNotNull(table);
+				Assert.IsTrue(table.Count > 0);
+			}
+		}
+
+		[Test]
+		public void ScalarDictionaryMapIndexTest2()
+		{
+			using (var db = new DbManager())
+			{
+				var table = new Hashtable();
+				db
+					.SetCommand("SELECT * FROM Person")
+				.ExecuteScalarDictionary(table,
+					new MapIndex("PersonID"), 1, typeof(string));
+
+				Assert.IsNotNull(table);
+				Assert.IsTrue(table.Count > 0);
+			}
+		}
+
+		[Test]
+		public void ScalarDictionaryMapIndexTest3()
+		{
+			using (var db = new DbManager())
+			{
+				var table = db
+					.SetCommand("SELECT * FROM Person")
+					.ExecuteScalarDictionary(new MapIndex(0),
+						"FirstName", typeof(string));
+
+				Assert.IsNotNull(table);
+				Assert.IsTrue(table.Count > 0);
+			}
+		}
+
+		[Test]
+		public void ScalarDictionaryMapIndexTest4()
+		{
+			using (var db = new DbManager())
+			{
+				var table = new Hashtable();
+				db
+					.SetCommand("SELECT * FROM Person")
+				.ExecuteScalarDictionary(table,
+					new MapIndex("PersonID"), 1, typeof(string));
+
+				Assert.IsNotNull(table);
+				Assert.IsTrue(table.Count > 0);
+			}
+		}
+
+		[Test]
+		public void ScalarDictionaryMapIndexTest5()
+		{
+			using (var db = new DbManager())
+			{
+				var table = new Hashtable();
+				db
+					.SetCommand("SELECT * FROM Person")
+				.ExecuteScalarDictionary(table,
+					new MapIndex(0, 1, 2), 1, typeof(string));
+
+				Assert.IsNotNull(table);
+				Assert.IsTrue(table.Count > 0);
+			}
+		}
+
+		[Test]
+		public void ScalarDictionaryMapIndexTest6()
+		{
+			using (var db = new DbManager())
+			{
+				var table = new Hashtable();
+				db
+					.SetCommand("SELECT * FROM Person")
+				.ExecuteScalarDictionary(table,
+					new MapIndex("PersonID", "FirstName", "LastName"), 1, typeof(string));
+
+				Assert.IsNotNull(table);
+				Assert.IsTrue(table.Count > 0);
+			}
+		}
+
+		[Test]
+		public void ScalarDictionaryMapIndexTest7()
+		{
+			using (var db = new DbManager())
+			{
+				var table = new Hashtable();
+				db
+					.SetCommand("SELECT * FROM Person")
+				.ExecuteScalarDictionary(table,
+					new MapIndex("PersonID", 2, 3), 1, typeof(string));
+
+				Assert.IsNotNull(table);
+				Assert.IsTrue(table.Count > 0);
+			}
+		}
+
+		[Test]
+		public void GenericsScalarDictionaryTest()
+		{
+			using (var db = new DbManager())
+			{
+				var dic = db
+					.SetCommand("SELECT * FROM Person")
+					.ExecuteScalarDictionary<int, string>("PersonID", "FirstName");
+
+				Assert.IsNotNull(dic);
+				Assert.IsTrue(dic.Count > 0);
+			}
+		}
+
+		[Test]
+		public void GenericsScalarDictionaryTest2()
+		{
+			using (var db = new DbManager())
+			{
+				var dic = new Dictionary<int, string>();
+				db
+					.SetCommand("SELECT * FROM Person")
+					.ExecuteScalarDictionary(dic, "PersonID", "FirstName");
+
+				Assert.IsNotNull(dic);
+				Assert.IsTrue(dic.Count > 0);
+			}
+		}
+
+		[Test]
+		public void GenericsScalarDictionaryTest3()
+		{
+			using (var db = new DbManager())
+			{
+				var dic = db
+					.SetCommand("SELECT * FROM Person")
+					.ExecuteScalarDictionary<int, string>(0, 1);
+
+				Assert.IsNotNull(dic);
+				Assert.IsTrue(dic.Count > 0);
+			}
+		}
+
+		[Test]
+		public void GenericsScalarDictionaryTest4()
+		{
+			using (var db = new DbManager())
+			{
+				var dic = new Dictionary<int, string>();
+					db
+					.SetCommand("SELECT * FROM Person")
+					.ExecuteScalarDictionary(dic, 0, 1);
+
+				Assert.IsNotNull(dic);
+				Assert.IsTrue(dic.Count > 0);
+			}
+		}
+
+		[Test]
+		public void GenericsScalarDictionaryMapIndexTest()
+		{
+			using (var db = new DbManager())
+			{
+				var dic = db
+					.SetCommand("SELECT * FROM Person")
+					.ExecuteScalarDictionary<string>(new MapIndex("LastName"), "FirstName");
+
+				Assert.IsNotNull(dic);
+				Assert.IsTrue(dic.Count > 0);
+			}
+		}
+
+		[Test]
+		public void GenericsScalarDictionaryMapIndexTest2()
+		{
+			using (var db = new DbManager())
+			{
+				var dic = new Dictionary<CompoundValue, string>();
+					db
+					.SetCommand("SELECT * FROM Person")
+					.ExecuteScalarDictionary(dic, new MapIndex("LastName"), 1);
+
+				Assert.IsNotNull(dic);
+				Assert.IsTrue(dic.Count > 0);
+			}
+		}
+
+		[Test]
+		public void GenericsScalarDictionaryMapIndexTest3()
+		{
+			using (var db = new DbManager())
+			{
+				var dic = db
+					.SetCommand("SELECT * FROM Person")
+					.ExecuteScalarDictionary<string>(new MapIndex(2), "FirstName");
+
+				Assert.IsNotNull(dic);
+				Assert.IsTrue(dic.Count > 0);
+			}
+		}
+
+		[Test]
+		public void GenericsScalarDictionaryMapIndexTest4()
+		{
+			using (var db = new DbManager())
+			{
+				var dic = new Dictionary<CompoundValue, string>();
+				db
+					.SetCommand("SELECT * FROM Person")
+					.ExecuteScalarDictionary(dic, new MapIndex(0), 2);
+
+				Assert.IsNotNull(dic);
+				Assert.IsTrue(dic.Count > 0);
+			}
+		}
+
+		[Test]
+		public void GenericsScalarDictionaryMapIndexTest5()
+		{
+			using (var db = new DbManager())
+			{
+				var dic = new Dictionary<CompoundValue, string>();
+				db
+					.SetCommand("SELECT * FROM Person")
+					.ExecuteScalarDictionary(dic, new MapIndex(0, 1, 2), 2);
+
+				Assert.IsNotNull(dic);
+				Assert.IsTrue(dic.Count > 0);
+			}
+		}
+
+		[Test]
+		public void GenericsScalarDictionaryMapIndexTest6()
+		{
+			using (var db = new DbManager())
+			{
+				var dic = new Dictionary<CompoundValue, string>();
+				db
+					.SetCommand("SELECT * FROM Person")
+					.ExecuteScalarDictionary(dic, new MapIndex("PersonID", "FirstName", "LastName"), 2);
+
+				Assert.IsNotNull(dic);
+				Assert.IsTrue(dic.Count > 0);
+			}
+		}
+
+		[Test]
+		public void GenericsScalarDictionaryMapIndexTest7()
+		{
+			using (var db = new DbManager())
+			{
+				var dic = new Dictionary<CompoundValue, string>();
+				db
+					.SetCommand("SELECT * FROM Person")
+					.ExecuteScalarDictionary(dic, new MapIndex("PersonID", 2, 3), "LastName");
+
+				Assert.IsNotNull(dic);
+				Assert.IsTrue(dic.Count > 0);
+			}
+		}
+	}
+}