AS P.NET3.5网站开发项目实战课件作者龚赤兵任务3LINQ应用.pptVIP

Written by Lushaoming 任务3 LINQ应用 实训1——LINQ的基本概念 实训2——LINQ to Objects 实训3——LINQ to XML 实训4——LINQ to DataSet 实训5——LINQ to SQL 实训6——LINQ标准查询运算符 实训1——LINQ的基本概念 LINQ的基本架构 LINQ表达式是强类型的 LINQ的基本架构 实训1——LINQ的基本概念 LINQ表达式是强类型的 实训2——LINQ to Objects 创建一个控制台应用项目 查询一个整数列表 查询一个对象列表 创建一个控制台应用项目 查询一个整数列表 1: class Program 2: { 3: static void Main(string[] args) 4: { 5: NumQuery(); 6: } 7: 查询一个整数列表 8: static void NumQuery() 9: { 10: var numbers = new int[] {1,4,9,16,25,36 }; 11: 12: var evenNumbers = from p in numbers where (p % 2) = 0 select p; 13: Console.WriteLine(Results:); 14: foreach (var val in evenNumbers) 15: Console.WriteLine(val); 16: } 17: } 查询一个对象列表 1: public class Customer 2: { 3: public string CustomerID { get; set; } 4: public string City { get; set; } 5: 6: public override string ToString() 7: { 8: return CustomerID + \t + City; 9: } 实训3——LINQ to XML 读取XML文档 查询XML文档 转换XML文档 读取XML文档 1: ?xml version=1.0 encoding=utf-8 ? 2: Customers 3: Customer CustomerID=ALFKI City=Berlin ContactName=Maria Anders / 4: Customer CustomerID=BONAP City=Marseille ContactName=Laurence Lebihan / 5: Customer CustomerID=CONSH City=London ContactName=Elizabeth Brown / 6: Customer CustomerID=EASTC City=London ContactName=Ann Devon / 7: Customer CustomerID=FRANS City=Torino ContactName=Paolo Accorti / 8: Customer CustomerID=LONEP City=Portland ContactName=Fran Wilson / 9: Customer CustomerID=NORTS City=London ContactName=Simon Crowther / 10: Customer CustomerID=THEBI City=Portland ContactName=Liz Nixon / 11: /Customers 读取XML文档 1: static IEnumerableCustomer CreateCustomers() 2: { 3: var results=from c in XDocument.Load(Customers.xml) .Descendants(Customer