I've just started to explore NHibernate. About the first thing I noticed was that it didn't support Blackfish.
I had taken the opportunity to download the source code. It was while I was doing some debugging I noticed the classes used for individual database support.
With a few hours of investigation I was able to get a couple of classes up and running with Blackfish.
I have uploaded a project to CodeCentral, it consists of a very simple example, a Blackfish database and a couple of csharp files.
If you download the example you should find three directories.
1) BlackfishSupport - which contains the 2 C# files that you need to add to the NHibernate solution
2) database - A sample database.
3) NHibernateConsoleApplication - A very small example I developed using Delphi Prism.
So having downloaded the NHibernate source the first thing you need to do is add the 2 C# files . Assuming the source was at the following locationS
BlackfishDialect.cs goes into H:\develop\NHibernate-2.0.1.GA\src\src\NHibernate\Dialect
BlackfishDriver.cs goes into H:\develop\NHibernate-2.0.1.GA\src\src\NHibernate\Driver
Having done that you need to add those 2 files to the HHibernate project and rebuild.
If you take a look at the files you might notice there isn't exactly very much source, combined with the fact that I have only built one example using NHibernate I would classify my Blackfish support as "experimental" :)
Having compiled the solution you should now be able to open NHibernateConsoleApplication in Delphi Prism.
The first thing your going to have to do is modify the app.config to point to the right location for the Blackfish database file. I have
<property name="connection.connection_string">database=C:\Documents and Settings\JohnMoshakis\Application Data\nhibernate.jds;user=SYSDBA;password=masterkey;create=true;protocol=TCP;host=localhost</property>
which is probably different on your machine.
The example has 2 classes Customer and Company and their mapping files. The code is pretty simple it just adds a company and a customer and then performs a query to customers.
Anyway if you decide to download the source, I hope its useful. I intend to continue exploring NHibernate with Blackfish as my database.
My example can be found here.