Nhibernate dialect and driver to use for connecting to a sybase database in .net

Question

In version 2 of Nhibernate, I had it working with below fluent nhibernate configuration:

<property name="dialect">NHibernate.Dialect.SybaseAdoNet12Dialect,NHibernate</property>
<property name="connection.driver_class">NHibernate.Driver.SybaseAdoNet12ClientDriver</property>

Now I want to use the Nhibernate 3.1 version and both the above dialect and driver are missing.

I am a little confused. I see there is a dialect SybaseASA9Dialect but I could not find out what driver goes with it.

There is also a lot of blogs about using the sqlanywhere implementation, but it requires adding the dlls like iAnywhere.Data.SAClient from sybase which have licenses attached to it and makes my problem bigger.

Can someone give me a simple dialect, driver configuration to use with the nhibernate 3.1 for connecting to sybase?

Thanks so much!

Hey Vishal, it seems to me; that you have solve your problem: I am having the same problem stackoverflow.com/questions/17608910/… maybe you can give me a tip — Higune

Michele Lepri Michele Lepri · Accepted Answer · 2011-11-30T13:27:58

I can only say that drivers are:

NHibernate.Driver.SybaseAsaClientDriver
NHibernate.Driver.SybaseAseClientDriver
NHibernate.Driver.SybaseSQLAnywhereDriver

And dialects are:

NHibernate.Dialect.SybaseSQLAnywhere10Dialect
NHibernate.Dialect.SybaseSQLAnywhere11Dialect

This is in 3.2, but I think in 3.1 should be the same.

Nhibernate dialect and driver to use for connecting to a sybase database in .net

1 Answers