static void TestTransaction() { using (var context = new PetDemoEntities(PetDataConnectionStringBuilder.GetConnectionString())) { context.Database.Log = Console.Write; var standard = context.Standards.Add(new Standard() { StandardName = "1st Grade" }); context.Students.Add(new Student() { StudentName = "Rama", StandardId = standard.StandardId }); context.SaveChanges(); context.Courses.Add(new Course() { CourseName = "Computer Science" }); context.SaveChanges(); } }
static void TestConcurrency() { Student student = null; using (var context = new PetDemoEntities(PetDataConnectionStringBuilder.GetConnectionString())) { student = context.Students.First(); } //Edit student name Console.Write("Enter New Student Name:"); student.StudentName = Console.ReadLine(); //Assigns student name from console using (var context = new PetDemoEntities(PetDataConnectionStringBuilder.GetConnectionString())) { try { context.Entry(student).State = EntityState.Modified; context.SaveChanges(); Console.WriteLine("Student saved successfully."); } catch (DbUpdateConcurrencyException ex) { Console.WriteLine("Concurrency Exception Occurred."); } } }
static void TestSingleTransaction() { using (var context = new PetDemoEntities(PetDataConnectionStringBuilder.GetConnectionString())) { context.Database.Log = Console.Write; using (DbContextTransaction transaction = context.Database.BeginTransaction()) { try { var standard = context.Standards.Add(new Standard() { StandardName = "1st Grade" }); context.Students.Add(new Student() { StudentName = "Rama2", StandardId = standard.StandardId }); context.SaveChanges(); context.Courses.Add(new Course() { CourseName = "Computer Science" }); context.SaveChanges(); transaction.Commit(); } catch (Exception ex) { transaction.Rollback(); Console.WriteLine("Error occurred."); } } } }
static void TestEnum() { Teacher newTeacher = new Teacher(); newTeacher.TeacherName = "Jinpyo Kim"; newTeacher.TeacherType = TeacherType.Contract; using (var db = new PetDemoEntities(PetDataConnectionStringBuilder.GetConnectionString())) { db.Entry(newTeacher).State = newTeacher.TeacherId == 0 ? EntityState.Added : EntityState.Modified; //db.Teachers.Add(newTeacher); db.SaveChanges(); } }