ParamName - Business Logic Toolkit for .NET

Business Logic Toolkit for .NET
www.bltoolkit.net

By default, the method parameter name should match the stored procedure parameter name. The ParamName specifies the sproc parameter name explicitly.

ParamName.cs

using System;
using NUnit.Framework;
using BLToolkit.DataAccess;

namespace HowTo.DataAccess
{
    [TestFixture]
    public class ParamName
    {
        public abstract class TestAccessor : DataAccessor
        {
            public abstract Person SelectByName(
                [ParamName("FirstName")] string name1,
                [ParamName("@LastName")] string name2);
        }

        [Test]
        public void Test()
        {
            TestAccessor ta = DataAccessor.CreateInstance<TestAccessor>();
            Person       p  = ta.SelectByName("Tester", "Testerson");

            Assert.AreEqual(2, p.ID);
        }
    }
}

Person.cs

using System;

using BLToolkit.DataAccess;
using BLToolkit.Mapping;

namespace HowTo.DataAccess
{
    public class Person
    {
        [MapField("PersonID"), PrimaryKey, NonUpdatable]
        public int    ID;

        public string LastName;
        public string FirstName;
        public string MiddleName;
        public Gender Gender;
    }
}

Gender.cs

using System;

using BLToolkit.Mapping;

namespace HowTo.DataAccess
{
    public enum Gender
    {
        [MapValue("F")] Female,
        [MapValue("M")] Male,
        [MapValue("U")] Unknown,
        [MapValue("O")] Other
    }
}

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