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?
<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.