Data.ExecuteScalarDictionary

Home / Data

The ExecuteScalarDictionary method executes the query, and returns the dictionary. The keys are loaded from a column specified by the keyField parameter and values are loaded from a column specified by the valueField. Other columns are ignored.

ExecuteScalarDictionary.cs

using System;
using System.Collections.Generic;

using NUnit.Framework;

using BLToolkit.Data;

namespace HowTo.Data
{
    using DataAccess;

    [TestFixture]
    public class ExecuteScalarDictionary
    {
        Dictionary<int, string> GetNameDictionary()
        {
            using (DbManager db = new DbManager())
            {
                return db
                    .SetCommand("SELECT * FROM Person")
                    .ExecuteScalarDictionary<int, string>("PersonID", "FirstName");
            }
        }

        [Test]
        public void Test()
        {
            Dictionary<int, string> dic = GetNameDictionary();

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

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>