Hi,

I use Nhibernate to access databases from C#. During development I worked with MS SQL. I transfered data to FoxPro (similar to dBase or Access) and changed my connection setup.
Everything worked fine with MS SQL. After changing to an OleDb Connection for my foxPro-DB I get an error (could not load entity - syntax error), while executing an hql-query:
"from OrganizationalUnit OrgUnit where OrgUnit.TypeId.TypeId = 'employee'"

What could be the reason that it worked well with one connection and throws errors with another connection?

Thanks in advance antoschka

I solved it by deleting the square brackets from the Column names in the mapping file. Thanks for your effort.



Bye antoschka