public void InsertWithTransaction()
{
MYSQL_University university = new MYSQL_University();
List <Department> departmentList = new List <Department>
{
new Department {
DepartmentID = 2, DepartmentName = "Computer Engineering"
},
new Department {
DepartmentID = 3, DepartmentName = "Mechanical Engineering"
},
new Department {
DepartmentID = 4, DepartmentName = "Mathematics Engineering"
},
};
for (int i = 0; i < 3000; i++)
{
departmentList.Add(new Department {
DepartmentID = i + 5, DepartmentName = "Computer Engineering" + i
});
}
var transaction = university.BeginTransaction();
foreach (var department in departmentList)
{
university.Department.Insert(department, transaction);
}
university.Department.TransactionCommit(transaction);
}
public void Delete()
{
MYSQL_University university = new MYSQL_University();
Department willBeDeletedDepartment = university.Department.FirstOrDefault(x => x.DepartmentID == 1);
university.Department.Delete(willBeDeletedDepartment);
university.PushToDB();
}
public void Update()
{
MYSQL_University university = new MYSQL_University();
Department willBeUpdatingDepartment = university.Department.FirstOrDefault(x => x.DepartmentID == 1);
willBeUpdatingDepartment.DepartmentName = "Computer Engineering Updated";
university.Department.Update(willBeUpdatingDepartment);
university.PushToDB();
}
public void Insert()
{
MYSQL_University university = new MYSQL_University();
university.Department.Insert(new Department {
DepartmentID = 1, DepartmentName = "Computer Engineering"
});
university.PushToDB();
}
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);
}
public void Where()
{
MYSQL_University university = new MYSQL_University();
List <Student> studentList = university.Student.Where(x => x.DepartmentID == 1 && x.StudentEmail.Contains("Test") || x.StudentName != "Bahadır");
}
public void ToPaginateList()
{
MYSQL_University university = new MYSQL_University();
List <Department> departmentList = university.Department.ToPaginateList(null, "DepartmentID", 2, 3);
}
public void ToList()
{
MYSQL_University university = new MYSQL_University();
List <Department> departmentList = university.Department.ToList();
}
public void FirstOrDefault()
{
MYSQL_University university = new MYSQL_University();
university.Student.FirstOrDefault(x => x.DepartmentID == 1);
}
