Questions | Solutions | Experts

Select Categories Below

.net [

]

asp.net [

]

browsers [

]

C# [

]

CSS [

]

Databases [

]

email [

]

Errors [

]

HTML [

]

information tec... [

]

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:

programming NHibernate
Databases .net

Answer Discussion

Answer Summaries

Q&A System for Websites and Corporate Collaboration

Generates significant organic traffic for websites
Saves companies money, resources, and time

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 an Answer Summary for the Summary 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 summaries have been submitted yet. Want to be the first?