hi,
can somebody please clarify these queries..
1) which version of sybase is supported by nhibernate?
2) NHibernate supports Multiple connections and connection pooling. (we have to implement Application Service Provider Architecture in our application)?
3) is there any bench mark tests done for NHibernate to prove that it is scalable and perform well with big enterprise applications? (NH authors pls forgive me for this query)
Many thanks
sarin

1) AFAIK, sybase is not well supported; read the files SybaseDialect.cs and SybaseClientDriver.cs in NHibernate source code. If you improve it, feel free to contribute your changes.

2) You need one SessionFactory per database and one Session per connection. And AFAIK, connection pooling is managed by ADO.NET.

3) It is very hard and time-consuming to define what a "big enterprise application" is... Just do your own tests to see if it fits in your case :wink:

I can tell you that I'm using Nhibernate in a "big enterprise application". This is a mission critical system that controls the social security system in Argentina every day. We have to tune NH with QueryCaching, 2nd level cache and other performance tweeks, but overall NH has cut our development time significantly, and most importantly it helped us "forget" about the DB while we were designing our model.

Just to have an idea the new DB has about 160 new tables and this has been a 1 year effort with 5 developers full time.

Have faith, take the plunge and join the club!