I am using NHibernate 2.0.0GA with SQL Server 2005 dialect.

How do I map table that is a keyword?
For example, if my table name is user or transaction
I can query like this:

select * from [user]
select * from [transaction]

since user and transaction are keywords.

If I map these tables using NHibernate and fetch the data, I got
"could not execute query" error. And when I see the indicated query statement, it's missing the square brackets. How do I get around it? (without renaming my table.)

Thanks.

Just map it like this: