tags:

views:

21

answers:

1
Q: 

How to quote Fieldnames in Fluent NHibernate 1.1

After upgrading from Fluent NHibernate 1.0 RTM to 1.1 I got some strange errors when creating the database. After some investigation I discovered that FNH 1.0 quoted all field names in the generated mapping files like 'user', but FNH 1.1 did not. This results in errors for the generated sql script when I use restriced keywords for properties.

Is it somehow possible to reactivate this feature of FNH 1.0 or enable quoting otherwise?

A: 

Are you talking about the code that is generated and sent to the sql server or the psedo mappings files it generates?

cdmdotnet  2010-07-27 23:00:06
it is in the mapping files
MarioH  2010-07-28 11:33:09
I'd hassard a guess that this is the way it should be. Since each database has its own quote character, in Sql its [ and ] in MySql its ` and `.So its right that escaping or quoting isn't in the mapping files. it's determined at runtime depending the driver you've configured.I think your looking in the wrong place. Look into why the driver you've selected isn't quoting correctly. IE check you've selected the correct driver to match the db capabilities.
cdmdotnet  2010-07-29 03:18:32

related questions

IQuery NHibernate - does it HAVE to be a list?
(N)Hibernate - is it possible to dynamically map multiple tables to the one class
How can I map a list of strings to my entity using NHibernate?
Best practices for querying with NHibernate
NHibernate ISession Flush: Where and when to use it, and why?
IList.Cast<typeof(T)>() returns error, syntax looks ok
NHibernate Generators
101 tutorial for setting up nhibernate?
NHibernate Session.Flush() Sending Update Queries When No Update Has Occurred
NHibernate SetTimeout on ICriteria
Best way to manage session in NHibernate?
Has anyone moved to NHibernate 2.0 in a production environment?
NHIbernate: Difference between Restriction.In and Restriction.InG
NHibernate and Oracle connect through Windows Authenication
Is it possible to use nHibernate with Paradox database?
NHibernate 1.2 to 2.0 migration
NHibernate vs LINQ to SQL
Windows Service Increasing CPU Consumption
(N)Hibernate Auto-Join
MSTest and NHibernate
SQL 2008 Dialect Support for NHibernate
ADO.NET Entity vs NHibernate
Data Auditing in NHibernate and SqlServer
Best way to model Many-To-One Relationships in NHibernate When Dealing With a Legacy DB?
Subsonic Vs NHibernate