protected void btnUpdate_Click(object sender, EventArgs e) { using (SampleDataContext dbContext = new SampleDataContext()) { Employee employee = dbContext.Employees.SingleOrDefault(emp => emp.ID == 8); employee.Salary = 65000; dbContext.SubmitChanges(); } GetData(); }
protected void btnDelete_Click(object sender, EventArgs e) { using (SampleDataContext dbContext = new SampleDataContext()) { Employee employee = dbContext.Employees.SingleOrDefault(emp => emp.ID == 8); dbContext.Employees.DeleteOnSubmit(employee); dbContext.SubmitChanges(); } GetData(); }
protected void btnInsert_Click(object sender, EventArgs e) { using (SampleDataContext dbContext = new SampleDataContext()) { Employee newEmployee = new Employee { FirstName = "Tim", LastName = "T", Gender = "Male", Salary = 55000, DepartmentId = 1 }; dbContext.Employees.InsertOnSubmit(newEmployee); dbContext.SubmitChanges(); } GetData(); }