public void Add(Person person)
{
using (var context = new PeopleDataContext(_connectionString))
{
context.People.Add(person);
context.SaveChanges();
}
}
public void Delete(List <int> ids)
{
using (var context = new PeopleDataContext(_connectionString))
{
var peopleToDelete = context.People.Where(p => ids.Contains(p.Id));
context.People.RemoveRange(peopleToDelete);
context.SaveChanges();
}
}
public void Update(Person person)
{
using (var context = new PeopleDataContext(_connectionString))
{
context.People.Attach(person);
context.Entry(person).State = EntityState.Modified;
context.SaveChanges();
}
}