This question is locked. New answers and comments are not allowed.
Daniel Woodard
Top achievements
Rank 1
Rank 1
Daniel Woodard
asked on 05 Sep 2011, 11:13 PM
I have an application using OpenAccess and have to be able to support full SQL Server and SQL Compact. Depending on the user's environment, I will need to use one or the other.
Is it possible to just change the connection string to point to one or the other of the databases and have OpenAccess still operate?
The schemas are the same between the to databases.
Thanks.
Is it possible to just change the connection string to point to one or the other of the databases and have OpenAccess still operate?
The schemas are the same between the to databases.
Thanks.
1 Answer, 1 is accepted
0
Accepted
Hi Daniel Woodard,
Yes, that will be possible, change the connection string plus the backend type on the backend configuration instance that you use to create the context.
It is better to implement against CE, esp. the missing sub-selects in CE makes it necessary to tweak the Linq statements partially.
Regards,
Jan Blessenohl
the Telerik team
Yes, that will be possible, change the connection string plus the backend type on the backend configuration instance that you use to create the context.
It is better to implement against CE, esp. the missing sub-selects in CE makes it necessary to tweak the Linq statements partially.
Regards,
Jan Blessenohl
the Telerik team
Thank you for being the most amazing .NET community! Your unfailing support is what helps us charge forward! We'd appreciate your vote for Telerik in this year's SQL Server Community Awards. We are competing in TWO categories and every vote counts! VOTE for Telerik NOW >>