// Using Stored procedure public void StoredProcedureExample() { using (var context = new UniContextEntities()) { Console.WriteLine("Enter student Id="); var studentID = int.Parse(Console.ReadLine()); Console.WriteLine("Student details using Stored Procedure:--"); Console.WriteLine("==============================================="); var studentDetails = context.GetSudentGrade(studentID); foreach (var std in studentDetails) { Console.WriteLine("Enrollment ID =" + std.EnrollmentID + " " + "Course ID=" + std.CourseID + " " + "Grade =" + std.Grade + " " + "student Firstname =" + std.FirstName + " " + "student Lastname=" + std.LastName); } //Using Table Valued Functions Console.WriteLine("Enter Course Id="); var courseID = int.Parse(Console.ReadLine()); Console.WriteLine("Student details using TVF:--"); Console.WriteLine("==============================================="); var studentDetails2 = context.GetStudentGradesForCourse(courseID); foreach (var std in studentDetails2) { Console.WriteLine("Enrollment ID =" + std.EnrollmentID + " " + "Course ID=" + std.CourseID + " " + "Grade =" + std.Grade); } } }
public void DefferentLoadingMethods() { //eger Load all students and their enrollment using (var context = new UniContextEntities()) { var students = context.Students .Include("Enrollments").ToList(); context.ChangeTracker.Entries().Count(); foreach (var student in students) { string name = student.FirstName + " " + student.LastName; Console.WriteLine("ID: {0}, Name: {1}", student.StudentID, name); foreach (var enrollment in student.Enrollments) { Console.WriteLine("Enrollment ID: {0}, Course ID: {1}", enrollment.EnrollmentID, enrollment.CourseID); } } // // change tracking //Console.WriteLine( "Total Change tracker count=" + context.ChangeTracker.Entries().Count()); // var entries = context.ChangeTracker.Entries(); // foreach (var entry in entries) // { // Console.WriteLine(" Entity name =" +entry.Entity.GetType().Name); // Console.WriteLine(" Entity State =" + entry.State ); // } } }
// Using View public void UseViewExample() { using (var context = new UniContextEntities()) { // var sudent=from d in context. var studentList = context.TotalStudents.ToList(); foreach (var stu in studentList) { Console.WriteLine("First name=" + stu.FirstName + " " + "lastname=" + stu.LastName); } } }
// 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 }