title: Sort in LINQ based on certain order
body: <p>I have the following records:</p>
  <pre><code>ID  Type  TypeID
  
  1   BHD    2
  2   BHD    2
  3   AUY    4
  4   CDL    5
  5   BUL    6
  6   ZUL    7
  </code></pre>
  <p>What I like to do is to sort it so it is sorted by following where AUY, BHD and CDL are sorted alphatically and BUL and ZUL are appended at the end.</p>
  <pre><code>    AUY
      BHD
      CDL
      BUL
      ZUL
  </code></pre>
  <p>How can this be done in Linq. Note that I have TypeID that I am sorting by.</p>
  <p>I have a foreach as such:</p>
  <p>foreach (var types in ent.OrderBy(s =&gt; s.TypeID)</p>