Using Entity Framework with Archive databases
<p>I am using Entity Framework 6 to do basic CRUD operations, which is all fine and good.  I need to be able to select my objects within a date range, which again, is pretty straightforward HOWEVER, these objects can be spread over several databases that are essentially warehouses for the previous year's data.  Once we're looking for them in a date range. </p>

<p>Example we want all the Foo objects between 1st of January 2015 and 9th of November 2016; the Foo data from 2015 would be in a different database.  This goes all the way back to 2005.  Not all the Schemas are identical.  </p>

<p>We <em>could</em> have 11 EF projects, or 11 contexts and 11 connection strings.  This solution has the problem of having to add code every year when the archive is created.  This seems like a hack.  Swapping over to Azure storage methods isn't an option for the foreseeable future.</p>

<p>Any more graceful solutions?</p>