62,046
社区成员
发帖
与我相关
我的任务
分享NHibernate HQL==>SQL问题
问题是从hql到sql语句中，配置文件已经配置，本来应该用[]括起来sql关键字，但是却没有括起来。
配置
<set name="Orders" table="'Order'" generic="true" inverse="true">
<key column="CustomerId" foreign-key="fk_customer" /><!--这里写的是字表对应主表的外键-->
<one-to-many class="Model.Order,Model"/>
</set>
生成的sql语句
select distinct customer0_.CustomerId as CustomerId0_, customer0_.Firstname as Firstname0_, customer0_.Lastname as Lastname0_
from Customer customer0_ inner join Order orders1_ on customer0_.CustomerId=orders1_.CustomerId
where (orders1_.Date>@p0 ); @p0 = '2009/2/3 0:00:00'
配置
<set name="Orders" table="'Order'" generic="true" inverse="true">
<key column="CustomerId" foreign-key="fk_customer" /><!--这里写的是字表对应主表的外键-->
<one-to-many class="Model.Order,Model"/>
</set>
生成的sql语句
select distinct customer0_.CustomerId as CustomerId0_, customer0_.Firstname as Firstname0_, customer0_.Lastname as Lastname0_
from Customer customer0_ inner join Order orders1_ on customer0_.CustomerId=orders1_.CustomerId
where (orders1_.Date>@p0 ); @p0 = '2009/2/3 0:00:00'
...全文
请发表友善的回复…
发表回复
fly871117 2009-06-21
- 打赏
- 举报
顶，最近想学习NHibernate
icuso 2009-06-21
- 打赏
- 举报
回帖是一种美德！每天回帖即可获得 10 分可用分
gdjlc 2009-06-21
- 打赏
- 举报
oec2003 2009-06-21
- 打赏
- 举报
恭喜 解决
sunshine_anycall 2009-06-20
- 打赏
- 举报
后面顶的兄弟依然有分
sunshine_anycall 2009-06-20
- 打赏
- 举报
解决了
帮助文档上说
You may force NHibernate to quote an identifier in the generated SQL by enclosing the table or column name in backticks in the mapping document.NHibernate will use the correct quotation stylefor the SQL Dialect (usually double quotes, but brackets for SQL Server and backticks for MySQL).
但是明显没有达到相应的效果。所以我自己加上了方括号。
帮助文档上说
You may force NHibernate to quote an identifier in the generated SQL by enclosing the table or column name in backticks in the mapping document.NHibernate will use the correct quotation stylefor the SQL Dialect (usually double quotes, but brackets for SQL Server and backticks for MySQL).
但是明显没有达到相应的效果。所以我自己加上了方括号。
