Sqlite Visual Studio 2008

Question

I am trying to work with Sqlite in Visual Studio 2008 to make a system for Windows Embedded Compact 7. The problem is that it always gives the following error:

A first chance exception of type 'System.MissingMethodException' occurred in System.Data.SQLite.dll
An unhandled exception of type 'System.MissingMethodException' occurred in System.Data.SQLite.dll   
Additional information: Can't find PInvoke DLL 'SQLite.Interop.066.DLL'.

No matter what I do, I’ve downloaded and tested several DLL’s. I can add the DLL System.Data.Sqlite as a reference, but when trying to add Sqlite.Interop.066.DLL generates the following error:

A reference to 'SQLite.Interop.066.DLL' could not added.

I also tried to put the DLL’s in the folder along with the executable in the emulator (Windows Embedded Compact 7) but also without success.

Anyone ever worked with Sqlite on VS 2008 could help me please? Pat me if you do a step by step :D

Answer 1

That Library SQLite.Interop.066.DLL is a library for Pinvoke, you do not reference it and yes includes it to be distributed in the directory of your application.

To include it, place it within your project:

1. Right-click your project and go to "Add" -> "Existing Item";
2. Select the file SQLite.Interop.066.DLL;
3. After included in the project, right-click on the file and go to "Properties";
4. Under "Build Action" select "Compile";
5. Under "Copy to Output Directory" select "Copy aways";