title: Standard SQL Query much faster than Linq 2 SQL
body: <p>Hey there I got a problem with my code, I compared three ways of implementing a query on a database</p>
  
  <ol>
  <li>Standard SQL Query (From * Select ...)</li>
  <li>LinQ Query </li>
  <li>Precompiled LinqQuery (CompiledQuery)</li>
  </ol>
  
  <p>Now the result I got is that the Precompiled LingQuery is 5 times faster than the LinQ Query but much more interesting ist that the Standard SQL Query is approximately ten times fast than the Precompiled LinqQuery. The table that my Queries run against is one simple table with no associations to other tables. </p>
  
  <p>The fact that makes the table interesting is that it consists of 5 columns which represent all together the primary key I mean. all columns together is unique so there is no row in the table that looks like the other. All columns are indexed. </p>
  
  <p>Does anyone have an idea about what goes wrong with LinQ?</p>
  
  <p>With kind regards</p>
  
  <p>Sebastian</p>