--- /dev/null	Thu Jan 01 00:00:00 1970 +0000
+++ b/HowTo/Data/ExecuteList.cs	Thu Mar 27 21:46:09 2014 +0400
@@ -0,0 +1,98 @@
+using System;
+using System.Collections;
+using System.Collections.Generic;
+
+using NUnit.Framework;
+
+using BLToolkit.Data;
+using BLToolkit.Mapping;
+using BLToolkit.Reflection;
+
+namespace HowTo.Data
+{
+	[TestFixture]
+	public class ExecuteList
+	{
+		[MapValue(Gender.Female,  "F")]
+		[MapValue(Gender.Male,    "M")]
+		[MapValue(Gender.Unknown, "U")]
+		[MapValue(Gender.Other,   "O")]
+		public enum Gender
+		{
+			Female,
+			Male,
+			Unknown,
+			Other
+		}
+
+		[MapField("PersonID", "ID")]
+		public class Person
+		{
+			public int    ID;
+
+			public string LastName;
+			public string FirstName;
+			public string MiddleName;
+			public Gender Gender;
+		}
+
+		IList<Person> GetPersonListSqlText()
+		{
+			using (DbManager db = new DbManager())
+			{
+				return db
+					.SetCommand("SELECT * FROM Person")
+					./*[a]*/ExecuteList<Person>()/*[/a]*/;
+			}
+		}
+
+		[Test]
+		public void SqlText()
+		{
+			IList<Person> list = GetPersonListSqlText();
+
+			foreach (Person p in list)
+				TypeAccessor.WriteDebug(p);
+		}
+
+		IList<Person> GetPersonListSproc()
+		{
+			using (DbManager db = new DbManager())
+			{
+				return db
+					.SetSpCommand("Person_SelectAll")
+					./*[a]*/ExecuteList<Person>()/*[/a]*/;
+			}
+		}
+
+		[Test]
+		public void Sproc()
+		{
+			IList<Person> list = GetPersonListSproc();
+
+			foreach (Person p in list)
+				TypeAccessor.WriteDebug(p);
+		}
+
+		void GetCustomPersonList(IList list)
+		{
+			using (DbManager db = new DbManager())
+			{
+				db
+					.SetSpCommand("Person_SelectAll")
+					./*[a]*/ExecuteList(list, typeof(Person))/*[/a]*/;
+			}
+		}
+
+		[Test]
+		public void CustomList()
+		{
+			ArrayList list = new ArrayList(10);
+
+			GetCustomPersonList(list);
+
+			foreach (Person p in list)
+				TypeAccessor.WriteDebug(p);
+		}
+	}
+}