Skip to:

  1. Skip to Jira Navigation
  2. Skip to Side Navigation
  3. Skip to Main Content

xBase support (Driver and Dialect)

Description

After I came accross the fifth NHibernate Project with the need to connect to some kind of xBase DataBase I was wondering if there is a way to write an appropriate Dialect and Driver for it. Especially FoxPro with it's dbf/dbc files would be of interest. At the moment we work with GericDialect and OleDbDriver, which does not lift the real advantages of FoxPro.
However I think it is not only an issue for connecting to legacy systems. Especially FoxPro is a nice light-weighted database, which does not require a central server, but is atleast 4 times faster then any Access DB. In many situations it is a nice way of getting around heavy weighted DBMS. Therfore I think it suits in many projects and would broaden a lot the possible scenarios, where NHibernate could be used.

Thanks for your effort, greetings

antoschka

P.S.: There is a commercial support of xBase Database such as FoxPro for Hibernate by hxtt.

Environment

None

Activity

Fabio Maulo 
July 28, 2008 at 6:07 AM

My advise is use a real RDBMS.
If you really need something "without" a server you can use SQLite, SQLCe.
"without a server"... in some central place you are putting DB files... well that is the server even if it is not a RDBMS.

BTW studying the others Dialects and drivers you can write your own Dialect and your own Driver and configure it trough NH configuration.
In NH Contrib there is the drive/dialect for Jet (Access)
http://nhcontrib.svn.sourceforge.net/viewvc/nhcontrib/trunk/src/NHibernate.JetDriver/

If you write something to use NH with FoxPro let us know in NH-Contrib-devlist
http://groups.google.com.ar/group/nhcdevs

Won't Fix

Details

Assignee

Reporter

Components

Affects versions

Priority

Who's Looking?

Open Who's Looking?
Created July 28, 2008 at 5:00 AM
Updated May 19, 2017 at 1:26 AM
Resolved May 19, 2017 at 1:26 AM
Who's Looking?