LINQ to DataSets - Linq Over Typed DataSet


.NET Framework 4.0
LINQ to DataSets, Linq Over Typed DataSet
Desktop
en-US
6/28/2011

Introduction

This sample shows different uses of Linq Over Typed DataSet

Building the Sample

  1. Open the Program.cs
  2. Comment or uncomment the desired samples
  3. Press Ctrl + F5

Screenshot

Sample Code

C#
Edit|Remove
            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); 
                } 
            }

Source Code Files

More Information

For more information, see: