nhibernate - CaSTLe ActiveRecord 表名称冲突

Question

当您在 NHibernate 中遇到像“User”这样的保留字时，您只需在有问题的文本周围加上单引号，nHibernate 就会用方括号将文本括起来以供查询。我的问题是如何使用 CaSTLe.ActiveRecord 做同样的事情？

Answer 1

实际上，表达这一点的可移植方式是使用反引号，例如:

[ActiveRecord("`User`")]
class User {}

来自NHibernate Column class :

If a value is passed in that is wrapped by ` then NHibernate will Quote the column whenever SQL is generated for it. How the column is quoted depends on the Dialect.