convert sql query to LINQ or Lambda Expression!

Question

1.00/5 (1 vote)

See more:

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

SQL

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

Posted 18-Apr-13 2:15am

rummer

Add a Solution

1 solution

Add a Solution

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

tsaini · Answer 1 · 2013-06-13T06:46:00

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()
};

};

convert sql query to LINQ or Lambda Expression!

1 solution

Solution 1

Add your solution here

Preview 0

convert sql query to LINQ or Lambda Expression!

1 solution

Solution 1

Add your solution here

Preview 0

Existing Members

...or Join us