O'Reilly logo

Windows® Phone 8 Unleashed by Daniel Vaughan

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Viewing and Modifying an SQL CE Database File

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).

Image

FIGURE 29.7 Visual Studio’s Add Connection dialog.

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required