title: Order DataTable using LINQ based on a Class Collection
body: <p>I have a class and I am creation its collection like this</p>
  
  <pre><code>class Foo
  {
      public int ID { get; set; } 
      // ID will remain unique in collection
  
      public string Name { get; set; }
  }
  </code></pre>
  
  <hr>
  
  <pre><code>List&lt;Foo&gt; sc = new List&lt;Foo&gt;();
  
  sc.Add(new Foo()
  {
      ID = 0,
      Name= "Michael"
  });
  
  sc.Add(new Foo()
  {
      ID = 2,
      Name= "Natasha"
  });
  
  sc.Add(new Foo()
  {
      ID = 1,
      Name= "Casandra"
  });
  </code></pre>
  
  <p>Then I get a DataTable</p>
  
  <pre><code>DataTable dt = GetDataTableMethod();
  </code></pre>
  
  <p>Datatable contains only name and not ID and will always have names less than collection. (bcoz collection is master collection)</p>
  
  <p>Now I want to sort my datatable based on <code>"name"</code> but based on sorting of Foo Class collection which will be based on id.</p>
  
  <p>Result after sorting datatable should be </p>
  
  <pre><code>Michael
  Casandra
  Natasha
  </code></pre>
  
  <p>I tried </p>
  
  <pre><code>var v = dt.Rows.Cast&lt;DataRow&gt;().OrderBy(What should i write here?);
  </code></pre>