static void CreateCustomer(string name)
{
using (var ctx = new TestEFDBFirstContext())
{
var customer = new Customer()
{
Name = name
};
ctx.Customers.Add(customer);
ctx.SaveChanges();
}
}
static void DeleteCustomer(int id)
{
using (var ctx = new TestEFDBFirstContext())
{
var customer = ctx.Customers
.Where(c => c.Id == id)
.SingleOrDefault <Customer>();
if (customer != null)
{
ctx.Customers.Remove(customer);
ctx.SaveChanges();
}
}
}
static void UpdateCustomer(int id, string name)
{
using (var ctx = new TestEFDBFirstContext())
{
var customer = ctx.Customers
.Where(c => c.Id == id)
.SingleOrDefault <Customer>();
if (customer != null)
{
customer.Name = name;
ctx.Entry(customer).State = System.Data.Entity.EntityState.Modified;
ctx.SaveChanges();
}
}
}