linq查询语句语法详解-linq语法

《linq查询语句语法详解-linq语法》由会员上传分享，免费在线阅读，更多相关内容在行业资料-天天文库。

1、Linq查询语法介绍2010Linq查询介绍1LINQ查询2LINQ查询select 描述：查询顾客的公司名、地址信息查询句法： var构建匿名类型1=fromcinctx.Customers                     selectnew                     {                         公司名=c.CompanyName,                         地址=c.Address                     };

2、 对应SQL： SELECT[t0].[CompanyName],[t0].[Address]FROM[dbo].[Customers]AS[t0]        描述：查询职员的姓名和雇用年份查询句法： var构建匿名类型2=fromempinctx.Employees                     selectnew                     {                         姓名=emp.LastNameemp.FirstName,         

3、                雇用年=emp.HireDate.Value.Year                     }; 对应SQL： SELECT[t0].[LastName][t0].[FirstName]AS[value],DATEPART(Year,[t0].[HireDate])AS[value2]FROM[dbo].[Employees]AS[t0]  描述：查询顾客的ID以及联系信息（职位和联系人）查询句法： var构建匿名类型3=fromcinctx.Customers

4、                     selectnew                     {                         ID=c.CustomerID,                         联系信息=new                         {                             职位=c.ContactTitle,                             联系人=c.ContactName      

5、                   }                     }; 对应SQL： SELECT[t0].[CustomerID],[t0].[ContactTitle],[t0].[ContactName]FROM[dbo].[Customers]AS[t0]  描述：查询订单号和订单是否超重的信息查询句法： varselect带条件=fromoinctx.Orders                       selectnew                       

6、{                           订单号=o.OrderID,                           是否超重=o.Freight>100?"是":"否"                       }; 对应SQL： SELECT[t0].[OrderID],   (CASE       WHEN[t0].[Freight]>@p0THEN@p1       ELSE@p2    END)AS[value]FROM[dbo].[Orders]AS[t0]--@

7、p0:InputCurrency(Size=0;Prec=19;Scale=4)[100]--@p1:InputString(Size=1;Prec=0;Scale=0)[是]--@p2:InputString(Size=1;Prec=0;Scale=0)[否]  where 描述：查询顾客的国家、城市和订单数信息，要求国家是法国并且订单数大于5查询句法： var多条件=fromcinctx.Customers                 wherec.Country=="France"&&c

8、.Orders.Count>5                 selectnew                 {                     国家=c.Country,                     城市=c.City,                     订单数=c.Orders.Count                 };       对应SQL： SELECT[t0].[Country],[t0].[City],(   SELECTCOUN