Jet engine with Access table named Transaction fails

dodger1 · **Joined:** Sun Jul 08, 2007 9:36 pm **Posts:** 1

using NHiberate 1.2.0 with the JetDriver.dll for an Access database.
One of the access tables was named "Transaction".
Doing a select or update caused NHibernate to fail with "could not create entity".
Renamed table to something else e.g. "Transact" and NHibernate works.

karlchu · **Posted:** Sun Jul 08, 2007 10:46 pm

Try quoting the table name with back ticks like this:

Code:

<class name="Transaction" table="`Transaction`">
    ...
</class>