I have data being inserted into multiple databases with the same schema. The multiple databases exist for performance reasons.

I need to create a WCF service that a client can use to query the databases. However from the client's point of view, there is only 1 database. By this I mean when a client performs a query, it should query all databases and return the combined results.

I also need to provide the flexibility for the client to define its own queries. Therefore I am looking into WCF Data Services, which provides the very nice functionality for client specified queries.

So far, it seems that a DataService can only make a query to a single database. I found no override that would allow me to dispatch queries to multiple databases.

Does anyone know if it is possible for a WCF Data Service to query against multiple databases with the same schema?