Sandeep Kumar

Sandeep Kumar

  • 2k
  • 165
  • 5.6k

how to write this query into linq

Jul 7 2022 6:39 AM

select P.Id,p.Name,pp.Weightage from Person p inner join 

(Select * from 
(
SELECT  *
  FROM [SL_Project_Management].[dbo].[PersonWiseActionHistory] where  Id in ( select MAX(Id) from [SL_Project_Management].[dbo].[PersonWiseActionHistory] group by PersonId) )ss
where convert(nvarchar(10),EffectFrom,103)=convert(nvarchar(10),'24/06/2022',103) and ActionTypeId=1)pp

on p.Id=pp.PersonId


Answers (8)