Hibernate 對(duì)分組聚合支持的不好，例如下面的代碼：

var query = from raqi in session.Query()group raqi by raqi.SpaceKeyinto gselect new {g.Key,Count = g.Count(r => r.Raqi > 1)};

這樣的查尋生成的Sql如下，很明顯是錯(cuò)誤的，

selectfactstatra0_.[SpaceKey] as col_0_0_,cast(count(*) as INT) as col_1_0_ from[dbo].[FactStatRaqi] factstatra0_ group byfactstatra0_.[SpaceKey]

LinqToSql可以生成正確的sql

-- Region Parameters DECLARE @p0 Float SET @p0 = 1 -- EndRegion SELECT [t1].[SpaceKey] AS [Key], (SELECT COUNT(*)FROM [FactStatRaqi] AS [t2]WHERE ([t2].[RAQI] > @p0) AND ([t1].[SpaceKey] = [t2].[SpaceKey])) AS [Count] FROM (SELECT [t0].[SpaceKey]FROM [FactStatRaqi] AS [t0]GROUP BY [t0].[SpaceKey]) AS [t1]

看來(lái)，NH的Linq查尋還有很長(zhǎng)的路要走。

轉(zhuǎn)載于:https://www.cnblogs.com/beginor/archive/2011/03/16/1985956.html

超強(qiáng)干貨來(lái)襲 云風(fēng)專訪：近40年碼齡，通宵達(dá)旦的技術(shù)人生

總結(jié)

以上是生活随笔為你收集整理的NHibernate 对分组聚合支持的不好的全部?jī)?nèi)容，希望文章能夠幫你解決所遇到的問(wèn)題。

如果覺(jué)得生活随笔網(wǎng)站內(nèi)容還不錯(cuò)，歡迎將生活随笔推薦給好友。