public void CreateUpdateDeleteEF() { FormationContext context = new FormationContext(); Bank bank = context.Banks.First(); Customer customer = context.Customers.First(); Account account = new Account { Bank = bank, Owner = customer }; context.Accounts.Add(account); context.SaveChanges(); account = context.Accounts.First(); account.Balance += 100; context.SaveChanges(); context.Accounts.Remove(account); context.SaveChanges(); }
public void TestEFSimple() { FormationContext context = new FormationContext(); context.Books.Add(new Book { Title = "C#", Price = 10 }); context.Books.Add(new Book { Title = "EF", Price = 12 }); context.SaveChanges(); var res = context.Books.Where(b => b.Price < 11).First(); Assert.AreEqual("C#", res.Title); res.Price += 1; context.SaveChanges(); }
public void LazyEf() { FormationContext context = new FormationContext(); Bank bank = context.Banks.First(); Customer customer = context.Customers.First(); Account account = new Account { Bank = bank, Owner = customer }; bank.Accounts.Add(account); context.SaveChanges(); }
public void TestEFSimple() { FormationContext context = new FormationContext(); Bank bank = new Bank { Name = "CyrilBank" }; context.Banks.Add(bank); context.SaveChanges(); Bank bank2 = context.Banks.First(); Assert.AreEqual(bank.Name, "CyrilBank"); }
public void ManyToManyEF() { FormationContext context = new FormationContext(); Bank b = context.Banks.First(); Customer c1 = new Customer { FirstName = "Cyril", LastName = "Vincent" }; b.Customers.Add(c1); Customer c2 = new Customer { FirstName = "Toto", LastName = "Titi" }; b.Customers.Add(c2); Bank b2 = new Bank { Name = "NewBank" }; context.Banks.Add(b2); context.SaveChanges(); c2.Banks.Add(b2); context.SaveChanges(); }
public void TransactionsEF() { FormationContext context = new FormationContext(); Bank b = context.Banks.First(); Account account = b.Accounts.First(); account.Transactions.Add(new Transaction { Amount = 100 }); account.Transactions.Add(new Transaction { Amount = -50 }); account.Balance = 50; context.SaveChanges(); }