ExecuteScalarList

BLToolkit.NET

Business Logic Toolkit for .NET www.bltoolkit.net
 

The ExecuteScalarList method executes the query and returns a list of values of the specified column of the every row in the resultset returned by the query. Other columns are ignored.

ExecuteScalarList.cs
using System;
using System.Collections.Generic;

using NUnit.Framework;

using BLToolkit.Data;

namespace HowTo.Data
{
    using DataAccess;

    [TestFixture]
    public class ExecuteScalarList
    {
        List<string> GetNameList1()
        {
            using (DbManager db = new DbManager())
            {
                return db
                    .SetCommand("SELECT FirstName FROM Person")
                    .ExecuteScalarList<string>();
            }
        }

        [Test]
        public void Test1()
        {
            List<string> list = GetNameList1();

            Assert.AreNotEqual(0, list.Count);
            Assert.IsNotNull(list[0]);
        }

        List<string> GetNameList2()
        {
            using (DbManager db = new DbManager())
            {
                return db
                    .SetCommand("SELECT * FROM Person")
                    .ExecuteScalarList<string>("FirstName");
            }
        }

        [Test]
        public void Test2()
        {
            List<string> list = GetNameList2();

            Assert.AreNotEqual(0, list.Count);
            Assert.IsNotNull(list[0]);
        }
    }
}
App.config
<?xml version="1.0" encoding="utf-8" ?>
<configuration>
    <appSettings>
        <add
            key   = "ConnectionString"
            value = "Server=.;Database=BLToolkitData;Integrated Security=SSPI"/>
    </appSettings>
</configuration>
Create.sql script
 
© 2010 www.bltoolkit.net
[email protected]