public void FindBySqlTest() { using (var data = new SqlDataAccess(STR_ConnectionString)) { var entry = data.Find<WebLogEntry>("select * from ApplicationLog where id=@0", 1); Assert.IsNotNull(entry, data.ErrorMessage); Console.WriteLine(entry.Entered + " " + entry.Message); } }
public void FindTest() { using (var data = new SqlDataAccess(STR_ConnectionString)) { var customer = data.Find<Customer>("select * from customers where id=@0", 1); Assert.IsNotNull(customer, data.ErrorMessage); Console.WriteLine(customer.Company); } }
public void FindByIdTest() { using (var data = new SqlDataAccess(STR_ConnectionString)) { var entry = data.Find<WebLogEntry>(1, "ApplicationLog", "Id"); Assert.IsNotNull(entry, data.ErrorMessage); Console.WriteLine(entry.Entered + " " + entry.Message); var entry2 = new WebLogEntry(); data.GetEntity(entry2, "ApplicationLog", "Id", 1); Assert.IsNotNull(entry2); Assert.AreEqual(entry2.Message, entry.Message); Console.WriteLine(entry2.Entered + " " + entry2.Message); } }