Say I have two database files, database1.sdf and database2.sdf, how can I make a select that joins tables from both?
I'm using C#.
Thanks!
There is no implicit support for querying across multiple databases with the SQL Server CE engine itself. However you could achieve a similar result by loading data from the two databases into an in-memory dataset from which you could then query the data.
No comments:
Post a Comment