Finally made it work, but still not automatic...
I added those projects from 1.0.81.0 but their resulting DLLs weren't copied
to the target directory. I don't know why. I could copy them manually there,
though. The DLL from SQLite.Interop.2010 was named System.Data.SQLite.dll
and I had to manually rename it to SQLite.Interop.dll and copy it to the
target directory. I kind of expected this to happen automatically. :-/
I also added SQLite.Designer.2010.
And I had to add this to my app.config:
<configuration>
<system.data>
<DbProviderFactories>
<remove invariant="System.Data.SQLite"/>
<add name="SQLite Data Provider" invariant="System.Data.SQLite"
description=".Net Framework Data Provider for SQLite"
type="System.Data.SQLite.SQLiteFactory, System.Data.SQLite" />
</DbProviderFactories>
</system.data>
</configuration>
Once I did that, my application finally could talk with SQLite 3.7.13! :D
But, alas, shared cache functionality was not available.
I guess I have to revert to using file-based sqlite3 and accept sluggish
performance. For now. At least I hope we get shared memory sqlite3 databases
for C# soon. :)
Seeing as the already tried things didn't work, I might as well revert to
the standard compiled distribution. At least it is less of a hassle to work
with. :-P
--
Bernhard
-----Original Message-----
From: sqlite-users-boun...@sqlite.org
[mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Bernhard Mogens Ege
Sent: 24. juli 2012 14:43
To: 'General Discussion of SQLite Database'
Subject: Re: [sqlite] Compiling System.Data.SQLite with latest sqlite3.dll
I have now done nearly exactly as you wrote, with these differences:
I have added the project System.Data.SQLite.Linq.2010 as well and made it
depend on System.Data.SQLite.2010.
I did not disable the XML generation.
I made my project depend on System.Data.SQLite.2010 and
System.Data.SQLite.Linq.2010.
I can build the project just fine, but I cannot run it. I get this error:
Unhandled Exception: System.Reflection.TargetInvocationException: Exception
has been thrown by the target of an invocation. --->
System.ArgumentException: The specified store provider cannot be found in
the configuration, or is not valid. ---> System.ArgumentException: Unable to
find the requested .Net Framework Data Provider. It may not be installed.
at System.Data.Common.DbProviderFactories.GetFactory(String
providerInvariantName) at
System.Data.EntityClient.EntityConnection.GetFactory(String providerString)
I have no other System.Data.SQLite installed on my system and hence the GAC
is does not contain SQLite.
Do I need to do something special for the actual code from SQLite to be
included in my project (i.e. 1 assembly or referenced dlls)?
--
Bernhard
-----Original Message-----
From: sqlite-users-boun...@sqlite.org
[mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Bernhard Mogens Ege
Sent: 23. juli 2012 12:05
To: sqlite-users@sqlite.org
Subject: [sqlite] Compiling System.Data.SQLite with latest sqlite3.dll
I am trying to figure out how to compile System.Data.SQLite and in the
process update sqlite from 3.7.12.1 to 3.7.13 as I need the shared cache
option for memory connections.
And when I write 'trying' I am having trouble figuring out where exactly
System.Data.SQLite picks up sqlite3.dll from. The source code doesn't
include it and the installer also doesn't include it, but it must be
somewhere.
Is it even safe to update System.Data.SQLite 1.0.81.0 with sqlite3.dll
3.7.13 and will the shared cache feature work?
Also, compiling System.Data.SQLite for .NET 4.0 results in some
warnings/errors. Are they safe to ignore?
Warning 1 The parent file, 'SR.resx',
for file 'SR.Designer.cs' cannot be found in the project file.
System.Data.SQLite.2010
Warning 2 Load of property 'OutputType'
failed. System.Data.SQLite.Module.2010
Warning 3 The parent file, 'SR.resx',
for file 'SR.Designer.cs' cannot be found in the project file.
System.Data.SQLite.Module.2010
Warning 4 Error 2005: Mapping
Association 'FK_InternationalOrders_OrderID_OrderID' is redundant: Its
referential integrity constraint provides sufficient information. You can
safely delete the mapping information for this association.
C:\Users\bme\Documents\Visual Studio
2010\Projects\sqlite-netFx-source-1.0.81.0\testlinq\NorthwindModel2010.edmx
793 800 testlinq.2010
Warning 5 Error 2005: Mapping
Association 'FK_OrderDetails_OrderID_OrderID' is redundant: Its referential
integrity constraint provides sufficient information. You can safely delete
the mapping information for this association.
C:\Users\bme\Documents\Visual Studio
2010\Projects\sqlite-netFx-source-1.0.81.0\testlinq\NorthwindModel2010.edmx
801 809 testlinq.2010
Warning 6 Error 2005: Mapping
Association 'FK_OrderDetails_ProductID_ProductID' is redundant: Its
referential integrity constraint provides sufficient information. You can
safely delete the mapping information for this association.
C:\Users\bme\Documents\Visual Studio
2010\Projects\sqlite-netFx-source-1.0.81.0\testlinq\NorthwindModel2010.edmx
810 818 testlinq.2010
Warning 7 The referenced component
'mscorlib' could not be found.
Warning 8 The referenced component
'mscorlib' could not be found.
--
Bernhard
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
