When WP7 is used to operate SQLite, the database cannot be opened.

When WP7 SQLite was recently developed, an error was reported when it was opened. The database was created first and then copied to the WP7 isolated store.

 

Iconnection = new sqliteconnection ("version = 3, uri = file:" + idbname );

After version = 3 and uri = file: is removed, no error is reported for open.

 

However, an error is reported when an insert statement is executed.

 

After finding the table for a long time, I failed to find it. Then I tried to create a table using the statement and insert it. No error is reported.

I looked at the files in the isolated store. There are two files, one of which is SQLite-Journal.

 

Try to test this file, add it to the project, copy it to the isolated store, and continue to insert data. No error is reported.

 

I don't know, but it's okay now.