I'm trying to connect to an existing *.sdf file from my solution using these leads but Add Connection dialog box doesn't open, so I try to connect manually: go to "Data sources", click "Add new" and choose Microsoft SQL Database File, but while choosing db file at first filter doesn't allow me to choose my *.sdf file. When I set filter to "All files" and select my file, I get exception: "Failed to determine the version of database file".
So what can I do to connect to this database?
SQL Server Compact/SQLite Toolbox is the most usefull tool for SQL Compact. I hope, it solve all your problems.