NHibernate dialect for Interbase

views:

answers:

NHibernate dialect for Interbase

Hi all

I do a good deal of work with an Interbase server. I would like to develop a data access layer for it using NHibernate but there isn't a readymade dialact for Interbase.

Does anyone know, is there an NHibernate dialect which is used for generic ANSI-only database work, or if any of the existing dialects will work okay with Interbase?

Or on the other hand, what kind of work is required to create a new dialect?

Thanks for any advice you can provide.

David

The Firebird dialect is probably fairly close. Start with that, and tweak it if necessary.

Disclaimer: I haven't tried this. The ADO.NET provider will be different for IB, so theory and practice may diverge. But the SQL syntax for IB and Firebird are less different than the other options on the list.

Craig Stuntz 2010-07-15 15:35:19

+1 A:

You can try with GenericDialect.

In any case, I suggest you take a look at the existing dialects at https://nhibernate.svn.sourceforge.net/svnroot/nhibernate/trunk/nhibernate/src/NHibernate/Dialect/ and write one for Interbase, that you can then share with the community. It's not hard.

Diego Mijelshon 2010-07-15 20:18:20

Exactly what I was looking for; thank you.

David 2010-07-16 08:48:45

It is actually quite hard though. There is no documentation.

David 2010-07-19 20:48:31

"The source code is the documentation" (when extending an OSS framework :-))Look at what's in other dialects, what's different between them, and what would be different in Interbase. Start with anything other than MsSql and Oracle (because those are more complex)

Diego Mijelshon 2010-07-19 21:05:32

ansaurus

tags:

views:

answers:

NHibernate dialect for Interbase

related questions