Use Visual Studio to open a Windows Phone Database

Windows Phone supports database development, but operations such as database generation, data addition, deletion, modification, and query must be performed throughCode. If we want to modify or view data temporarily, We need to write the corresponding Temporary code, which is inconvenient.

The following steps allow you to add, delete, modify, and query Windows Phone databases without code.

1. Generate a database and corresponding data tables through code. If not, refer to http://msdn.microsoft.com/zh-cn/library/hh202865 (vs.92). aspx.

2. Connect to the simulator through the tool (sdk's self-contained isll.exe or Windows Phone power tools) and copy *. SDF in the independent storage to the local computer.

3. in vs 2010, find Server Explorer, click Connect to database above, select Microsoft SQL Server compact 3.5 for datasource, and click browse to find the saved *. to open the SDF file.