After an SQL CE file has been retrieved from isolated storage, it can be opened in an application such as Visual Studio or Microsoft SQL Server Management Studio.
To open an .sdf file in Visual Studio follow these steps:
1. Within Visual Studio, right-click the Data Connections node in the Server Explorer and select Add Connection. The Add Connection dialog is displayed (see Figure 29.7).
2. Within the Add Connection dialog, set the Data Source to Microsoft SQL Server Compact 3.5.
3. Browse and locate the .sdf file using the Connection Properties ...