EF query to fluent nhibernate query
- by Shlomi Levi
I have EF Query:
IEnumerable<Account> accounts = (from a in dc.Accounts
join m in dc.GroupMembers on a.AccountID equals m.AccountID
where m.GroupID == GroupID && m.IsApproved
select a).Skip((_configuration.NumberOfRecordsInPage * (PageNumber - 1)))
.Take(_configuration.NumberOfRecordsInPage);
How to write it in fluent nhibernate query with Session.CreateCriteria<?
(My problem is with Join)
Regards,