size is an HQL construct. SQL doesn't know about collections (only
relations), so there is no size in SQL.
If you need only to test the existence of RelatedQuestions, but not their
number, you can use
var crit =
DetachedCriteria.For<Question>().Add(Expression.IsNotEmpty("RelatedQuestions"));
-Markus
2010/5/23 Cosmo <[email protected]>
> Hello Markus, thank you, the HQL works in a SimpleQuery. I need the
> Criterion for that, cause it's part of a bigger DetachedCriteria
> query.
>
> Could you please point me out why this one doesn't work (based on your
> HQL):
>
> DetachedCriteria dc = DetachedCriteria.For<Question>("q");
> dc.SetResultTransformer(new DistinctRootEntityResultTransformer());
> dc.Add(Expression.Sql("q.RelatedQuestions.size > 1"));
> IList<Question> res = Question.FindAll(dc);
>
> This would solve my problem, but I get: {"The multi-part identifier
> \"q.RelatedQuestions.size\" could not be bound."}.
>
> Regards,
> Jakub
>
> On 22 Maj, 17:35, Markus Zywitza <[email protected]> wrote:
> > Any reason not to use:
> >
> > from Question q where q.RelatedQuestions.size > 1
> >
> > If you are afraid of HQL, try NHibernate Workbench:
> http://nhforge.org/blogs/nhibernate/archive/2010/05/19/nhibernate-wor...
> >
> > -Markus
> >
> > 2010/5/22 Cosmo <[email protected]>
> >
> >
> >
> > > Hello Guys!
> >
> > > This SQL works for me:
> >
> > > select * from Question q where (select COUNT(*) from RelatedQuestion
> > > rq where q.Id = rq.ParentId) > 1
> >
> > > Now I try to convert it to Criteria API:
> >
> > > DetachedCriteria subCriteria = DetachedCriteria.For<Question>("rq")
> >
> > >
> .CreateCriteria("RelatedQuestions").SetProjection(Projections.RowCount())
> > > .Add(Restrictions.EqProperty("rq.ParentId", "q.Id"));
> >
> > > DetachedCriteria criteria =
> > > DetachedCriteria.For<Question>("q").Add(Subqueries.Le(1,
> > > subCriteria));
> > > IList<Question> results = Question.FindAll(criteria);
> >
> > > As a result I get: "Could not find a matching criteria info provider
> > > to: NHibernate.Impl.CriteriaImpl+Subcriteria".
> >
> > > My mappings are:
> >
> > > [ActiveRecord("`Question`")]
> > > public class Question : ObcykaniDb<Question> {
> >
> > > private long id;
> > > private IList<Question> relatedQuestions;
> >
> > > [PrimaryKey("`Id`")]
> > > private long Id {
> > > get { return this.id; }
> > > set { this.id = value; }
> > > }
> >
> > > [HasAndBelongsToMany(typeof(Question), ColumnRef = "ChildId",
> > > ColumnKey = "ParentId", Table = "RelatedQuestion")]
> > > private IList<Question> RelatedQuestions {
> > > get { return this.relatedQuestions; }
> > > set { this.relatedQuestions = value; }
> > > }
> > > }
> >
> > > Any ideas to help me out?
> >
> > > Regards,
> > > Jakub
> >
> > > --
> > > 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]<castle-project-users%[email protected]>
> <castle-project-users%[email protected]<castle-project-users%[email protected]>
> >
> > > .
> > > For more options, visit this group at
> > >http://groups.google.com/group/castle-project-users?hl=en.
> >
> > --
> > 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]<castle-project-users%[email protected]>
> .
> > For more options, visit this group athttp://
> groups.google.com/group/castle-project-users?hl=en.
>
> --
> 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]<castle-project-users%[email protected]>
> .
> For more options, visit this group at
> http://groups.google.com/group/castle-project-users?hl=en.
>
>
--
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.
