Session factory configuration has a property for SQL keyword quoting. <property name="hbm2ddl.keywords">auto-quote</property>
Allowed values are: - none : disable any operation regarding RDBMS KeyWords - keywords : (*activated by Default*) imports all RDBMS KeyWords where the NH-Dialect can provide the implementation of IDataBaseSchema (so far available for MsSQL, Oracle, Firebird, MsSqlCe, MySQL, SQLite, SybaseAnywhere) - auto-quote : imports all RDBMS KeyWords and auto-quote all table-names/column-names on BuildSessionFactory On Mon, Nov 15, 2010 at 7:17 PM, Sasha <[email protected]> wrote: > i have a table with Order column (name of the column) > > looks like a nh3 does not know how to handle reserved names > > for ex: > > i have an entity Page: > > class Page{ > prop Id; > prop Name; > prop Order; > } > > and when trying to query it in nhprofiler getting: > > select Id, Name, Order from Product > > as u know sql server reserved Order name and if i need to use it i > will need to use quotes like so `Order` > > so why not to put all column names in quote by default? > > what do u think? > > -- > You received this message because you are subscribed to the Google Groups > "nhusers" group. > To post to this group, send email to [email protected]. > To unsubscribe from this group, send email to > [email protected]<nhusers%[email protected]> > . > For more options, visit this group at > http://groups.google.com/group/nhusers?hl=en. > > -- lachlan -- You received this message because you are subscribed to the Google Groups "nhusers" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/nhusers?hl=en.
