Help Questions | Solutions | Experts

Select Categories Below

.net [

]

Bluetooth [

]

browsers [

]

C# [

]

computer [

]

Errors [

]

forms [

]

HTML [

]

information tec... [

]

internet [

]

Start Your Own Q&A Site

Create your own Q&A site easily, allowing you to quickly grow a new community around any subject matter or generate new organic traffic for your existing website.

Question

Status: Closed Points: 100 Time: 06:29 - Mar 01, 2007

theDude

How do I handle database reserved words in NHibernate?

I have a NHibernate query like this "from Representative as R where R.Password = :pwd"
but I get an error saying that the query can't be executed because it has a reserved word in it.
The table field is indeed called "password" and it hasn't been a problem when inserting new registries, but now it's giving this error.
So I was wondering if there is a way in the mapping or in the query to indicate that it's a reserved word with brackets or apostrophes or something alike?

Categories:

Databases .net
NHibernate

Answer Discussion

Tutorials

theDude

Date:: Mar 23, 2007

Time:: 15:16

I found out that I have to use the `-sign in the mapping files:
... column="`user`" ... for example

abcpaem

Date:: Jan 22, 2008

Time:: 13:39

The '-sign didn't work for me, I have a table named "User" in SQL Server 2005 and I had to use brackets to succeed, ex:
<class name="User" table="[user]" lazy="false">

Thanks anyway.

Question Answered

This question has been closed, and points have been rewarded to the following experts:

theDude:

100

You're welcome however to comment or give additional information or if you wish, you have the ability to write a Tutorial in the Tutorial Area.

Answer this Question

New User

Email:
Upon submission of this form, you will automatically be registered as a Quomon user and we will send your login information to this address

Registered User

Username:

Password:

Forgot Your Password?

No tutorials have been submitted yet. Want to be the first?