Hi Kendall Bennett,
As long you have a single database (with multiple schemas) you will be able to write similar queries with OpenAccess. However you cannot achieve a similar scenario with multiple databases. When having the archive tables in a different schema (and preferably with a prefix) you will face no problems. However you should know that you will only be able to write queries over classes (objects) from one database instance as the context is tightly bound with a connection string.
I hope this proves to be helpful. Do not hesitate to let us know if you face further trouble.
All the best,
the Telerik team
Do you want to have your say when we set our development plans?
Do you want to know when a feature you care about is added or when a bug fixed?
Telerik Public Issue Tracking
system and vote to affect the priority of the items