public void DeleteKarla()
{
Student karla = dataContext.Students.FirstOrDefault(s => s.Name.Equals("Karla"));
dataContext.Students.DeleteOnSubmit(karla);
dataContext.SubmitChanges();
//in case of error:
string connectionString = ConfigurationManager.ConnectionStrings["WpfApp_LinqToSQL.Properties.Settings.ExampleDB1ConnectionString"].ConnectionString;
LonqToSqlDataClassesDataContext db = new LonqToSqlDataClassesDataContext(connectionString);
MainDataGrid.ItemsSource = dataContext.Students;
}
public MainWindow()
{
InitializeComponent();
//ExampleDB1ConnectionString
// - is going to be _
string connectionString = ConfigurationManager.ConnectionStrings["WpfApp_LinqToSQL.Properties.Settings.ExampleDB1ConnectionString"].ConnectionString;
dataContext = new LonqToSqlDataClassesDataContext(connectionString);
//InsertUniversities();
//InsertStudents();
//InsertLectures();
//InsertStudentLectureAssociations();
//GetUniversityOfMark();
//GetLecturesOfMark();
//GetAllStudentsFromYale();
//GetAllUniversitiesWithFeMales();
//UpdateMark();
DeleteKarla();
}