Translating Sql to Linq <p>How to translate</p> <pre><code>select *from ( select EmployeeID,FirstName,LastName,Region from Employees where city in ('London','Seattle') ) x where x.Region is not null </code></pre> <p>into Linq Equivalent.</p> <p><strong>I tried (But null values also get selected)</strong></p> <pre><code>LinqDBDataContext Context = new LinqDBDataContext(); var query = from emps in ( from empls in Context.Employees where empls.City == "London" || empls.City == "Seattle" &amp;&amp; empls.Region != null select new { FirstName = empls.FirstName, LastName = empls.LastName, City = empls.City, Region = empls.Region } ) select emps; GridView1.DataSource = query; GridView1.DataBind(); </code></pre>