Sunday, 25 August 2013

Need help translating this query to NHibernate Criteria

Need help translating this query to NHibernate Criteria

Can someone help me translate this query to NHibernate Criteria? Or is
Criteria not suited for this?
Query:
SELECT b.*
FROM Bookmarks b
JOIN (SELECT tg.BookmarkId
FROM TagsBookmarks tg
JOIN Tags t ON t.id = tg.TagId
WHERE t.Title IN ('c#','tutorials')
GROUP BY tg.BookmarkId
HAVING COUNT(DISTINCT t.Title) = 2) x ON x.BookmarkId = b.Id

No comments:

Post a Comment