// Transaction example
public void TransactionExample()
{
using (var context = new UniContextEntities())
{
//context.Database.Log=Console.WriteLine ;
using (var dbContextTransaction = context.Database.BeginTransaction())
{
try
{
Course cr = new Course()
{
Title = "Geography",
Credits = 58
};
context.Courses.Add(cr);
// Reading course and displaying values of Course Id ==2
var queryCourseRead = context.Courses.Where(c => c.CourseID == 2);
foreach (var Course in queryCourseRead)
{
Console.WriteLine("Course details for Course ID=2 is async follow :-");
Console.WriteLine("====================================================");
Console.WriteLine("Course title =" + Course.Title + " credit =" + Course.Credits);
}
//updating Course Title for Couse ID==3
context.Database.ExecuteSqlCommand(@"update Course set title='Calculus' where CourseID=3");
queryCourseRead = context.Courses.Where(c => c.CourseID == 3);
foreach (var Course in queryCourseRead)
{
Console.WriteLine("Course details for Course ID=2 is async follow :-");
Console.WriteLine("====================================================");
Console.WriteLine("Course title =" + Course.Title + " credit =" + Course.Credits);
}
context.SaveChanges();
dbContextTransaction.Commit();
}
catch (Exception)
{
dbContextTransaction.Rollback();
}
}
}
}
public void AddStudent()
{
using (UniContextEntities context = new UniContextEntities())
{
var student = new Student()
{
LastName = "Smith",
FirstName = "Alex",
EnrollmentDate = DateTime.Parse("12/02/2009")
};
context.Students.Add(student);
//foreach(var enroll in student.Enrollments)
//{
// context.Enrollments.Add(enroll );
//}
Console.WriteLine(context.Entry(student).State);
context.SaveChanges();
Console.WriteLine("Student added");
}
}
//Updated student by Id
public void UpadteStudent(int id)
{
using (UniContextEntities context = new UniContextEntities())
{
// var student = (from d in context.Students where d.StudentID == id select d).Single();
var student = context.Students.Where(s => s.StudentID == id).Single();
student.LastName = "XYZ";
//context.Students.(student);
context.SaveChanges();
// Display Updated value of the student
// var studentRead = (from d in context.Students where d.StudentID == id select d);
// Student studentRead = context.Students.Where(s => s.StudentID == 1).Single();
var studentRead = from d in context.Students where d.StudentID == 1 select d;
Console.WriteLine("All student List as beloew:-");
foreach (var studentDetail in studentRead)
{
Console.WriteLine(studentDetail.LastName + " " + studentDetail.FirstName + " " + "Enrollment Date =" + studentDetail.EnrollmentDate);
}
}
// Adding new Student
}
