static void GetCustomer(int id)
{
using (var ctx = new NewDbContext())
{
var customer = ctx.Customers
.Where(c => c.Id == id)
.SingleOrDefault();
Console.WriteLine($"{customer.Firstname} {customer.Lastname} {customer.City}");
}
}
static void DeleteCustomer(int id)
{
using (var ctx = new NewDbContext())
{
var customer = ctx.Customers
.Where(c => c.Id == id)
.SingleOrDefault();
//ctx.Entry(customer).State = System.Data.Entity.EntityState.Modified;
ctx.Customers.Remove(customer);
ctx.SaveChanges();
}
}
static void UpdateCustomer(int id, string city)
{
using (var ctx = new NewDbContext())
{
var customer = ctx.Customers
.Where(c => c.Id == id)
.SingleOrDefault();
customer.City = city;
ctx.Entry(customer).State = System.Data.Entity.EntityState.Modified;
ctx.SaveChanges();
}
}
static void CreateCustomer()
{
using (var ctx = new NewDbContext())
{
var customer = new Customer()
{
Firstname = "John",
Lastname = "Smith",
Email = "*****@*****.**"
};
ctx.Customers.Add(customer);
ctx.SaveChanges();
}
}
