Business Logic Toolkit for .NET
www.bltoolkit.net
Welcome Guest, you are in: Login
|  Home   |  Download   |  Documentation   |  Discussions   |  Issues   |  License   |
RSS RSS

Navigation




Search the wiki
»

PoweredBy

ExecuteScalarDictionary

RSS
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>
© 2010 www.bltoolkit.net