public void CommitDataTranTest() { using (DbExecutor db = new DbExecutor(new SqlConnection(connString),IsolationLevel.ReadCommitted)) { var dt = db.GetTable(SqlClientFactory.Instance, "select * from MyTest"); dt.Rows[1]["Name"] = "zhangjuncui"; DataRow newDr = dt.NewRow(); dt.Rows.Add(newDr); newDr["Name"] = DateTime.Now; newDr["Mark"] = "1244"; db.CommitData(SqlClientFactory.Instance, dt, "MyTest"); Console.WriteLine("Id:" + newDr["SysId"]); db.TransactionComplete(); } }
public void CommitDataTest() { using (DbExecutor db = new DbExecutor(new SqlConnection(connString))) { var dt = db.GetTable(SqlClientFactory.Instance, "select * from MyTest"); dt.Rows[0]["Name"] = "zhangjuncui"; DataRow newDr = dt.NewRow(); dt.Rows.Add(newDr); newDr["Name"] = "ABCD"; newDr["Mark"] = "1244"; db.CommitData(SqlClientFactory.Instance, dt, "MyTest"); Console.WriteLine("Id:"+newDr["SysId"]); } }