title: LINQ and a natural sort order
body: <p>What's the easiest way to get a LINQ query (from an SQL database - does that matter?) to order strings naturally?</p>
  
  <p>For example, I'm currently getting these results:</p>
  
  <ul>
  <li>Project 1</li>
  <li>Project 10</li>
  <li>Project 2</li>
  </ul>
  
  <p>What I'd like is to see is this:</p>
  
  <ul>
  <li>Project 1</li>
  <li>Project 2</li>
  <li>Project 10</li>
  </ul>
  
  <p>The query I'm using is this:</p>
  
  <pre><code>return from p in dataContext.Projects
      orderby p.Name
      select p;
  </code></pre>