I've had to resort to using SQL for a query to get a list of IDs
back. I fought with Criterion and HQL for a long time, and finally
fell back to this--
var query =
@"
SELECT UserSkills.UserID
FROM UserSkills
JOIN UserSkillValue on UserSkills.SkillValueID = UserSkillValue.Id
WHERE UserSkillValue.SkillID IN
(
SELECT SkillID FROM ProjectSkills WHERE ProjectID = 1
)
GROUP BY UserSkills.UserID
HAVING COUNT(UserSkillValue.SkillID) = (SELECT COUNT(SkillId) FROM
ProjectSkills WHERE ProjectID = 1)";
var results = (IList<Int32>)ActiveRecordMediator<User>.Execute(
delegate(ISession session, object instance)
{
return session.CreateSQLQuery(query)
.List<Int32>();
}, null);
This gives me a list of IDs for users. But I need to actual users!
What's the cheapest way of getting users from this?
--
You received this message because you are subscribed to the Google Groups
"Castle Project Users" group.
To post to this group, send email to [email protected].
To unsubscribe from this group, send email to
[email protected].
For more options, visit this group at
http://groups.google.com/group/castle-project-users?hl=en.
