I am using ADO.NET provider installed by "SQLite-1.0.64.0-setup.exe".
I am developing client application using VS2008 and compact framework 3.5. Here is the code
using
System.Data.SQLite;
public
class GlobalDFinderMethods
{
private static SQLiteConnection sql_con;
private static SQLiteCommand sql_cmd;private static SQLiteDataAdapter DB;
private static DataSet dsSQLite = new DataSet();private static DataTable dtSQLite = new DataTable();private static void SetConnection()
{
sql_con =
new SQLiteConnection("Data Source=MApp.db;Version=3;New=False;Compress=True;");
}
public static void ExecuteQuery(string txtQuery)
{
SetConnection();
sql_con.Open();
sql_cmd = sql_con.CreateCommand();
sql_cmd.CommandText = txtQuery;
sql_cmd.ExecuteNonQuery();
sql_con.Close();
}
I get error "Can't find PInvoke DLL 'SQLite.Interop.064.DLL'" when I tried to run the application on WM 6 Professional emulator on sql_con.Open(); statement.
I tries to add reference of "SQLite.Interop.064.DLL" file from "C:\Program Files\SQLite.NET\bin\CompactFramework", but VS 2008 does not allow me to do that.
Please help me out.