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