convert sql to linq

Question

Hi,

I need help, I want to convert an sql request to linq.

 

select PersonalMail,FirstName,LastName,leavingDate,BeginDate from Person pr

left outer join (select p.id,ar.BeginDate from[dbo].[ActivityRepport] ar inner join[dbo].[Person] p on p.ID = ar.PersonId where BeginDate Between @begindate and @finaldate

and FinalDate Between @begindate and @finaldate) res on res.id = pr.id where res.id is null

and Profile not In ('Administrateur', 'Directeur') and SSNumber not like '0'

and (LeavingDate is null or LeavingDate>=BeginDate ) and StartingDate <=@finaldate ;

 

 

Thanks,