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