System.Data.SQLite
View Ticket
Not logged in
Ticket UUID: d7183083ea025e3a753f0b7330def6ff20265f78
Title: Help making it work?
Status: Closed Type: Build_Problem
Severity: Critical Priority: Immediate
Subsystem: Build_Automation Resolution: Fixed
Last Modified: 2011-07-07 04:38:09
Version Found In: 1.0.72
Description:
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


mistachkin added on 2011-07-01 04:12:18 UTC:
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.