Linq入门-查询.docx

Linq实践第一部分：查询数据采用的是Northwind，主要使用Categories表与Products表。Linq工具使用的是LINQ Pad。1.1简单查询查询表Categories表中的所有字段信息SQL：select*from CategoriesLinq：from c in Categories select c表达式写法：Categories.Select (c=c)或者直接Categoriesfrom c in Categories wherec.CategoryID ==1select c;Categories.Where(c=c.CategoryID==1)；Categories.Where(c=c.CategoryName != string.Empty);1.2查询一个字段查询Categories表中的CategoryID字段信息SQL：selectCategoryIDfrom CategoriesLinq：from c in Categories selectc.CategoryID表达式写法：Categories.Select(c=c.CategoryID)Categories.Where(c=c.CategoryName!=Beverages).Select(c=c.CategoryName)from c in Categorieswherec.CategoryName.Contains(B)selectc.CategoryName1.3查询多个字段（返回匿名类与特定类）查询Categories表中的CategoryID与CategoryName字段信息1.31返回匿名类SQL: selectCategoryID, CategoryNamefrom CategoriesLinq: from c in Categories selectnew {c.CategoryID, c.CategoryName}表达式写法：Categories.Select(c=new {c.CategoryID, c.CategoryName})1.32 更改匿名类字段名称将返回的CategoryName命名为Name, CategoryID命名为IDSQL: selectCategoryIDas Id, CategoryNameas Name from CategoriesLinq: from c in Categories selectnew {Id=c.CategoryID, Name=c.CategoryName}表达式写法：Categories.Select(c=new { Id =c.CategoryID, Name =c.CategoryName})Categories.Select(c=new {c.CategoryID,c.CategoryName});Categories.Select(c=new Categories{CategoryID=c.CategoryID,CategoryName=c.CategoryName})1.33返回特定类假设我们已经定义了一个CategoryInfo类，包括CategoryID与CategoryName两个公共属性，现在返回CategoryInfo类。Linq: from c in Categories selectnewCategoryInfo {CategoryID=c.CategoryID, CategoryName= c.CategoryName}表达式：Categories.Select(c=newCategoryInfo {CategoryID=c.CategoryID, CategoryName= c.CategoryName})1.4 多个表联合查询（innerjoin）查询Category的Name与相对应的产品Name。SQL: selectc.CategoryName, p.ProductNamefrom Categories as c innerjoin Products as p onc.CategoryID=p.CategoryIDLinq: from c in Categories????join p in Products onc.CategoryIDequalsp.CategoryID????selectnew{ c.CategoryName, p.ProductName}表达式：Categories.Join(Products,c=c.CategoryID,p= p.CategoryID, (c, p)=new { c.CategoryName, p.ProductName})from c in Categories join p