Convert Sql Query to Linq ?

Please refer to the below site...

http://www.tutorialspanel.com/how-to-convert-sql-query-to-linq/index.htm#:~:text=We%20can%20insert%2C%20update%20and,item%20to%20the%20project%20folder.

And you can also download software for it...

https://www.linqpad.net/Download.aspx

http://www.sqltolinq.com/

Jignesh Kumar5y ago

Please refer this links which will give you best idea ,

https://www.c-sharpcorner.com/article/sql-join-query-with-linq/

https://www.c-sharpcorner.com/article/linq-join-operations/

https://www.dotnettricks.com/learn/linq/sql-joins-with-csharp-linq

Sachin Singh5y ago

Follow below query

FROM
_Context.table1 c1 // dbcontex table1 like student =students
JOIN
_Context.Table2 c2 ON c1.Id equals c2.Id
JOIN
_Context.Table3 c3 on c3.Id equals c1.Id
WHERE
c1.Id= 29 AND c2.Id= 33 and c3.title.Contains("/Henan/")
select new
{
market=C1.Value
Country=C2.value2,
Title=c3.title
___________
}