title: Best Practice for Creating A - Z Index using Linq in Asp.net
body: <p>I wanted to created an A - Z index that pulls information from a SQL database via linq and was wondering what would be the best approach in regards to creating something very close where you have at the top A | B.....| Z and as a user clicks on a letter it is populated. </p>
  
  <p>What I have so far is:</p>
  
  <pre><code>@{ 
    var career = new career_servicesEntities(); 
    var result = (from item in career.JobLists orderby item.Name ascending select item); 
  
    foreach (var res in result) 
    { 
        &lt;div&gt; &lt;ul&gt; &lt;li&gt;&lt;a href="@res.Link"&gt;@res.Name&lt;/a&gt;&lt;/li&gt; &lt;/ul&gt; &lt;/div&gt;
    }
   } 
  </code></pre>
  
  <p>What I'm trying to recreate is something like this page:</p>
  
  <ul>
  <li><a href="http://www.usi.edu/careersv/jobsearch.asp" rel="noreferrer">http://www.usi.edu/careersv/jobsearch.asp</a></li>
  </ul>