public void InsertWithTransaction()
{
University university = new University();
List <Department> departmentList = new List <Department>
{
new Department {
DepartmentName = "Computer Engineering"
},
new Department {
DepartmentName = "Mechanical Engineering"
},
new Department {
DepartmentName = "Mathematics Engineering"
},
};
for (int i = 0; i < 3000; i++)
{
departmentList.Add(new Department {
DepartmentName = "Computer Engineering" + i
});
}
var transaction = university.BeginTransaction();
foreach (var department in departmentList)
{
university.Department.Insert(department, transaction);
}
university.TransactionCommit(transaction);
}
public void DeleteWithTransaction()
{
University university = new University();
var transaction = university.BeginTransaction();
university.Department.Delete(x => x.DepartmentID == 5, transaction);
university.Department.Delete(x => x.DepartmentID == 6, 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()
{
University university = new University();
Department willBeUpdatingDepartment = new Department {
DepartmentName = "Bahadır"
};
Department willBeUpdatingDepartment1 = new Department {
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);
}
