Migrate from SQL express to compact


  • Hi,

    I have a winforms app in C# witch i completed and want to publish, now i have a problem, i used SQL express and the app must be local without sql server express instalation needed:
    I use Visual Studio 2015 Comunity
    I installed sql server compact 4.0 created the database in .sdf format.
    And got the following connection string:
    public static SqlConnection con = new SqlConnection(@"Data Source=|DataDirectory|db.sdf");
    Now i want to create a new datasource that points to this db and get an error when trying to select sql server compact:
    "The conection string property has not been initialized"

    Can anyone help?

    Thanks in advance,

    Wednesday, November 23, 2016 5:00 PM

All replies