Data.ExecuteList

Home / Data

ExecuteList.cs

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")
                    .ExecuteList<Person>();
            }
        }

        [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")
                    .ExecuteList<Person>();
            }
        }

        [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")
                    .ExecuteList(list, typeof(Person));
            }
        }

        [Test]
        public void CustomList()
        {
            ArrayList list = new ArrayList(10);

            GetCustomPersonList(list);

            foreach (Person p in list)
                TypeAccessor.WriteDebug(p);
        }
    }
}

App.config

<?xml version="1.0" encoding="utf-8" ?>
<configuration>
    <connectionStrings>
        <add
            name             = "DemoConnection"
            connectionString = "Server=.;Database=BLToolkitData;Integrated Security=SSPI"
            providerName     = "System.Data.SqlClient" />
    </connectionStrings>
</configuration>