System.Data.SQLite

Any word yet on the official release??

Not yet.  4.0 requires a fork in the provider.  I can't make a provider backward compatible with 2.0 and also compatible with 4.0.  It also requires a bunch of EF 4.0 provider-specific code changes which I haven't finished making yet.

 

 Hello,

 Do you have any idea how long it will take? Can we expect a release for October? Or later? An approximative date?

 

Nice work. Worked well for me. Added msvcr100.dll to setup release and all was good. A change i would like to suggest is that the setup says that .net framework 2.0 is required which is not true for the setup. You might want to change it to .net 4.0. Thanks again

Please provide details about the release date once it is planned.

Thanks.

Many thanks for your work as well of course the original author (and I suppose the author of SQLite itself).

I have need to compile the System.Data.Sqlite library for 64 bit renaming it to System.Data.Sqlite_64.dll as I must allow both libraries to exist in the same directory. I've fetch your project ( as I also need to enable .NET 4.0 - no mix mode activations allowed), but alas I've only been able to compile the libraries so that they produce the managed or netmodule versions without the embedded interop as is needed. Can I ask how it is possible to build the dlls as they are delivered (embedded interop) so that I can build a named instance of the 64 bit version?

Many thanks,

AM

 

Actually, ION123's 4.0 dedicated version (of the install) works fine for 32 bit. If he would compile a System.Data.SQLite_64.dll version and post that... I would be eternally grateful. Clients of ours must be able to choose x86 or 64 bit without having to deal with some /x64/... directory structure.

Found a problem when using TransationScope with EF.

The problem happens when you try to use the connection after a TransationScope is completed.

You will get a NullReferenceException, which happens because EF calls SQLiteConnection.EnlistTransaction(null) to unenlist the connection from all transactions. Calling EnlistTransaction with a null value is new in .NET 4.0, although found this which suggest it may also be possible in earlier versions.

Dont know how to implement unenlisting but changed the code to not throw an exception when the connection is not enlisted.

So here is a new build :)

Changes
* workaround for unenlist when using TransationScope
* SQLite 3.7.3

@Anonymole
The installer also installs a x64 version, when you dont want the x64 dir thing, you could only distribute the dll.

 ion123,

Yes, the x64 version I'm aware of and that it's named the same as the 32 bit version - that's the rub. I want to distribute BOTH versions into a single directory and have the user decided (or the app) which version to use. So I need a System.Data.Sqlite_x64.dll version of the library. And it has to be compiled as such not just renamed. I'd do it all myself but I can't seem to figure out how to embed the interops within the final product library when I recompile. Sorry, not a C++ kind of guy I'm afraid.

AM

When you recompile it with the solution the interop will be embedded. Attached an recompile as System.Data.Sqlite_x64.dll.

Thanks for your efforts.

Unfortunately I guess just renamining the output to System.Data.Sqlite_x64.dll in not enough:

#if !PLATFORM_COMPACTFRAMEWORK

    private const string SQLITE_DLL = "System.Data.SQLite_x64.DLL";

That probably needed to get renamed too.

As when I run it the library attempts to load the plain named version:

failed to open database - path: M:\MySqliteDatabase.sqliteDB

Unable to load DLL 'System.Data.SQLite.DLL': The specified module could not be found. (Exception from HRESULT: 0x8007007E)

 

If I could figure out why this fails:

Error    4    error MSB3073: The command ""C:\Program Files (x86)\Microsoft SDKs\Windows\v7.0A\.\Bin\sn.exe" -R "M:\WorkingFolder\dotnet\SQLite-1.0.66.1-source\SQLite.Interop\x64\Debug\SQLite.Interop.dll" "..\System.Data.SQLite\System.Data.SQLite.snk"
:VCEnd" exited with code 1.    C:\Program Files (x86)\MSBuild\Microsoft.Cpp\v4.0\Microsoft.CppCommon.targets    113    6    SQLite.Interop

Then I could probably do this myself.

I've given up on this and will not allow clients to use the 64 bit version so you needn't spend any additional time upon mybehalf - but thanks for your efforts both original and this latest go.

 

 

Do you have any updates for us Robert?  Is there currently any collaboration or review of ion123's solution?

Just learned about SQLite 2 days ago, and I'm stumbling upon a lot of the same errors many here have posted.

The version of SQLite I downloaded yesterday and have been working with is Version 1.0.66.0 and still specifies Runtime Version v2.0.50727.

There is a link on Page 2 to a release that is almost a year old, but a breakthrough around November of 2010.

Was a newer package ever put together that uses all of these features?

ion123:

So here is a new build :)

Downloaded and installed the attached setup (SQLite-1.0.66.1-vs2010-net4-setup.exe).
Getting a run-time exception in my upgraded from EF3.5 application:

System.DllNotFoundException: Unable to load DLL 'sqlite3': The specified module could not be found. (Exception from HRESULT: 0x8007007E)
   at System.Data.SQLite.UnsafeNativeMethods.sqlite3_open_v2(Byte[ utf8Filename, IntPtr& db, Int32 flags, IntPtr vfs)
   at System.Data.SQLite.SQLite3.Open(String strFilename, SQLiteOpenFlagsEnum flags, Int32 maxPoolSize, Boolean usePool)
   at System.Data.SQLite.SQLiteConnection.Open()

 How to solve this?

Beest regards,
Yuri

yurikus:

How to solve this?

 

Replying to my own question for posterity.

- Removed all .edmx from the project
- Removed references to System.Data.SQLite and System.Data.Linq from the project
- Cleaned up App.config
- Recreated connnection strings and model

worked on second compile.