System.Data.SQLite

Hi, I'm trying to use sqlite.net in my project but am having difficulty making it build properly.

I've tried at least these ways:

 - installing from the precompiled installer for 1.0.72; the library wasn't visible as a data provider or in add references though it was in the GAC

 - building the solution - more or less worked but couldn't find a way to build it such that the database operations worked (i.e. it got into the C# wrapper but no further, claiming bad format dll)

 - referencing the project files from the solution in my program solution - problem same as above. [This is my preferred option as I can then get the appropriate release/debug or x86/x64 executable as required.]

 - installing the 1.0.66 version binaries; worked much better but when I tried to use Linq to create a database it failed with a syntax error near "DATABASE"

 - building the debug solution for 1.0.66 (to try to work out what SQL linq had asked to be executed) failed with the bad format error. [Can the syntax error be changed to include more of the text?]

I'm very frustrated! Can you help?

Ruth

<hr /><i>mistachkin added on 2011-07-01 04:12:18 UTC:</i><br />
The VS designer components have not been migrated yet.

The "bad format dll" error is probably a "BadImageFormatException" and is likely due to an x86/x64 architecture mismatch when it tries to load the SQLite.Interop.dll.

The most likely reason the DLL would not be present in the "Add References" dialog is due to a target framework mismatch (i.e. you cannot see .NET 2.0 assemblies in the GAC if it is a .NET 4.0 project and vice-versa).

The next release will address this issue by having specific download packages for each supported version of the .NET Framework.