NHibernate + SqlServerCE

Question

I have problem with this exception:

Hibernate.HibernateException : Could not create the driver from Hibernate.Driver.SqlServerCeDriver.
----> System.Reflection.TargetInvocationException : Exception has been thrown by the target of an invocation.
----> NHibernate.HibernateException : The IDbCommand and IDbConnection implementation in the  ssembly System.Data.SqlServerCe could not be found. Ensure that the assembly System.Data.SqlServerCe is located in the application directory or in the Global Assembly Cache. If the assembly is in the GAC, use <qualifyAssembly/> element in the application configuration file to specify the full name of the assembly.

I tried everything. I googled a lot.

System.Data.SqlServerCe.dll is in debug directory. Is local referenced, is not i GAC. I have copy local set true. In debug directory is all other needed sql*.dll. I tried x86 compilation but nothig.

This is my nhibernate config:

<?xml version="1.0" encoding="utf-8" ?>
<hibernate-configuration xmlns="urn:nhibernate-configuration-2.2">
  <session-factory>

    <property name='proxyfactory.factory_class'>NHibernate.ByteCode.Spring.ProxyFactoryFactory, NHibernate.ByteCode.Spring</property>
    <property name="connection.provider">NHibernate.Connection.DriverConnectionProvider</property>
    <property name="dialect">NHibernate.Dialect.MsSqlCeDialect</property>
    <property name="connection.driver_class">NHibernate.Driver.SqlServerCeDriver</property>

    <property name="show_sql">true</property>


    <!-- mapping files -->

  </session-factory>
</hibernate-configuration>

NHibernate version 3.0 beta 1, SqlServerCe version 3.5 SP1

My idea: Nhibernate still look in GAC, becouse a had installed SqlServerCe, after uninstall the problem starts. How can I say to NHibernate: "please look take this dll?":)

John C · Accepted Answer · 2011-10-29 07:42:44Z

11

You (or the NHibernate dll) are referencing a different version of the System.Data.SqlServerCe dll in the project than what it is expecting. For instance, NHibernate may be referencing the .NET 3.5 version of the dll, but you have the .NET 4.0 version of the dll in the GAC or local bin directory. You can instruct the .NET framework to use a specific AssemblyBinding to correct the problem. Type the following in your config file to fix it.

    <runtime>
    <assemblyBinding 
    xmlns="urn:schemas-microsoft-com:asm.v1"><qualifyAssembly 
   partialName="System.Data.SqlServerCe" fullName="System.Data.SqlServerCe, 
   Version=3.5.1.0, Culture=neutral, 
   PublicKeyToken=89845dcd8080cc91"/>
    </assemblyBinding>
   </runtime>

answered Oct 29, 2011 at 7:42

John C

93011 silver badges13 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Devgig Over a year ago

Did not need this on the newest version of nHibernate, but could not replace an older version and this fixed my issue.

Pieter van Ginkel · Accepted Answer · 2010-11-07 13:26:55Z

0

Try to load the assembly with Assembly.LoadFile with the complete path to the DLL before NHibernate requests it.

NHibernate will load the assembly using Assembly.Load("NHibernate.Driver.SqlServerCeDriver") which will probably look in the GAC. If you force to load it from a file, the Assembly.Load will notice it's already loaded and pick the one you loaded.

answered Nov 7, 2010 at 13:26

Pieter van Ginkel

29.7k8 gold badges77 silver badges114 bronze badges

6 Comments

Simon Over a year ago

I am getting this error: System.IO.FileLoadException : Could not load file or assembly 'System.Data.SqlServerCe, Version=3.5.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91 or one of its dependencies. The system cannot find the specified file. I tried to load depended dll but i get this error, when I try to load sqlceca35.dll : System.BadImageFormatException: The module should contain assembly manifest. (Exception to the HRESULT: 0x80131018)

Simon Over a year ago

Maybe this can help, but i dont know where to write it.<qualifyAssembly partialName="System.Data.SqlServerCe" fullName="System.Data.SqlServerCe, Version=3.5.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91 "/ >

Pieter van Ginkel Over a year ago

It's correct that sqlceca35.dll gives that error. That shouldn't be loaded using Assembly.Load and is used with p/invoke. But, concerning the first error, can you please show the Assembly.LoadFile() line you tried this with? Maybe that helps.

Simon Over a year ago

Assembly.LoadFile(@"C:\Users\Simon\Workspace\C#\Works\MyProject\ branches\MyProject\MyProject.DatabaseLayer\bin\Debug\System.Data.SqlServerCe.dll");

Pieter van Ginkel Over a year ago

Sorry, I have no clue. Two suggestions though: firstly, the exception may contain details on what went wrong. Try to inspect all the details of the exception to see whether that helps. If all else fails, try ProcMon technet.microsoft.com/en-us/sysinternals/bb896645.aspx and inspect the logs.

|

markb · Accepted Answer · 2012-09-13 09:47:25Z

0

You can also set the use specific version flag to false on the properties in VS for that reference and set copy local to true

answered Sep 13, 2012 at 9:47

markb

891 silver badge7 bronze badges

Comments

Simon · Accepted Answer · 2010-12-07 10:26:13Z

-1

I switched to sqllite. Thats work. Maybe consider to change byte code. I used spring byte code, maybe castle is better....

answered Dec 7, 2010 at 10:26

Simon

3,2855 gold badges38 silver badges47 bronze badges

Collectives™ on Stack Overflow

NHibernate + SqlServerCE

4 Answers 4

1 Comment

6 Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

1 Comment

6 Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related