• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

NHibernate Criteria with Grouping

 
Alex Aung
Greenhorn
Posts: 1
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
SELECT t.BAmount, t.FAmount, acc.SettlementCurrencyID
FROM [dbo].[TransactionDetail] t
INNER JOIN Acquirer a ON a.ID = t.AcquirerID
INNER JOIN AcquirerCard ac ON ac.AcquirerID = a.ID and ac.CardID = t.CardID
INNER JOIN AcquirerCardCurrency acc ON acc.AcquirerCardID = ac.ID and acc.FCurrencyID = t.FCurrencyID

This is my native sql to group base on SettlementCyrrencyID.

I know how to do Criteria with Grouping. But my problem is that I dont know how to join TransactionDetail to AcquirerCardCurrency table.

How can I create NHibernate Criteria with Grouping?

Please let me know..

Thanks you so much.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic