Hello all,

Can somebody explain why SQL identifier quotes are not always added automatically to column names by NHibernate, so we don't have to specify it manually when using reserved words as column names?

Identifier quotes are different between for example MSSQL's [] and MySQL's `` , so I need to make two mapping-files in order to share the same class-model between multiple databases.

It would be very nice it it was possible to instruct NHibernate to just add it automatically, so it's completely db-independent :-)

thanks,
Jonas

I assume you mean HQL?

You should use backticks. Each dialect will convert this to the correct quote types for the desired DB.

ah, I see... :-)

I wasn't aware that I could use backticks in the mapping file when using the MSSQL dialect. It's great that NH translates these quotes.

(actually I didn't talk about HQL, but the column names in the mapping file and the SQL statements that NH generates in general)


thanks a lot,
Jonas