title: Entity Framework Database First get only active rows by default
body: <p>We recently added a new boolean column ACTIVE to our Employee table. Therefore, when a user wants to delete an employee in the table, the record will be "soft deleted" (ACTIVE field will be set to false instead of the row being removed completely.)</p>
  
  <p>However, the table is being used everywhere in the app and we don't want to add .Where(employee => employee.ACTIVE) every time we query the table. Is there a way we can get these ACTIVE rows by default, maybe put the Where clause at the root level somewhere? (we don't care about inactive employees in the live app, but we need those records in the database.)</p>
  
  <p>We use Database First EF, so we won't be able to use the same Soft Delete strategies in Code First (Interceptors).</p>
  
  <p>Thanks for your help!</p>