ParamDbType

BLToolkit.NET

Business Logic Toolkit for .NET www.bltoolkit.net
 

The ParamDbType can be used to specify parameter DbType.

Param.cs
using System;
using System.Data;

using NUnit.Framework;

using BLToolkit.Data;
using BLToolkit.DataAccess;

namespace HowTo.DataAccess
{
    [TestFixture]
    public class Param
    {
        public abstract class TestAccessor : DataAccessor
        {
            [SqlQuery("SELECT {0} = {1} FROM Person WHERE PersonID = 1")]
            public abstract void SelectJohn(
                [ParamSize(50), ParamDbType(DbType.String)] out string name,
                [Format] string paramName,
                [Format] string fieldName);
        }

        [Test]
        public void AccessorTest()
        {
            using (DbManager db = new DbManager())
            {
                TestAccessor ta = DataAccessor.CreateInstance<TestAccessor>(db);

                string actualName;

                ta.SelectJohn(out actualName, "@name", "FirstName");

                Assert.AreEqual("John", actualName);
            }
        }
    }
}
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]