chinnuTest
Hi All,
I am new to writing linq queries. I did write SQL query which is giving results as expected , I need to convert that in to LINQ c# query, Can you please anyone help me on this. Thank you. Here is my SQL query
select * from PatVisit p
inner join Device d on d.PattId = p.PatId and d.SyncDate is not null
where p.VisitDate in
( select max(VisitDate) from PatVisit pv where VisitId in (4,7,2,8,9) group by PatId )
and DATEDIFF(d,p.visitDate,GETDATE()) <10