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