<< you can not make cartesian products with criteria.>>
?
aCartesianProduct = s.CreateCriteria(typeof(Foo))
.SetFetchMode("ACollection", FetchMode.Join)
.SetFetchMode("BCollection", FetchMode.Join)
.SetFetchMode("CCollection", FetchMode.Join)
.SetFetchMode("DCollection", FetchMode.Join)
.List<Foo>();
-----Original Message-----
From: [email protected] [mailto:[email protected]] On Behalf Of
Stefan Steinegger
Sent: den 19 maj 2009 13:33
To: nhusers
Subject: [nhusers] Re: HQL vs Criterion
Forgot to mention: you can not make cartesian products with criteria.
So you can't select columns from different tables if they don't have a
mapped reference. This could be important for reports or when using
legacy databases.
On 19 Mai, 13:30, Stefan Steinegger <[email protected]> wrote:
> This is not a trivial question at all. I still don't know many
> differences between hql and criteria features, and hope you get some
> good answers here :-)
>
> AFAIK, you don't have these pseudo-properties or functions like
> elements and class, and you don't have the index operator [] on lists.
>
> I do as much as possible with criteria, because it is more stable then
> hql, that is evaluated at runtime. And I have a lot of dynamic
> queries, which would be a pain to build up with hql. I really hope
> that criteria will be as powerful as hql in the future.
>
> On 19 Mai, 12:18, dnagir <[email protected]> wrote:
>
> > Hi,
>
> > I read somewhere that HQL is a bit more powerful that Criteria API.
>
> > Just wondering what we cannot do in HQL and cannot in Criteria API.
> > And vice versa.
>
> > I'm very new to NH so soryy of this is too obvious question.
> > For me it looks like Criteria API is much more powerful (though
> > usually requires a bit more code to write) and I like it.
>
> > Cheers,
> > Dmitriy.
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---
