SQL SC 4.0 with Visual Studio 2012


  • Hello all,

    I'm using a WPF project in VS 2012 with SQL SC 4.0 .sdf file, but I can't connect to (open) it via neither SQL Server Compact Toolbox nor by double-clicking the file in Solution Explorer (it says "The operation could not be completed"). When I try to open the file from SQL SC Toolbox it says "The version 4.0 Visual Studio DDEX provider is not installed, cannot add connection". I've installed both the SQL SC 4.0sp1 and and 3.5sp2 db engines,and I've also added a reference to the "System.Data.SqlServerCe.Entity.dll" (SC 4.0 version) assembly. The file .sdf is ok, I've tried it outside VS. Could anybody please tell me What I'm doing wrong? I'm quite new to this.
    Saturday, November 16, 2013 10:41 PM


  • Your VS install is broken, suggest you repair it.

    Please mark as answer, if this was it. Visit my SQL Server Compact blog

    • Marked as answer by TheCarloSsS Monday, November 18, 2013 6:59 PM
    Sunday, November 17, 2013 8:07 AM