This sample shows different uses of Linq Over Typed DataSet
public void DataSetLinq115() { EmployeeDataSet.EmployeesTableDataTable employees = new EmployeeDataSet.EmployeesTableDataTable(); employees.AddEmployeesTableRow(5, "Jeff Jones", 60000); employees.AddEmployeesTableRow(6, "Geoff Webber", 85000); employees.AddEmployeesTableRow(7, "Alan Fox", 85000); employees.AddEmployeesTableRow(8, "Dwight Schute", 101000); employees.AddEmployeesTableRow(9, "Chaz Hoover", 99999); var q = employees.Where(e => e.Salary >= 85000).OrderBy(e => e.Name); foreach (var emp in q) { Console.WriteLine("Id = {0}, Name = {1}", emp.ID, emp.Name); } }
public void DataSetLinq115() { EmployeeDataSet.EmployeesTableDataTable employees = new EmployeeDataSet.EmployeesTableDataTable(); employees.AddEmployeesTableRow(5, "Jeff Jones", 60000); employees.AddEmployeesTableRow(6, "Geoff Webber", 85000); employees.AddEmployeesTableRow(7, "Alan Fox", 85000); employees.AddEmployeesTableRow(8, "Dwight Schute", 101000); employees.AddEmployeesTableRow(9, "Chaz Hoover", 99999); var q = employees.Where(e => e.Salary >= 85000).OrderBy(e => e.Name); foreach (var emp in q) { Console.WriteLine("Id = {0}, Name = {1}", emp.ID, emp.Name); } }
For more information, see: