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