Hi there,

I am trying to connect to a Navision database which comes with a crappy ODBC driver. It seems that aliases are not allowed there.

In particular, queries like

SELECT myclass0_.Name from NavisionTable myclass0_

always fail. I would like to ask if the way that the queries are built can be modified in NHibernate to have a query like

SELECT Name from NavisionTable

instead. Is this possible? Has anyone else experience on connecting to Navision databases and knows a way to make them work?

thanks in advance,

Stephan

I think you will have to use an SQL query here... (ISession.CreateSQLQuery). You will still need column aliases support (not table aliases), but hopefully Navision allows that.