Hi

We are looking at using NHibernate on a large project, but the database we use is not listed in the supported dialects.

What is involved in writing a dialect support class for NHibernate ?

BTW: The database we use is Mimer (www.mimer.com) which is a full SQL database.

The database vendor does provide an ADO .NET data provider.


Also, is it possible to hand code SQL read statements fo NHibernate to use rather than auto generate. The reason I ask is for readonly grid displays and reporting we often use multiple cross table joins to retrieve the data and the mimer SQL optimiser sometimes benefits from us being able to include {order} and {index} keywords in the selection criteria to force it to take a particular path through the table joins or to force the use of a secondary index.

Cheers
Martin.