Mercurial > pub > bltoolkit
diff HowTo/DataAccess/ExecuteList.cs @ 0:f990fcb411a9
Копия текущей версии из github
author | cin |
---|---|
date | Thu, 27 Mar 2014 21:46:09 +0400 |
parents | |
children |
line wrap: on
line diff
--- /dev/null Thu Jan 01 00:00:00 1970 +0000 +++ b/HowTo/DataAccess/ExecuteList.cs Thu Mar 27 21:46:09 2014 +0400 @@ -0,0 +1,60 @@ +using System; +using System.Collections; +using System.Collections.Generic; + +using NUnit.Framework; + +using BLToolkit.DataAccess; + +namespace HowTo.DataAccess +{ + [TestFixture] + public class ExecuteList + { + public abstract class /*[a]*/PersonAccessor/*[/a]*/ : /*[a]*/DataAccessor/*[/a]*/ + { + // This method reads a list of Person objects. + // + [ActionName("SelectAll")] + public abstract /*[a]*/List<Person>/*[/a]*/ GetPersonList1(); + + // Here we help the method to get object type information. + // /*[a]*/ObjectTypeAttribute/*[/a]*/ can be applied to the class itself. + // In this case there is no need to specify object type for each method. + // Another way to specify object type is a generic parameter + // of the DataAccessor<T> class. + // + [SqlQuery("SELECT * FROM Person")] + [/*[a]*/ObjectType(typeof(Person))/*[/a]*/] + public abstract /*[a]*/ArrayList/*[/a]*/ GetPersonList2(); + + // This method reads a list of scalar values. + // + [SqlQuery("SELECT PersonID FROM Person")] + public abstract /*[a]*/List<int>/*[/a]*/ GetPersonIDList(); + } + + [Test] + public void Test() + { + PersonAccessor pa = DataAccessor.CreateInstance<PersonAccessor>(); + + // ExecuteList. + // + IList list; + + list = pa.GetPersonList1(); + list = pa.GetPersonList2(); + + foreach (Person p in list) + Console.WriteLine("{0}: {1} {2}", p.ID, p.FirstName, p.LastName); + + // ExecuteScalarList. + // + List<int> slist = pa.GetPersonIDList(); + + foreach (int id in slist) + Console.WriteLine("{0}", id); + } + } +}