6
Answers

how to write linq query of the below sql query

Sandeep Kumar

Sandeep Kumar

1y
554
1

SELECT DISTINCT [RefNId]
      ,[NType]
     -- ,[RoleId]
     -- ,[DeptId]
     -- ,[CourseId]
     -- ,[UserId]
      ,[NotificationH]
      ,[NotificationB]
      ,[Comment]
      ,[Status]
      ,[ApproveBy]
      ,[CreatedBy]
      ,[CreatedOn]
      ,[ModifiedBy]
      ,[ModifiedOn]
      ,[ReadTag]
  FROM [dbo].[Notification] N INNER JOIN MstStage S ON N.Status=S.Id  where N.DeptId=2  ORDER By N.[CreatedOn] desc

Answers (6)