private void DemoUnitOfWork()
{
using (var uow = new DapperUnitOfWork(_connection))
{
#region --- 第一次交易 ---
// 介面型 + 泛型 (混搭)
var banknoteVaultRepository = uow.GetRepository <IBanknoteVaultRepository>();
var vault = new BanknoteVault()
{
TagId = 10000,
Number01 = 1,
Number02 = 2,
Number03 = 3,
Number04 = 4,
Number05 = 5,
};
banknoteVaultRepository.Add(vault); // 新增資料
vault.Number01 += 10;
banknoteVaultRepository.Update(vault); // 更新資料
// 找TagId
//var findVault = banknoteVaultRepository.FindTagId(10000);
// 介面型
var memberRepository = uow.GetRepository <IMemberRepository>();
var member = new Member
{
Name = "Frank",
Age = 28,
Phone = "123456789",
Address = "Hello"
};
memberRepository.Add(member);
// 泛型 (同上方) CRUD
var employeesRepository = uow.GetGenericRepository <Employees>();
var employees = new Employees()
{
Name = "Darren",
Title = "SoftWare Engineer"
};
employeesRepository.Add(employees);
//throw new Exception("Don't save the Member and Employees.");
// 儲存資料
uow.Save();
#endregion
#region --- 第二次交易 ---
member = new Member
{
Name = "Jimpo",
Age = 18,
Phone = "1222",
Address = "Hello~"
};
memberRepository.Add(member);
employees = new Employees()
{
Name = "1K",
Title = "SoftWare Engineer"
};
employeesRepository.Add(employees);
// 儲存資料
uow.Save();
#endregion
#region --- 第三次交易(失敗) ---
// 故意測試，此筆交易是否會成功
var employeesRepositoryNew = uow.GetGenericRepository <Employees>();
employeesRepository.Add(new Employees()
{
Name = "Mario", Title = "Engineer"
});
throw new Exception("Don't save the Member and Employees.");
// 儲存資料
uow.Save();
#endregion
}
}