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