Search code examples
c#wpfvisual-studio-2010sql-server-ce

Cannot find SQL Server CE 4.0 in Data Source

I have both SQL Server CE 3.5 and 4.0 installed. In VS2010 WPF, when I add new connection and want to create a database with SQL Server CE 4.0, I only see Microsoft SQL Server Compact 3.5, but not 4.0.

Why?

This is a WPF desktop application, not a Web Project.

Solution

  • you have to update your Visual Studio 2010 to SP1 (from here) to do so. Or you can try to use this tool.