public void InsertStudent()
{
University Birmingham = dataContext.Universities.First(um => um.Name.Equals("Birmingham")); //this a lambda expression, which is the same as below:
//"from university in dataContext.University where university == 'Birmingham' select university"
//Add another University
University Aston = dataContext.Universities.First(um => um.Name.Equals("Birmingham"));
List <Student> students = new List <Student>(); //if error? drag dbo from the .dbml file
//Add Students
students.Add(new Student {
Name = "Claire", Gender = "Female", UniversityId = Birmingham.Id
});
students.Add(new Student {
Name = "Tom", Gender = "Male", University = Aston
});
students.Add(new Student {
Name = "Kev", Gender = "Male", University = Birmingham
});
students.Add(new Student {
Name = "Jenny", Gender = "Female", University = Aston
});
students.Add(new Student {
Name = "Kos", Gender = "Female", University = Birmingham
});
//Insert on submit
dataContext.Students.InsertAllOnSubmit(students);
//Submit Changes
dataContext.SubmitChanges();
//View in the window
MainDataGrid.ItemsSource = dataContext.Students;
}
partial void DeleteUniversity(University instance);
partial void UpdateUniversity(University instance);
partial void InsertUniversity(University instance);
