public void DeletePerson(int Id)
{
using (var context = new MyDBDataContext(_connectionString))
{
context.ExecuteCommand("Delete From People Where Id = {0}", Id);
}
}
public Person GetPerson(int id)
{
using (var context = new MyDBDataContext(_connectionString))
{
return(context.Persons.FirstOrDefault(c => c.Id == id));
}
}
public IEnumerable <Person> GetPeople()
{
using (var context = new MyDBDataContext(_connectionString))
{
return(context.Persons.ToList());
}
}
public void Add(Person person)
{
using (var context = new MyDBDataContext(_connectionString))
{
context.Persons.InsertOnSubmit(person);
context.SubmitChanges();
}
}
public void EditPerson(Person person)
{
using (var context = new MyDBDataContext(_connectionString))
{
context.Persons.Attach(person);
context.Refresh(System.Data.Linq.RefreshMode.KeepCurrentValues, person);
context.SubmitChanges();
}
}
