title: How do I get active rows in 1 to many relationship using Linq?
body: <p>I am using EF4.3. At the back end I have a database that includes the following tables</p>
  
  <p><img src="https://i.stack.imgur.com/mSzGr.gif" alt="enter image description here"></p>
  
  <p>In my site logic, I retrieve the entity Tier, but also eager load MatchNode, MatchBuyer and Buyer.</p>
  
  <p>Here's my logic for fetching all Tier entities:</p>
  
  <pre><code>    public static IEnumerable&lt;Tier&gt; Fetch()
      {
          using (var uow = new UnitOfWork(ConnectionString.Lenders))
          {
              var r = new Repository&lt;Tier&gt;(uow.Context);
  
              return r.Find()
                  .Include("MatchNodes.MatchBuyer.Buyer")           
                  .ToList();
          }
      }
  </code></pre>
  
  <p>As you can see, a Tier has many MatchNode, and each MatchNode, a single MatchBuyer and MatchBuyer a single Buyer.</p>
  
  <p>However what I want to do is this. Only include MatchNode's where enabled = true and Buyer: Status = 'Active'.</p>
  
  <p>Is this possible and can it be incorporated into the logic below as a .Where()? </p>