Business Logic Toolkit for .NET
www.bltoolkit.net
|  Home   |  Download   |  Documentation   |  Source   |  License   |

  Doc.Data.ExecuteReader

  ExecuteReader.cs
using System;
using System.Data;

using NUnit.Framework;

using BLToolkit.Data;

namespace HowTo.Data
{
    [TestFixture]
    public class ExecuteReader
    {
        [Test]
        public void Test()
        {
            using (DbManager db = new DbManager())
            {
                db.SetCommand("SELECT * FROM Person");

                using (IDataReader rd = db.ExecuteReader())
                {
                    while (rd.Read())
                    {
                        // ...
                    }
                }
            }
        }
    }
}
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
 
© 2008 www.bltoolkit.net
support@bltoolkit.net