views:

187

answers:

3

I'm about to start on a new WPF application with a Sybase datastore. The team has experience with Nhibernate, but we are not really sure how well it supports Sybase and if there are some major pitfalls we should look out for.

If yes, how about Fluent nhibernate?

If not, do you know any other ORM products that we could use for Sybase in this scenario?

Thanks.

+1  A: 

According to this link, I would say that it does. There seems to have known issues, though. But depending on what you need, it might suit your needs.

The SQLAnywhere12Dialect seems to have repaired some of the buggy stuff.

Will Marcouiller
+1  A: 

Sybase is officially supported in NHibernate.

From what I've seen, Fluent NH doesn't expose a class for configuring a Sybase DB, but you can probably do that in a just couple of lines (the rest of it is not dependent on the DB)

Diego Mijelshon
+2  A: 

Are you asking about Sybase ASE or Sybase Anywhere. NHibernate supports both and FluentNHibernate supports neither.

gonzobent
I was asking about Sybase ASE. Have you used Nhibernate with Sybase ASE?
We are currently using NHibernate with Sybase ASE. The drivers are targeted at version 11, so if you are using any features from 12 or 15, you will need to tweak the drivers just a bit.
gonzobent