// 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 }