I have a WPF application running with .Net3.5 using FluentNHibernate, and all works fine. When I upgraded
to VS2010 I ran into some odd problems, but after changing
to use x64 variant of SQLite it worked fine again.
Now I want
to change
to use .Net4, but this has turned into a more painful experience then I expected.. When calling FluentConfiguration.BuildConfiguration I get an exception thrown:
FluentConfigurationException unhandled
An invalid or incomplete configuration was used while creating a SessionFactory. Check PotentialReasons collection, and InnerException for more detail
The inner exception gives us more information:
Message = "Could not create the driver from
NHibernate.Driver.SQLite20Driver,
NHibernate, Version=2.1.2.4000, Culture=neutral, PublicKeyToken=aa95f207798dfdb4."
It has an InnerException again:
Exception has been thrown by the target of an invocation.
Which again has an InnerException:
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.
Now -
to me it sounds like it doesn't find System.Data.SQLite.dll, but I can't understand this. Everywhere this is referenced I have "Copy Local", and I have verified that it is in every build folder for projects using SQLite. I have also copied it manually
to every Debug folder of the solution - without luck.
Notes:
This exact same code worked just fine before I upgraded
to .Net4.
I did see some x64 x86 mismatch problems earlier, but I have switched
to use x86 as the target platform and for all referenced dlls. I have verified that all files in the Debug-folder are x86.
I have tried the precompiled Fluent dlls, I have tried compiling myself, and I have compiled my own version of Fluent using .Net4.
I see that there are also others that have seen this problem, but I haven't really seen any solution yet.
After @devio's answer I tried adding a reference
to the SQLite dll. This didn't change anything, but I hope I made it right though.. This is what I added
to the root node of the app.config file:
<runtime>
<assemblyBinding xmlns="urn:schemas-microsoft-com:asm.v1">
<qualifyAssembly partialName="System.Data.SQLite" fullName="System.Data.SQLite, Version=1.0.60.0, Culture=neutral, PublicKeyToken=db937bc2d44ff139" />
</assemblyBinding>
</runtime>
Anyone out there using Fluent with .Net4 and SQLite successfully? Help! I'm lost...
