title: How do I get LinqToSql to pass “index hints” to sql server?
body: <p>As we can’t trust our customers to update the index stats etc in sql server, we have in the past had to use <a href="http://www.sql-server-performance.com/tips/hints_general_p1.aspx" rel="nofollow noreferrer">index hints</a>.   (As some of our customers are still on Sql Server 2000, we also can’t depend on the better query optimizer in later version of Sql Server).</p>
  
  <p>So how do I pass in index hints when using LinqToSql to build a query rather than raw Sql?</p>