SQL compact error


  • Hi

    I´m using Visual Studio 2015 Comunity
    And i´m trying to migrate from sql server express to compact.
    I converted the database to sdf format and added it to the data connections in the toolbox.
    I installed the toolbox, sql server compact 4.0 SP1 and the entity framework for sqlserver compact.

    But when i try to add a data source i get the error "An error occurred while trying to retrieve the information from the database: The specified type is not supported by this selector."

    How can i resolve this situation?
    Thanks for the support.

    Monday, November 28, 2016 1:51 PM

All replies

  • What do you need the data source for? For typed Data Sets?

     just use the EDM Wizard (or EF Reverse POCO Template) to generate the C# classes based on your database

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

    Monday, November 28, 2016 4:22 PM