Anyone can you translate below query into linq

Question

select i.* from dbo.Study s inner join dbo.Series se on s.Id=se.Study inner join dbo.Acquisition a on a.PrimarySeries=se.Id inner join dbo.AcquiredImage ai on ai.Acquistion = a.Id inner join dbo.Image i on i.Id=ai.Image where s.Patient=6

Ibrahim Siddique · Answer

(from s in db.studys join se in db. Series on s.id equals se.Study join a in db. Acquisition on a.PrimarySeries equals se.Id join ai in db. AcquiredImage on ai.Acquistion equals a.Id join i in db.Image on i.Id equals ai.Image select new VeawModel { Com1=s.someting Com2=se.someting Com3=a.someting Com4=ai.someting Com5 =i.someting } ).toList();

Gnanavel Sekar · Answer

sorry for all query is working fine my small mistake is i connected with other db which has no rows in table

Gnanavel Sekar · Answer

still it returns 0 rows... var testresult = (from s in this.Context.Studies where s.Patient == patientID join se in this.Context.Series on s.Id equals se.Study join a in this.Context.Acquisitions on se.Id equals a.PrimarySeries join ai in this.Context.AcquiredImages on a.Id equals ai.Acquistion join i in this.Context.Images on ai.Image equals i.Id select new { i.Id i.FileName i.CreationDate }).ToList();

Gnanavel Sekar · Answer

it's not converting properly..

Manikandan Murugesan · Answer

Refer this Link : https://stackoverflow.com/questions/12238423/linqpad-convert-sql-to-linq-command