Sqlite windows phone 8

For this example we will create a person class:. The Id property is marked as the Primary Key and will auto increment as values are added to the table.

In the app. In the constructor we check if the database exists and if it does not we create it. Since there is no file exists method on the windows phone we try and try and open the file. If the file does not exist we get an exception. In the MainPage. These buttons will be used to add a record to the database, edit it, and delete it. Office Office Exchange Server. Not an IT pro? United States English. Post an article.

Subscribe to Article RSS. Click Sign In to add the tip, solution, correction or comment that will help other users. Report inappropriate content using these instructions. PrimaryKey, SQLite. InitializeComponent ;. InitializePhoneApplication ;. The following section explain how. Start by adding the SQLite-net package 1. This is the wrapper project that will replace the C -SQLite functionality. Use the following steps to download and add the project:. Additionally, to indicate to SQLite-net that we want to use the sqlite-net-wp8 project added in earlier steps, we need to add a compiler directive to the Windows Phone app project:.

After you have set up everything, you can test the SQLite database functionality by using the sample code referred to in the GitHub wiki. The information in this link is about Windows Store apps, but it should be helpful for Windows Phone apps after you have completed the steps in this post. Sign in Email. Forgot your password? Search within: Articles Quick Answers Messages. Technical Blog.

View Original. Tagged as Mobile. Stats Please Sign up or sign in to vote. Select Online from the left pane. Download and install the package. Note: You may need to restart Visual Studio after package installation.

The sqlite-net package 1.