Anyone can you translate below query into linq

Gnanavel Sekar

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

5 Replies

Know the answer? Post it — somebody with the same question will find it here.

Ibrahim Siddique9y ago
Accepted 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 Sekar9y ago
sorry for all query is working fine, my small mistake is i connected with other db which has no rows in table
Gnanavel Sekar9y ago
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 Sekar9y ago
it's not converting properly..
Manikandan Murugesan9y ago
Refer this Link : https://stackoverflow.com/questions/12238423/linqpad-convert-sql-to-linq-command