private void resetButton_Click(object sender, EventArgs e) { var db = new MyModelContainer(); //DBCC CHECKIDENT(StudentSet, RESEED, 0) //DBCC CHECKIDENT(SpecialtySet, RESEED, 0) //DBCC CHECKIDENT(FacultySet, RESEED, 0) db.Database.ExecuteSqlCommand("DBCC CHECKIDENT (StudentSet, RESEED, 0)"); db.Database.ExecuteSqlCommand("DBCC CHECKIDENT (SpecialtySet, RESEED, 0)"); db.Database.ExecuteSqlCommand("DBCC CHECKIDENT (FacultySet, RESEED, 0)"); db.SaveChanges(); //очистка содержимого db.StudentSet.RemoveRange(db.StudentSet); db.SpecialtySet.RemoveRange(db.SpecialtySet); db.FacultySet.RemoveRange(db.FacultySet); db.SaveChanges(); }
private void addTestDataButton_Click(object sender, EventArgs e) { var db = new MyModelContainer(); var fac1 = new Faculty() { Id = 1, Name = "fac1" }; var fac2 = new Faculty() { Id = 2, Name = "fac2" }; var specialty1 = new Specialty() { Faculty = fac1, Name = "specialty1" }; var specialty2 = new Specialty() { Faculty = fac1, Name = "specialty2" }; var specialty3 = new Specialty() { Faculty = fac2, Name = "specialty3" }; var student1 = new Student() { Adr = "adr1", Fio = "fio1", Phone = "phone1", Year = "2001", Specialty = specialty1 }; var student2 = new Student() { Adr = "adr2", Fio = "fio2", Phone = "phone2", Year = "2001", Specialty = specialty1 }; var student3 = new Student() { Adr = "adr3", Fio = "fio3", Phone = "phone3", Year = "2002", Specialty = specialty1 }; var student4 = new Student() { Adr = "adr4", Fio = "fio4", Phone = "phone4", Year = "2003", Specialty = specialty2 }; var student5 = new Student() { Adr = "adr5", Fio = "fio5", Phone = "phone4", Year = "2002", Specialty = specialty2 }; var student6 = new Student() { Adr = "adr6", Fio = "fio6", Phone = "phone6", Year = "2002", Specialty = specialty3 }; var student7 = new Student() { Adr = "adr7", Fio = "fio7", Phone = "phone7", Year = "2002", Specialty = specialty3 }; db.StudentSet.Add(student1); db.StudentSet.Add(student2); db.StudentSet.Add(student3); db.StudentSet.Add(student4); db.StudentSet.Add(student5); db.StudentSet.Add(student6); db.StudentSet.Add(student7); db.SaveChanges(); }