title: Entity Framework 4.1 - Override Entity (DBSet) with Filter
body: <p>I'm trying to do something which should be relatively easy, but i just dont know how to construct it.</p>
  
  <p>I have a Generated Entity which I'd like to override by adding a Linq Where statement. </p>
  
  <p>Herewith the partial for the Context : </p>
  
  <pre><code>public partial class MyEntities: DbContext
  {
      public MyEntities()
          : base("name=MyEntities")
      {
      }    
      public DbSet&lt;Assignee&gt; Assignees { get; set; }
  }
  </code></pre>
  
  <p>I've created a new partial of MyEntities and tried the following </p>
  
  <pre><code>public override DbSet&lt;Assignee&gt; Assignees 
  {
      get
      {
          return this.Assignees.Where(z =&gt; z.IsActive == true);
      }
      set; 
  }
  </code></pre>
  
  <p>but this throws an ambiguity error (which is obvious).</p>
  
  <p>How can I accomplish this?</p>
  
  <p>Thanks </p>