How to remove the error "Cant find PInvoke DLL SQLite.interop.dll"

Posted by Shailesh Jaiswal on Stack Overflow See other posts from Stack Overflow or by Shailesh Jaiswal
Published on 2010-09-20T09:49:22Z Indexed on 2012/12/07 5:04 UTC
Read the original article Hit count: 311

Filed under:
|

I am developing windows mobile application. I am using the SQLlite database. I am using the following code to connect to this database as follows

                SQLiteConnection cn = new SQLiteConnection();
                SQLiteDataReader SQLiteDR;
                cn.ConnectionString = @"Data Source=F:\CompNetDB.db3";
                cn.Open();
                SQLiteCommand cmd = new SQLiteCommand();
                cmd.CommandText = "select * from CustomerInfo";
                cmd.CommandType = CommandType.Text;
                cmd.Connection = cn;
                SQLiteDR = cmd.ExecuteReader();

In the above case I am getting the error "Cant find PInvike DLL SQLite.interop.dll". I have added the DLL System.Data.SQLLite from the \SQLite.NET\bin\compactframework this folder. This is the folder which is installed by default when I installed the SQLite. In the same folder there is one DLL file named SQLlite.Interop.66.DLL. When I try to add reference to this dll it is giving error that dll can not be added. Are the two dlls SQLlite.Interop.dll & System.Interop.066.dll same ? In the above code how to solve the error "Cant find PInvoke.SQLite.Interop.dll" Please can you tell whether there is mistake in my code or I am missing something in my application?

© Stack Overflow or respective owner

Related posts about sqlite

Related posts about windows-mobile