static void Update(DBConnectionWrapper conn, SalesOrderHeader obj, DBTransactionWrapper trans = null)
{
int nor = conn.Update(ref obj, trans);
Console.WriteLine(nor + " line updated.");
var obj2 = new SalesOrderHeader();
obj2.SalesOrderId = obj.SalesOrderId;
obj2.ModifiedDate = DateTime.Now;
obj2.Status = 2;
nor = conn.Update(ref obj2, trans, i => i.ModifiedDate, i => i.Status);
Console.WriteLine(nor + " line updated (only update ModifiedDate and Status).");
}
static void TestSqlServer()
{
var rp = sp.GetService <ResolverProvider>();
Console.WriteLine("*** Testing SqlServer Library...");
using (var conn = rp.OpenConnection())
{
var trans = conn.BeginTransaction();
var orders = Query(conn, trans);
int cnt = GetSingleValue(conn, trans);
var orderids = GetFirstColumn(conn, trans);
SalesOrderHeader order = Load(conn, orderids.First(), trans);
order = Insert(conn, trans);
Update(conn, order, trans);
cnt = Delete(conn, order, trans);
trans.Rollback();
}
}
static int Delete(DBConnectionWrapper conn, SalesOrderHeader obj, DBTransactionWrapper trans = null)
{
return(conn.Delete(obj, trans));
}
