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 ;