Does anyone know what is required to use VistaDB (http://www.vistadb.com) to use with NHibernate? I saw a post someone was working on the driver and I don't seem to find if that is implemented at all???

Could some one point me to a link or steps I need to get this one working?

Thanks in advance.

As far as I can make out, there are only two things you need to support a new database in NHibernate..

- A Dialect

Try using the SQLite dialect. This would seem to fit with VistaDB, which claims SQL-92 support but no RIGHT JOIN support ; just like SQLite.

- A Driver

Which can be as simple as a very small definition that inherits from the base NHibernate.Driver.ReflectionBasedDriver class. It's main responsibility appears to be creating connections and command objects.

Since VistaDB claims that it has a full ADO.NET API, including VistaDBConnection and VistaDBCommand classes, the ReflectionBasedDriver should work fine.

Grab the NHibernate.Driver.SQLiteDriver source, paste it into a class module in your data layer assembly, rename the class, and replace the three strings in the constructor with the appropriate values for VistaDB (assemblyname, connection class, and command class). Then point to this new class in your configuration (you don't have to compile the new driver into the NHibernate assemblies, as long as you tell the configuration it's fully qualified classname and the assembly it's located in (which can be one of your own).

Work out what the values of the four properties the driver exposes should be for VistaDB, and you should be going.

I had to do this because the SQLite driver supplied does not reference the new ADO.NET 2.0 driver.[/code]

I will try with your comments and see if I can get this going.
Thanks.