Sandeep Kumar

Sandeep Kumar

  • 1.1k
  • 683
  • 60.7k

how to write linq query of the below sql query

Mar 24 2023 8:35 AM

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)