Adding SQLite to a Windows Mobile Application
Using SQLite in a Windows Mobile Application provides a simple way to add pre-populated data for consumption by the application. There are a couple of configuration considerations when adding the database to the project.
1. Adding reference to SQLite.dll. After installing SQLite there will be a Compact Framework folder in the following path :C:\ProgramFiles\SQLite.NET\bin. This folder contains the System.Data.SQLite.dll that needs to be referenced.
2 The same path will also contain the dll which Windows Mobile will need to invoke the methods contained in the SQLite.dll. The following file needs to be added to the project which contains the main executable, SQLite.Interop.065.DLL.
Once the interop dll is in the project you can start using SQLite in the Mobile Application just as you would for any other application.