the problem is your criteria, not filter. just query the assessments.
then query the categories.
session.EnableFilter("ByCategory").SetParameter("id", 1);
var assessments =
session.CreateCriteria<Assessment>().List<Assessment>();
foreach(var assessment in assessments)
{
var categories = assessment.Categories;
}
On Aug 3, 11:28 am, julianjelfs <[email protected]> wrote:
> Ooooh very close. This is nearly perfect except that is seems to be
> adding the condition to the where clause as well now, so I am getting:
>
> SELECT ...
> FROM Assessment this_
> left outer join Categories impactcate1_
> on this_.AssessmentId = impactcate1_.AssessmentId
> and impactcate1_.CategoryID = 1
> WHERE impactcate1_.CategoryID = 1
>
> This is with the following criteria:
>
> session.EnableFilter("ByCategory").SetParameter("id", 1);
>
> session.CreateCriteria(typeof (Assessment))
> .CreateCriteria("Categories", JoinType.LeftOuterJoin)
> .List();
>
> If I can just get rid of that where clause I will have exactly what I
> want.
>
> Thanks very much for the help so far - any help with the last problem
> would be fantastic.
>
> On Aug 3, 3:04 pm, Jason Meckley <[email protected]> wrote:
>
> > filters may be the option you are looking for
> > <set name="Categories">
> > <filter name="ByCategory" condition="CategoryId = :id"/>
> > </set>
> > ....
> > <filter-def name="ByCategory">
> > <param name="CategoryId" type="long" />
> > </filter-def>
>
> > session.EnableFilter("ByCategory").SetParameter("id", 1);
> > session.Get<Assesment>(2);
>
> > var onlyCategoriesWithIdEqualToOne = Assesment.Categories;
>
> > On Aug 3, 9:07 am, julianjelfs <[email protected]> wrote:
>
> > > Hi,
>
> > > Is there a way to restrict the join performed to populate a set using
> > > a dynamic variable or a parameter. The set mapping allows me to
> > > specify a "where" attribute but I need it to look something like this:
>
> > > <set name="Categories" table="Categories" where="CategoryId = :id" >
> > > ...
> > > </set>
>
> > > rather than having a static value.
>
> > > If I add this condition as a restriction to the overall criteria, the
> > > restriction gets added to the where clause of the query rather than as
> > > a condition of the join. This is not quite the same thing and not what
> > > I want.
>
> > > session.CreateCriteria(typeof (Assessment))
> > > .CreateCriteria("Categories", JoinType.LeftOuterJoin)
> > > .Add(Restrictions.Eq("CategoryId", 1))
> > > .List();
>
> > > gives me something like:
>
> > > SELECT ...
> > > FROM Assessment this_
> > > left outer join Categories impactcate1_
> > > on this_.AssessmentId = impactcate1_.AssessmentId
> > > WHERE impactcate1_.CategoryID = 1
>
> > > whereas what I need is:
>
> > > SELECT ...
> > > FROM Assessment this_
> > > left outer join Categories impactcate1_
> > > on this_.AssessmentId = impactcate1_.AssessmentId
> > > and impactcate1_.CategoryID = 1
>
> > > I can't think of any way round this at the moment, so any ideas would
> > > be appreciated.
>
> > > Thanks,
>
> > > Julian.
--
You received this message because you are subscribed to the Google Groups
"nhusers" 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/nhusers?hl=en.
