Problems with modifying SQL CE 3.5 db's data RRS feed


  • I figured it out. 

    Right-Click on the .sdf database and select properties. 

    Change Build Action to None. 

    Change the App.Config so that the connection string points to the exact location of the .sdf.   I.e. data source=D:\Projects\project1\bin\debug\LOCAL.sdf

    Use that while you are developing.

    When you are ready to deploy the product, I think you should change the Build Action back to Content and app.config back to using |DataDirectory| in the data source for an easier deployment to customers.



    Saturday, April 17, 2010 8:03 PM