How to convert this sql query to linq
Select * from table a join table b
on a.id = b.id
join table c
on b.id = c .id
where a.name = @name
and b.age = @age
not want to use from and join,want to bring records from a and b and then filter it with c table
Srinivasan RamamoorthiPosted Oct 26, 2021, 8:16 PM
Sachin SinghPosted Oct 26, 2021, 5:38 PM
var res=from a in table1Join b in table2On a.Id=b.IdJoin table c onb.Id= c.Idwhere a.Name=obj.Name and b.Age=obj.Age select new {Name=a.Name, Age=b.Age, Id=c.Id}