public void DeleteWithTransaction() { MYSQL_University university = new MYSQL_University(); var transaction = university.BeginTransaction(); university.Department.Delete(x => x.DepartmentID == 12345, transaction); university.Department.Delete(x => x.DepartmentID == 12346, transaction); university.Department.Delete(x => x.DepartmentID == 11, transaction); university.Department.Delete(x => x.DepartmentID == 12, transaction); university.Department.Delete(x => x.DepartmentID == 13, transaction); university.Course.Delete(x => x.CourseID == 1, transaction); university.TransactionCommit(transaction); }
public void UpdateWithTransaction() { MYSQL_University university = new MYSQL_University(); Department willBeUpdatingDepartment = new Department { DepartmentID = 12345, DepartmentName = "Bahadır" }; Department willBeUpdatingDepartment1 = new Department { DepartmentID = 12346, DepartmentName = "Yardım" }; var transaction = university.BeginTransaction(); university.Department.Update(x => x.DepartmentID == 5, willBeUpdatingDepartment, transaction); university.Department.Update(x => x.DepartmentID == 6, willBeUpdatingDepartment1, transaction); university.TransactionCommit(transaction); }