将sql查询转换为LINQ或Lambda Expression！ [英] convert sql query to LINQ or Lambda Expression!

问题描述

任何人都可以将此sql查询转换为LINQ或LAMBDA Expression。

Can any one convert this sql query into LINQ or LAMBDA Expression.

select [Id]
      ,[Name]
      ,[Ordinal]
      ,[ThemeId]
      ,[CourseDisplayTitle]
      ,[CourseLocation]
      ,[Enabled]
      ,[FriendlyId]
      ,[DateCreated]
      ,[IsDeleted]
      ,[DateDeleted]
      ,[IsDummyData]
      ,case when Count is null then 0 else count end  as 'count'
       from (
  SELECT [Id]
      ,[Name]
      ,[Ordinal]
      ,[ThemeId]
      ,[CourseDisplayTitle]
      ,[CourseLocation]
      ,[Enabled]
      ,[FriendlyId]
      ,[DateCreated]
      ,[IsDeleted]
      ,[DateDeleted]
      ,[IsDummyData]
  FROM [dbo].[Courses]) A
  LEFT OUTER JOIN
  
  (select courseId,count(*) AS 'Count'
  from [TTF-Unitron].[dbo].[Modules]
  group by courseid) B
  ON a.id= b.courseid

推荐答案

using（ TicketingAppEntities tap = newTicketingAppEntities（））

{

varqptr =来自t intap.TicketActivities.Include（职员）

letearSize = t.ElapsedMinutes

wheret.dtStart< datetime。 now.adddays（-32）>

groupt.ixTasksbyt.ixStaffintoStaffTasks

selectnew {

Staffer = StaffTasks.Key，

任务= StaffTasks.ToList（）

};



};

using (TicketingAppEntities tap = newTicketingAppEntities())
{
varqptr = from t intap.TicketActivities.Include("Staff")
letearSize = t.ElapsedMinutes
wheret.dtStart<datetime.now.adddays(-32)>
groupt.ixTasksbyt.ixStaffintoStaffTasks
selectnew {
Staffer = StaffTasks.Key,
Tasks = StaffTasks.ToList()
};

};

这篇关于将sql查询转换为LINQ或Lambda Expression！的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！