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