 <p>You might want to check out: <a href="http://www.sqltolinq.com/" rel="nofollow noreferrer">http://www.sqltolinq.com/</a></p> <p>Linqer is a SQL to LINQ converter tool. It helps you to learn LINQ and convert your existing SQL statements.</p> <p>Not every SQL statement can be converted to LINQ, but Linqer covers many different types of SQL expressions.</p> <p>Lets assume you have Table1 and Table2 in an EF dbcontext.</p> <pre><code>from Table1 in context from Table2 in context .Where(t2=&gt; t2.ID == Table1.ID &amp;&amp; t2.example == null).DefaultIfEmpty() select new { id= Table1.ID ,test = Table1.Test ,test2 = Table2.Test } </code></pre>