public void 交易() { using (var db = new LabEmployee2DB(ConnectionName)) { db.BeginTransaction(); var count = 0; try { var employee = new Employee { Id = Guid.NewGuid(), Name = "小章", Age = 18 }; var identity = new Identity { EmployeeId = employee.Id, Account = "yao", Password = "******" }; count += db.Insert(employee); count += db.Insert(identity); db.CommitTransaction(); } catch (Exception e) { db.RollbackTransaction(); } Assert.IsTrue(count == 2); } }
public void 新增一筆() { using (var db = new LabEmployee2DB(ConnectionName)) { var count = db.Insert(new Employee { Id = Guid.NewGuid(), Name = "小章", Age = 18 }); Assert.IsTrue(count == 1); } }
private static Employee Insert() { var toDb = new Employee { Id = Guid.NewGuid(), Name = "小章", Age = 18 }; using (var db = new LabEmployee2DB(ConnectionName)) { db.Insert(toDb); } return(toDb); }
public void 新增一筆() { var dbConnectString = DataConnection.GetConnectionString(ConnectionName); //解密 dbConnectString = this.Validator.Decrypt(dbConnectString); DataConnection.SetConnectionString(ConnectionName, dbConnectString); LabEmployee2DB db = null; try { db = new LabEmployee2DB(ConnectionName); } finally { db.Close(); db.Dispose(); } using (db = new LabEmployee2DB(ConnectionName)) { db.OnClosing += this.Db_OnClosing; db.OnClosed += this.Db_OnClosed; if (db.Connection.State == ConnectionState.Closed) { db.Connection.Open(); } var count = db.Insert(new Employee { Id = Guid.NewGuid(), Name = "小章", Age = 18 }); Assert.IsTrue(count == 1); db.Connection.Close(); } db.DisposeCommand(); }