public void Update(Person person)
{
using var context = new PeopleDataContext(_connectionString);
context.People.Attach(person);
context.Entry(person).State = EntityState.Modified;
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 Person Get(int id)
{
using var context = new PeopleDataContext(_connectionString);
return(context.People.FirstOrDefault(p => p.Id == id));
}
public void Delete(int id)
{
using var context = new PeopleDataContext(_connectionString);
context.Database.ExecuteSqlInterpolated($"DELETE FROM People WHERE Id = {id}");
}
public void Add(Person person)
{
using var context = new PeopleDataContext(_connectionString);
context.People.Add(person);
context.SaveChanges();
}
public List <Person> GetAll()
{
using var context = new PeopleDataContext(_connectionString);
return(context.People.ToList());
}
