System.Data.SQLite

Hello,

 Yesterday, I have installed VS2010 Beta. And add references for the 2 dll of SQLLite.

Then created a project. And created entities. Finally, written some instructions in Linq using the SQL LITE database.

I get an error message for a problem of compatibility between Framework version (2.0... and 4.00)

Do you know if there will be a new release of SQLLITE compatible with .NET FRAMEWORK 4.0 and VS2010?

 

Regards,

Shortstory

It's not high on my priority list right at the moment.  When VS2010 comes closer to release I'll be updating the library to work with it.

Thank you first for your quick answer.

But this is sad that there will be no new release before next year (If I am correct, final release of VS2010 is planned for March 2010). I had the goal to developp an application using VS2010 Beta 2 and SQLite. I was really looking for a light database with good performance. And SQLite is the perfect choice.

Have a nice evening.

Regards,

Shortstory

I want to weigh in on this as well. Most developers I know have already started using Visual Studio 2010 and upgrading their projects to be used with this IDE as well. I second the motion that a VS2010 library would be a great thing to have so that we can go ahead and start at least testing it for bugs. Thanks. Wes

I spent a huge amount of time writing and rewriting code during the first incarnation of ADO.NET EF due to the internal code changes they kept making from beta to beta.

This time around I just don't have the time.  When the next VS2010 edition comes out, I'll start plugging in all the code and wiring things up.  If someone else wants to lead the way on the VS2010 front, I'm more than happy to review.

Hi all,

If there is a possibility at all of putting a beta together I too think you should consider it. System.Data.SQLite.DLL is such a useful little gem :-)

In the meantime there seems to be a temporary solution that works for me, see my blog post here: http://www.meadow.se/wordpress/?p=393

This may work for others as well.

 /Emil

 

Hello,

As said above, loading the System.Data.SQLite.dll dll from .NET 4 throws an exception. I can confirm that the workaround by modifying the application config file worksHowever, there is another solution. Apparently recompiling the project and targeting .NET 4 works.

• In order to compile sqlite.net with vs2010 beta 2 you can convert the 2008 solution. Before you convert the project files, you will need to remove the compact framework targets or the conversion will fail telling you that the compact framework is not supported.
• After the projects are converted set the targeted framework to .net 4

I could not get the netmodule to compile in vs2010 (it complained that the OutputType was not supported) but the netmodule will build when build from the command line with msbuild. The rest of the projects compile fine.

To get the designer to compile you will need to add a file called source.extension.vsixmanifest.The next thing I encountered was a System.TypeLoadException (Inheritance security rules violated by type). This could be solved by adding the following line to System.Data.SQLite/AssemblyInfo.cs
[assembly: SecurityRules(System.Security.SecurityRuleSet.Level1)]There are some more minor changes to the project files to get it to compile but in the end it compiles with .NET 4 support and works without workarounds when used from .NET 4.

 hi,

 i have tried what you are suggesting, but i can't get it to work. when i run the code to fluently configure and build a session factory, i get a runtime error stating that the sqlite.interop.dll could not be loaded. i had to "mess around" a little with output directories and project properties in the sqlite solution to be able to build without errors, but at the end it did. i have not referenced the sqlite.interop.dll in my project - if i try to, i get an error message saying that it's not a valid assembly/com file.

 do you have any suggestions on what i could do? or even better, are your working assemblies available on the net somewhere?

thanks

 /tomas

Working binaries and changes to source are attached

Dont know if evrything is correct this way, use at your own risk.

Changes to the source:
- convert the project to vs2010 and resolve some built errors
- updated the sqlite engine to 3.6.21 with the changes from here http://sqlite.phxsoftware.com/forums/t/2073.aspx
- added a Trace event for sqlite3_trace
- the TranslateIntoIn comes from looking at SqlClient with reflector

note: you should uninstall any existing version first. somehow the installer just hangs when there is an existing installation. also when you install this version, it wont work anymore in vs2008.

 Also found this post:

http://blogs.msdn.com/adonet/archive/2009/10/22/new-features-in-entity-framework-impacting-providers.aspx

It apears that for some futures some more work needs to be done.

 

 wonderful!

 however,  i'm having some trouble installing. i get the hang error you describe, but i can't find any sqlite references in the programs and features list. where will i find the uninstall file for any previous versions never mind - i got it to work! great many thanks! =)

 but the installer still says it's for 2.0/3.5 ;)

Recompiled it with VS2010 RC

Changes
- Installer does not hang anymore.
- Updated the sqlite engine to 3.6.22.

lycken:

but the installer still says it's for 2.0/3.5 ;)

Updated the version nummer to 1.0.65.1 and changed the installer to say 4.0 :)

 

 ion123: When I try to install this, the installer works for a little bit and then pops up an Open file dialog to C:\Program Files (x86)\SQLite.NET\bin\Designer, and asks for the file System.Data.SQLite.DLL. I thought it's supposed to be installing that file.

 I'm running Windows 7 x64 and VS2010 RC.

EDIT: I tried pointing it to System.Data.SQLite.DLL in C:\Program Files (x86)\SQLite.NET\bin\x64, but it just opens it right back to the same location (C:\Program Files (x86)\SQLite.NET\bin\Designer). Cancelling results in the following unhandled exception:

 System.ArgumentException was unhandled
  Message=Unable to find or load System.Data.SQLite.DLL
  Source=install
  StackTrace:
       at install.InstallDesigner.get_SQLite()
       at install.InstallDesigner.FixXmlLibPaths(Boolean install, String version)
       at install.InstallDesigner.GlobalAddRemove(String version)
       at install.InstallDesigner..ctor()
       at install.Program.Main()
  InnerException:
 

 Uninstalling the previous version first worked.

 Since I still need the old version for VS2008, I just installed them to separate folders.

Thanks for the VS2010 RC version.

I've updated my app: Works like a charm.

Thanks again.