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();
}
