private void btnShowData_Click(object sender, RoutedEventArgs e) { EmployeeDataClassesDataContext dc = new EmployeeDataClassesDataContext(); var tasks = dc.EmpTasks.Where(x => x.Id > 0); this.tasksGrid.ItemsSource = tasks.ToList(); //this.tasksGrid.set var r = dc.Employees.Where(x => x.Id > 0) .OrderBy(x => x.Salary); //var r = from emp in dc.Employees // where emp.Salary > 200000 // select new // { // EmployeeName = emp.Name, // emp.Designation // }; //foreach (var item in tasks) //{ // MessageBox.Show(item.Code + "\n" + item.Description); //} //foreach (var item in r) //{ // MessageBox.Show(item.Name + "\n" + item.Designation); //} }
public LINQDBGUI() { InitializeComponent(); EmployeeDataClassesDataContext dc = new EmployeeDataClassesDataContext(); EmpTask task = new EmpTask() { Code = 444, Description = "Upload VS Project to GitHub" }; dc.EmpTasks.InsertOnSubmit(task); dc.SubmitChanges(); }