| |
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
| |