public void ExecuteUpateStatement() { var logger = new MessageStackLogger(); var provider = new SqlContextProvider(ConnectionString); provider.Settings.AddLogger(logger); using (var context = provider.Open()) { // select with string select statement context.Execute("UPDATE Orders SET Freight = 20 WHERE OrdersID = 10000000"); Assert.AreEqual(logger.Logs.First().Message.Flatten(), "UPDATE Orders SET Freight = 20 WHERE OrdersID = 10000000"); } }
public void UpdateIntegrationTest() { var logger = new MessageStackLogger(); var provider = new SqlContextProvider(ConnectionString); provider.Settings.AddLogger(logger); using (var context = provider.Open()) { context.Update<Orders>(() => new { Freight = 20 }, o => o.OrdersID == 10000000); context.Commit(); Assert.AreEqual(logger.Logs.First().Message.Flatten(), "UPDATE Orders SET Freight = 20 WHERE (Orders.OrdersID = 10000000)"); } }
public void ExecuteSelectStatement() { var logger = new MessageStackLogger(); var provider = new SqlContextProvider(ConnectionString); provider.Settings.AddLogger(logger); using (var context = provider.Open()) { // select with string select statement var orders = context.Execute<Orders>("SELECT * FROM Orders"); Assert.IsTrue(orders.Any()); Assert.AreEqual(logger.Logs.First().Message.Flatten(), "SELECT * FROM Orders"); } }