That's an NHibernate thing. You can do one of several things...
1. Escape your column names using backticks (`), so End becomes `End`. This instructs NH to escape that column using the database specific escaping mechanism 2. Auto-escape your column names; there's a configuration setting you can use for this detailed here<http://fabiomaulo.blogspot.com/2009/06/auto-quote-tablecolumn-names.html>. Specifically you need hbm2ddl.keywords set to keywords or auto-quote On Thu, Mar 4, 2010 at 2:53 PM, adrianhara <adrian.h...@iquestint.com>wrote: > Hi, > > I've searched a bit but haven't turned up anything, so here goes: are > there any disallowed/restricted property names on the mapped entities? > For example, I have a class that has a property named "End" of type > "DateTime" and another one named "Start". > > The unit test exporting the schema ( new > SchemaExport(NHibernateSessionProvider.Configuration).Execute(false, > true, false);) barfs with > > "System.Data.SqlClient.SqlException: Incorrect syntax near the keyword > 'End'. Incorrect syntax near 'DATETIME'." > > However, if I rename my property to "EndDate" everything works fine. > Also, the "Start" property name seems fine. > > Is this a nHibernate issue or a fluentNH issue? > > Thanks > > -- > You received this message because you are subscribed to the Google Groups > "Fluent NHibernate" group. > To post to this group, send email to fluent-nhibern...@googlegroups.com. > To unsubscribe from this group, send email to > fluent-nhibernate+unsubscr...@googlegroups.com<fluent-nhibernate%2bunsubscr...@googlegroups.com> > . > For more options, visit this group at > http://groups.google.com/group/fluent-nhibernate?hl=en. > > -- You received this message because you are subscribed to the Google Groups "Fluent NHibernate" group. To post to this group, send email to fluent-nhibern...@googlegroups.com. To unsubscribe from this group, send email to fluent-nhibernate+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/fluent-nhibernate?hl=en.
