This problem happened with my wife was working on some new website and was using NHibernate for the first time (along with SQL Server 2008 Database, DB first approach). She was using HQL and sometimes IQueryOver API. Yes, this is from the trunk.
She was mapping a table to a class that she named both "Group". Regardless of how mistaken this is, it is interesting that when she maps it using table="Group" Any query on this table fails with error "Invalid Syntax near 'Group'". She had to use instead: table="[Group]" For the queries to work. *Now, my question is: shouldn't this kind of thing be handled automatically by NHibernate? I assume by the dialect or something?* Regards, -- Mohamed Meligy Senior Developer, Team Lead Backup (.Net Technologies - TDG - Applications) Injazat Data Systems P.O. Box: 8230 Abu Dhabi, UAE. Phone: +971 2 6992700 Direct: +971 2 4045385 Mobile: +971 50 2623624, +971 55 2017 621 E-mail: [email protected] Weblog: http://weblogs.asp.net/meligy--
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.
