using reserved word as entity name

Question

I'm using NHibernate mapping by code with naming conventions to map my entities. Now I have following error

SQL error - Incorrect syntax near the keyword 'User'.:

I know this is reserved word and I'm wonder how can I use this name (User) as entity name in mapping by conventions.

Would you post your query? if `User` is a field's name you should put in []. — Maryam Arshi, Mar 11 '13 at 12:56

Vishal Suthar · Answer 1 · 2013-03-11T13:00:12.523

10

You can use it by wrapping it around square brackets as it is a reserved keyword in SQL SERVER:

[User]

The word user is a reserved word in SQL Server. If you need to use it as a column name, put brackets around it. This goes for all table names and other user-defined names that happen to collide with keywords,

Example:

Select * from tbl where [User] = 'xyz'

edited Mar 11 '13 at 13:00

answered Mar 11 '13 at 12:55

Vishal Suthar

17,013
3
59
105

2

While this works, it's **not** the recommended way to do it in NHibernate. – Diego Mijelshon Mar 11 '13 at 14:33
What's the recommended way then? – Nik A. Jan 11 '18 at 04:56

score 6 · Accepted Answer · answered Mar 11 '13 at 14:32

The correct way to deal with this in NHibernate is using SQL Quoted Identifiers.

Just wrap the table or column name in backticks and the Dialect will take care of using the right symbol for your database.

To make things easier, NHibernate provides a configuration setting that does this for you: set hbm2ddl.keywords="auto-quote" in an xml config file, or call AutoQuoteKeywords() when using loquacious.

score 2 · Answer 3 · answered Mar 11 '13 at 12:58

2

If the brackets don't work, try this:

"`User`"

answered Mar 11 '13 at 12:58

Crowlix

1,269
9
19

using reserved word as entity name

3 Answers3