Is there a better implementation for SybaseDialect

Question

We have upgraded to NHibernate 3.0 with Fluent-NHibernate.

In version 2.1.2 we where able to use the SybaseDialect for ASE 12. In version 3.0 SybaseDialect for ASE 12 is not supported.

I reused the old Dialect from Nhib 2.1.2 and all is working.

What I wanted to ask since this one was removed as it was considered not a good implementation, is there a better one out there?

Since it's working I am not sure what improvements need be made but I thought I would ask.

Answer 1

This blog post has the scoop. Haven't tried upgrading so can't comment if the version 2.1.2 Sybase dialect with NHibernate 3.0 will perform any differently than using it with the NHibernate 2.1.2 version.

Answer 2

I took the Dialect class from NHibernate v2.1.2 and created a SybaseDialect.cs and then in the Config file I reference it, this seems to work fine.