public void Test()
{
PersonAccessor pa = DataAccessor.CreateInstance <PersonAccessor>();
Person p = pa.SelectByName("Tester", "Testerson");
Assert.AreEqual(2, p.ID);
}
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"));
}
public void Test()
{
using (DbManager db = new DbManager())
{
PersonAccessor pa = /*[a]*/ DataAccessor.CreateInstance <PersonAccessor>(db) /*[/a]*/;
pa.BeginTransaction();
// Insert and get id.
//
Person person = new Person();
person.FirstName = "Crazy";
person.LastName = "Frog";
person.Gender = Gender.Unknown;
int id = pa./*[a]*/ Insert(person) /*[/a]*/;
// SelectByName.
//
person = pa./*[a]*/ SelectByName("Crazy", "Frog") /*[/a]*/;
Assert.IsNotNull(person);
// Select top.
//
Dictionary <int, Person> dic = pa./*[a]*/ SelectTop(10) /*[/a]*/;
Assert.IsTrue(dic.Count <= 10);
// Delete.
//
pa.Query.Delete(person);
pa.CommitTransaction();
}
}
