Linq to sql ：查询句法---orderby

描述：查询所有没有下属雇员的雇用年和名，按照雇用年倒序，按照名正序

查询句法：

var  排序 = from emp inctx.Employees

where emp.Employees.Count == 0

orderby emp.HireDate.Value.Year descending,emp.FirstName

ascending

select net

                                  {

雇用年 =emp.HireDate.Value.Year,

名 =emp.FirstName

                                  };            

对应SQL：

SELECT DATEPART(Year, [t0].[HireDate]) AS[value], [t0].[FirstName]

FROM [dbo].[Employees] AS [t0 

WHERE ((

   SELECT COUNT(*)

 

   FROM [dbo].[Employees] AS [t1]

 

   WHERE [t1].[ReportsTo] = [t0].[EmployeeID]

 

       )) = @p0

ORDER BY DATEPART(Year, [t0].[HireDate])DESC, [t0].[FirstName]

-- @p0: Input Int32 (Size = 0; Prec = 0;Scale = 0) [0]