Mercurial > pub > bltoolkit
diff HowTo/DataAccess/ExecuteObject.cs @ 0:f990fcb411a9
Копия текущей версии из github
author | cin |
---|---|
date | Thu, 27 Mar 2014 21:46:09 +0400 |
parents | |
children |
line wrap: on
line diff
--- /dev/null Thu Jan 01 00:00:00 1970 +0000 +++ b/HowTo/DataAccess/ExecuteObject.cs Thu Mar 27 21:46:09 2014 +0400 @@ -0,0 +1,52 @@ +using System; + +using NUnit.Framework; + +using BLToolkit.DataAccess; + +namespace HowTo.DataAccess +{ + [TestFixture] + public class ExecuteObject + { + public abstract class /*[a]*/PersonAccessor/*[/a]*/ : /*[a]*/DataAccessor/*[/a]*/<Person> + { + // Here we explicitly specify a stored procedure name. + // + [SprocName("Person_SelectByKey")] + public abstract /*[a]*/Person/*[/a]*/ GetByID(int @id); + + // SQL query text. + // + [SqlQuery("SELECT * FROM Person WHERE PersonID = @id")] + public abstract /*[a]*/Person/*[/a]*/ GetPersonByID(int @id); + + // Specify action name. + // Stored procedure name is generated based on convention + // defined by DataAccessor.GetDefaultSpName method. + // + [ActionName("SelectByName")] + public abstract /*[a]*/Person/*[/a]*/ GetPersonByName(string @firstName, string @lastName); + + // By default method name defines an action name + // which is converted to a stored procedure name. + // Default conversion rule is ObjectName_MethodName. + // This method calls the Person_SelectByName stored procedure. + // + public abstract /*[a]*/Person/*[/a]*/ SelectByName(string @firstName, string @lastName); + } + + [Test] + public void Test() + { + PersonAccessor pa = DataAccessor.CreateInstance<PersonAccessor>(); + + // ExecuteObject. + // + Assert.IsNotNull(pa.GetByID (1)); + Assert.IsNotNull(pa.GetPersonByID (2)); + Assert.IsNotNull(pa.GetPersonByName("Tester", "Testerson")); + Assert.IsNotNull(pa.SelectByName ("Tester", "Testerson")); + } + } +}