System.Data.SQLite

I wanted to convert a couple of my projects using the provider to 4.0 to use some new features, but when I did so, the ctor of my ObjectContext subclass started failing with: System.ArgumentException: The specified store provider cannot be found in the configuration, or is not valid. I'm assuming (at the moment) that this is because the provider doesn't register as an "ADO.NET 4" provider? (just a guess). 1) if a specific 4.0 version is required, is it on the schedule and is there an ETA? 2) if a specific 4.0 version is NOT required, what are the steps to get the existing provider working for 4.0 projects? Thanks!!

You have to add a section to your .config file to be able to load the 2.0 assembly in 4.0.  I won't have a 4.0-built assembly out for a bit yet.

<?xml version="1.0" encoding="utf-8" ?>
<configuration>
  <startup useLegacyV2RuntimeActivationPolicy="true">
  <supportedRuntime version="v4.0" />
</startup>
</configuration>

Talking about .net 4.0, do you have any plan to support the new features provided with Entity Framework 4? I'm especially thinking about their "Model First" approach which would be very useful for unit testing as we could then use an in-memory SQLite database to mock the real SQL Server database without having to clean up the data after every run.

I'm currently working on the SQL script generation from the model for SQLite and it doesn't seem to be too hard.

Thanks

Hi,
I'm trying to change my application from .Net3.5 to .Net4, and I run into problems with System.Data.SQLite.dll.
Feels like I've tried everything now - including the App.config edit you give here, but it doesn't fix the problem.

I am using SQLite through FluentNHibernate and NHibernate, and I get the following exception thrown in my face when
setting up the connection using a SQLite DB:

"Could not create the driver from NHibernate.Driver.SQLite20Driver, NHibernate, Version=2.1.2.4000, Culture=neutral, PublicKeyToken=aa95f207798dfdb4."

The InnerException suggests that there is some problem with IDbConnection and IDbCommand:

"The IDbCommand and IDbConnection implementation in the assembly System.Data.SQLite could not be found. Ensure that the assembly System.Data.SQLite is located in the application directory or in the Global Assembly Cache. If the assembly is in the GAC, use element in the application configuration file to specify the full name of the assembly."

Do you have any idea what I can do to get around this problem?

(More info on StackOverflow: http://stackoverflow.com/questions/2697795/problems-using-fluentnhibernate-sqlite-with-net4)

Actually - nevermind. It seems to be working after all. Looks like a little x64 x86 mismatch managed to sneak in..

But +1 for a System.Data.SQLite.dll with .Net4 support! 

 Hi Robert,

When do you plan to release a .NET 4 version of System.Data.SQLite? One month, two... ?

Do you have a roadmap?

Thank you very muh.

 

Cyber Sinh

why wait, make it so! ;}

Robert Simpson:

<?xml version="1.0" encoding="utf-8" ?>

<configuration>
  <startup useLegacyV2RuntimeActivationPolicy="true">
  <supportedRuntime version="v4.0" />
</startup>
</configuration>

 

 Thanks you very much, now I can use VS 2010 Express :)

Hi there, iam running Express 2010, but it seems that i just cant find the .config file where u should ad this " " how and what file is it that i have to change ?

Its your "app.config" file in your project's root folder, if its not there; just create a text file and save it as "app.config" then make sure to add it to your project...

How do you add that to your project ? i am new to this, i know how to do simple programming but this is a little advance :) Cant somone make a smaple project file and put into a rar file and upload ? that works with 2010 ? that had been great :)

• Right click the project in the solution explorer
• Add, New Item ...
• Select "Application Configuration File" in the window that comes up
• Paste the sample into the file this creates
  

Hi Robert,

Is it possible to get an 4.0 x86 build? Because I have following problem in my scenario:

=> interop c# 4.0 assembly uses your sqlite 2.0 assembly

=> my vb script gets an instance of the interop c# 4.0 class

=> at this point I get the error. I can't create an instance, because the CLR doesn't run in the mixed mode.

=> I can't add a config file to set the useLegacyV2RuntimeActivationPolicy flag, because there is no exe! Actually there is one, but you won't set such a config file for cscript.exe or wscript.exe in the windows system32 folder!

 

Or is there any other way to solve my problem?

Thanks,

 

Thomas Mathis

Bica AG, Switzerland