This thing is keeping me busy for days and I hope someone of the NHibernate gurus can help me out. I've got a query set up which is working in SQL Server and I want to get the same in NHibernate. But all my tries (did a lot of googeling and browsing in stackoverflow) failed so far. Here's the query:
Select
j.id,
j.title,
j.company,
jt.name as category,
loc.city,
je.is_assigned,
FROM job j
LEFT JOIN location loc ON loc.id = j.location
LEFT JOIN job_tag jt ON jt.job = j.id
and jt.name in (SELECT name FROM tag WHERE tag_category=''Jobtype'')
LEFT JOIN job_employee je ON je.job = j.id
and je.employee_uid = <string>
I would prefer to use QueryOver but would be happy to get recommendations from you guys!
EDIT: What I do have so far is pretty simple...
JobEmployee jobEmployee = null;
Location loc = null;
JobTag jobTag = null;
session.QueryOver<Job>()
.JoinAlias(x => x.location, () => loc)
.JoinAlias(x => x.tags, () => jobTag, JoinType.LeftOuterJoin,
Restrictions.On(jobTag.name).IsIn(<subquery>))
.List();
But there are errors like "delegate .... does not take 1 arguments".
Best regards, Martin