public void TransactionTest() { using (DbManager db = new DbManager()) { PersonAccessor pa = DataAccessor.CreateInstance <PersonAccessor>(); db.BeginTransaction(); // Insert and get id. // Person person = Person.CreateInstance(); person.FirstName = "Crazy"; person.LastName = "Frog"; person.Gender = Gender.Unknown; int id = pa.Insert(db, person); person = pa.SelectByID(db, id); TypeAccessor.WriteConsole(person); Assert.IsNotNull(person); // Update. // person.Gender = Gender.Other; pa.Query.Update(db, person); person = pa.SelectByID(db, person.ID); TypeAccessor.WriteConsole(person); Assert.AreEqual(Gender.Other, person.Gender); // Delete. // pa.Query.Delete(db, person); person = pa.SelectByID(db, person.ID); Assert.IsNull(person); db.CommitTransaction(); // Get All. // List <Person> list = pa.Query.SelectAll(db); foreach (Person p in list) { TypeAccessor.WriteConsole(p); } } }
public void Test() { PersonAccessor pa = DataAccessor.CreateInstance <PersonAccessor>(); // Insert and get id. // Person person = Person.CreateInstance(); person.FirstName = "Crazy"; person.LastName = "Frog"; person.Gender = Gender.Unknown; int id = pa.Insert(person); person = pa.SelectByID(id); TypeAccessor.WriteConsole(person); Assert.IsNotNull(person); // Update. // person.Gender = Gender.Other; pa.Query.Update(person); person = pa.SelectByID(person.ID); TypeAccessor.WriteConsole(person); Assert.AreEqual(Gender.Other, person.Gender); // Delete. // pa.Query.Delete(person); person = pa.SelectByID(person.ID); Assert.IsNull(person); // Get All. // List <Person> list = pa.Query.SelectAll(); foreach (Person p in list) { TypeAccessor.WriteConsole(p); } }
public void Test() { PersonAccessor pa = DataAccessor.CreateInstance <PersonAccessor>(); // ExecuteScalar. // Assert.IsTrue(pa.GetCount() > 0); // 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]*/; Assert.IsFalse(id == 0); new SprocQuery <Person>().DeleteByKey(id); }
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(); } }