Hello,

I have the following xml line in my nhibernate mapping file:

<property name="MaxRowWidth" column="Max Row Width" />

As you can see the database uses column names with spaces BUT nhibernate does not allow having whitespace in the column name.

It's no option to remove the spaces from the databasecolumn.

Any idea how to solve this? (Already tried: [] and ` `)

Thanks in advance!
Marten

Hi Marten,

Using square brackets has worked for me in the past:


I was using SQL Server at the time ... which database are you using?

Perhaps there is another syntax unique to the database vendor you're using?

Regards,
Richard

Richard,
Thank you for your input! The [ ] did solve the problem. Thanks!

Actually, the square brackets will not work with all databases, so if you want to do this in a database agnostic fashion use backticks (`) instead.

Symon.