--- /dev/null	Thu Jan 01 00:00:00 1970 +0000
+++ b/HowTo/DataAccess/AbstractAccessor.cs	Thu Mar 27 21:46:09 2014 +0400
@@ -0,0 +1,77 @@
+using System;
+using System.Collections.Generic;
+
+using NUnit.Framework;
+
+using BLToolkit.Data;
+using BLToolkit.DataAccess;
+
+namespace HowTo.DataAccess
+{
+	[TestFixture]
+	public class AbstractAccessor
+	{
+		public /*[a]*/abstract/*[/a]*/ class /*[a]*/PersonAccessor : DataAccessor<Person>/*[/a]*/
+		{
+			public /*[a]*/abstract/*[/a]*/ Person  /*[a]*/SelectByName/*[/a]*/(Person person);
+			public /*[a]*/abstract/*[/a]*/ Person  /*[a]*/SelectByName/*[/a]*/(string firstName, string lastName);
+
+			public /*[a]*/abstract/*[/a]*/ int     /*[a]*/Insert/*[/a]*/      (Person person);
+
+			[/*[a]*/SqlQuery(/*[/a]*/"SELECT Top /*[a]*/{0}/*[/a]*/ * FROM Person ORDER BY PersonID"/*[a]*/)]/*[/a]*/
+			[/*[a]*/Index("ID")/*[/a]*/]
+			public /*[a]*/abstract/*[/a]*/ Dictionary<int,Person> /*[a]*/SelectTop/*[/a]*/([/*[a]*/Format(0)/*[/a]*/] int top);
+
+			private SprocQuery<Person> _query;
+			public  SprocQuery<Person>  Query
+			{
+				get
+				{
+					if (_query == null)
+						_query = new SprocQuery<Person>(DbManager);
+					return _query;
+				}
+			}
+		}
+
+		[Test]
+		public void Test()
+		{
+			using (DbManager db = new DbManager())
+			{
+				PersonAccessor pa = /*[a]*/DataAccessor.CreateInstance<PersonAccessor>(db)/*[/a]*/;
+
+				pa.BeginTransaction();
+
+				// Insert and get id.
+				//
+				Person person = new Person();
+
+				person.FirstName = "Crazy";
+				person.LastName  = "Frog";
+				person.Gender    = Gender.Unknown;
+
+				int id = pa./*[a]*/Insert(person)/*[/a]*/;
+
+				// SelectByName.
+				//
+				person = pa./*[a]*/SelectByName("Crazy", "Frog")/*[/a]*/;
+
+				Assert.IsNotNull(person);
+
+				// Select top.
+				//
+				Dictionary<int,Person> dic = pa./*[a]*/SelectTop(10)/*[/a]*/;
+
+				Assert.IsTrue(dic.Count <= 10);
+
+				// Delete.
+				//
+				pa.Query.Delete(person);
+
+				pa.CommitTransaction();
+			}
+		}
+	}
+}
+