public void CreatePerson(Person person)
{
using (var ctx = new ExampleDbContext())
{
ctx.People.Add(person);
ctx.SaveChanges();
}
}
public void UpdatePerson(Person person)
{
using (var ctx = new ExampleDbContext())
{
ctx.People.Attach(person);
ctx.Entry(person).State = EntityState.Modified;
ctx.SaveChanges();
}
}
public void DeletePerson(int personId)
{
using (var ctx = new ExampleDbContext())
{
var person = ctx.People.SingleOrDefault(p => p.PersonId == personId);
if (person == null)
{
throw new ObjectNotFoundException("Invalid person id.");
}
ctx.People.Remove(person);
ctx.SaveChanges();
}
}
