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