-
Notifications
You must be signed in to change notification settings - Fork 113
DataAccess.SelectByKeySql
Igor Tkachev edited this page May 22, 2016
·
1 revision
SelectByKeySql.cs
using System;
using NUnit.Framework;
using BLToolkit.Data;
using BLToolkit.DataAccess;
namespace HowTo.DataAccess
{
[TestFixture]
public class SelectByKeySql
{
[Test]
public void Test1()
{
SqlQuery<Person> query = new SqlQuery<Person>();
Person person = query.SelectByKey(1);
Assert.IsNotNull(person);
}
[Test]
public void Test2()
{
using (DbManager db = new DbManager())
{
SqlQuery<Person> query = new SqlQuery<Person>();
Person person = query.SelectByKey(db, 1);
Assert.IsNotNull(person);
}
}
}
}
DataAccessor.SelectByKetSql method generates and executes the following SQL statement:
SELECT
[MiddleName],
[PersonID],
[LastName],
[FirstName]
FROM
[Person]
WHERE
[PersonID] = @PersonID
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>