public void AddPerson(Person person)
{
using (PeopleDbDataContext context = new PeopleDbDataContext(_connectionString))
{
context.Persons.InsertOnSubmit(person);
context.SubmitChanges();
}
}
public void AddCar(Car car)
{
using (var context = new PeopleDbDataContext(_connectionString))
{
context.Cars.InsertOnSubmit(car);
context.SubmitChanges();
}
}
public void UpdatePerson(Person person)
{
using (PeopleDbDataContext context = new PeopleDbDataContext(_connectionString))
{
context.Persons.Attach(person);
context.Refresh(RefreshMode.KeepCurrentValues, person);
context.SubmitChanges();
}
}