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