title: Linq to Sql: Where condition order impact
body: <p>With a LINQ-TO-SQL linq query - does the SQL generated respect the 'Where conditions' order?</p>
  
  <p>For instance:</p>
  
  <pre><code>int[] result = (from r in DB.Accounts 
                  where r.AccountID &gt; 10 &amp;&amp; r.Name == "Harry").ToArray();
  </code></pre>
  
  <p>If there are thousands of rows, and there is an Index on the Name column, will the SQL query by the Indexed column first?</p>