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");
}
}
