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