DataAccess.ActionName

Home / DataAccess

ActionName is a logical name of an operation. By default a method name is an action name, but ActionNameAttribute allows overriding this behavior. Actual stored procedure name will be built depending on naming convention which is defined in the GetDefaultSpName method.

ActionName.cs

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

namespace HowTo.DataAccess
{
    [TestFixture]
    public class ActionName
    {
        public abstract class PersonAccessor : DataAccessor<Person, PersonAccessor>
        {
            // Default action name is 'SelectByKey'.
            // Stored procedure name is 'Person_SelectByKey'.
            //
            public abstract Person SelectByKey(int @id);

            // Explicit action name is 'SelectByName'.
            // Stored procedure name is 'Person_SelectByName'.
            //
            [ActionName("SelectByName")]
            public abstract Person AnyName    (string @firstName, string @lastName);
        }

        [Test]
        public void Test()
        {
            PersonAccessor pa = PersonAccessor.CreateInstance();

            Person person1 = pa.SelectByKey(1);

            Assert.IsNotNull(person1);

            Person person2 = pa.AnyName(person1.FirstName, person1.LastName);

            Assert.AreEqual(person1.ID, person2.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>
    <connectionStrings>
        <add
            name             = "DemoConnection"
            connectionString = "Server=.;Database=BLToolkitData;Integrated Security=SSPI"
            providerName     = "System.Data.SqlClient" />
    </connectionStrings>
</configuration>

CreateSql