开发者

Sql to NHibernate QueryOver

开发者 https://www.devze.com 2023-03-08 17:32 出处:网络
How can I Convert this SQL to NHibernate QueryOver ? select k1.Id,k.sm from tblKarbarg_1 k1 inner join (

How can I Convert this SQL to NHibernate QueryOver ?

select k1.Id,k.sm
from tblKarbarg_1 k1
inner join (
            select kd.Karbarg_1_id,SUM(kd.MablaghSanad) as sm 
            from tblKarbarg_1_Detail kd 
            group by kd.Karbarg_1_id
            ) K 
开发者_Python百科on k.Karbarg_1_id=k1.Id


This depends on your mapping. But here is a very nice list of examples that demonstate the feautures of QueryOver and other methods of querying in NHibernate.

http://www.martinwilley.com/net/code/nhibernate/query.html

0

精彩评论

暂无评论...
验证码 换一张
取 消