--- /dev/null	Thu Jan 01 00:00:00 1970 +0000
+++ b/UnitTests/CS/DataAccess/SqlQueryTest.cs	Thu Mar 27 21:46:09 2014 +0400
@@ -0,0 +1,70 @@
+using System;
+using System.Collections;
+
+using NUnit.Framework;
+
+using BLToolkit.DataAccess;
+
+namespace DataAccess
+{
+	[TestFixture]
+	public class SqlQueryTest
+	{
+		public class Person
+		{
+			public int    ID;
+			public string LastName;
+			public string FirstName;
+			public string MiddleName;
+		}
+
+		[ObjectType(typeof(Person))]
+		public abstract class PersonAccessor : DataAccessor
+		{
+			[TestQuery(
+				SqlText    = "SELECT * FROM Person WHERE LastName = @lastName",
+				OracleText = "SELECT * FROM Person WHERE LastName = :lastName")]
+			public abstract ArrayList SelectByLastName(string lastName);
+
+			[TestQuery(
+				SqlText    = "SELECT * FROM Person WHERE {0} = @value",
+				OracleText = "SELECT * FROM Person WHERE {0} = :value")]
+			public abstract ArrayList SelectBy([Format] string fieldName, string value);
+
+			[TestQuery(
+				SqlText    = "SELECT TOP ({0}) * FROM Person WHERE LastName = @lastName",
+				AccessText = "SELECT TOP {0} * FROM Person WHERE LastName = @lastName",
+				OracleText = "SELECT * FROM Person WHERE LastName = :lastName AND rownum <= {0}",
+				FbText     = "SELECT FIRST {0} * FROM Person WHERE LastName = @lastName",
+				SQLiteText = "SELECT * FROM Person WHERE LastName = @lastName LIMIT {0}")]
+			public abstract ArrayList SelectByLastName(string lastName, [Format(0)] int top);
+		}
+
+		[Test]
+		public void Test1()
+		{
+			var da   = (PersonAccessor)DataAccessor.CreateInstance(typeof(PersonAccessor));
+			var list = da.SelectByLastName("Pupkin");
+
+			Assert.AreNotEqual(0, list.Count);
+		}
+
+		[Test]
+		public void Test2()
+		{
+			var da   = (PersonAccessor)DataAccessor.CreateInstance(typeof(PersonAccessor));
+			var list = da.SelectBy("FirstName", "John");
+
+			Assert.AreNotEqual(0, list.Count);
+		}
+
+		[Test]
+		public void Test3()
+		{
+			var da   = (PersonAccessor)DataAccessor.CreateInstance(typeof(PersonAccessor));
+			var list = da.SelectByLastName("Pupkin", 1);
+
+			Assert.AreNotEqual(0, list.Count);
+		}
+	}
+}