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