public void Data_Create_Account()
        {
            var repository = new AccountRepository(_dataConnectionString, 1);

            var account = new MABMoney.Domain.Account {
                Name = "ADDED",
                StartingBalance = 123.45M,
                Default = true,
                Type = AccountType.Savings,
                DisplayOrder = 50,
                IncludeInNetWorth = false
            };

            var result = repository.Add(account);

            Assert.IsTrue(result.AccountID == 6);
            Assert.IsTrue(result.Name == "ADDED");
            Assert.IsTrue(result.StartingBalance == 123.45M);
            Assert.IsTrue(result.Default == true);
            Assert.IsTrue(result.Type == AccountType.Savings);
            Assert.IsTrue(result.DisplayOrder == 50);
            Assert.IsTrue(result.User_UserID == 1);
            Assert.IsTrue(result.CreatedBy == 1);
            Assert.IsTrue(result.CreatedDate.Date == DateTime.Now.Date);
            Assert.IsTrue(result.LastModifiedBy == 1);
            Assert.IsTrue(result.LastModifiedDate.Date == DateTime.Now.Date);
            Assert.IsTrue(result.CurrentBalance == 123.45M);
            Assert.IsTrue(result.IncludeInNetWorth == false);
        }