title: entity framework get entities with child collection with self order
body: <p>I have a entity(SystemUnit), which contains collection of sub entities(Roles): </p>
  
  <pre><code>public partial class SystemUnit
  {
      public SystemUnit()
      {
          this.Roles = new HashSet&lt;Role&gt;();
          this.Childs = new HashSet&lt;SystemUnit&gt;();
      }
  
      public int Id { get; set; }
      public Nullable&lt;int&gt; ParentId { get; set; }
      public int SystemUnitTypeId { get; set; }
      public string Name { get; set; }
  
      public virtual SystemUnitType SystemUnitType { get; set; }
      public virtual ICollection&lt;Role&gt; Roles { get; set; }
      public virtual ICollection&lt;SystemUnit&gt; Childs { get; set; }
      public virtual SystemUnit Parent { get; set; }
  }
  </code></pre>
  
  <p>I need using entity framework to get all system units, ordered by Id Asc with included Roles, ordered by id desc. Newbee in linq (</p>