Swapping out base database

Thread is closed for posting
2 posts, 1 answers
  1. Daniel Woodard
    Daniel Woodard avatar
    13 posts
    Member since:
    Aug 2005

    Posted 05 Sep 2011 Link to this post

    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.

  2. Answer
    Jan Blessenohl
    Jan Blessenohl avatar
    707 posts

    Posted 06 Sep 2011 Link to this post

    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.

    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 >>

Back to Top