NHibernate blog - All Comments

re: QueryOver in NH 3.0

Richard Brown — Sat, 06 Mar 2010 23:25:58 GMT

Hi SynC,

1. QueryOver is built on top of the ICriteria API, and I'm not sure you can do that projection in the ICriteria API (I could be wrong though);

2. Fabio suggested the same thing. I tried projecting directly into anonymous types, something like:

.Select(o => new { o.Price, o.Count});

I couldn't get it to work; I can't remember the exact problem I had, but it was something to do with the parameters to the anonymous function. Also, I'm not sure if the syntax would execute the query at this point, or still return an IQueryOver (to then call List(), or SingleOrDefault().)

I might try again sometime when I've got some spare time.

Oh, and patches are always welcome too. ;-)

Richard

Soma best pharmacy online.

Online soma sales. — Sat, 06 Mar 2010 04:07:32 GMT

Buy soma online. Order soma online without prescription. Buy soma www scantips com buy soma online. Soma online. Soma online sales. Buy soma from mexico online.

Cyclobenzaprine buy prescription soma zanaflex.

Buy soma online. — Thu, 04 Mar 2010 17:26:02 GMT

Buy soma online order soma and get cheap soma. Buy cheap soma. Buy soma. Buy soma without prescription. Buy soma bloghoster. Http pills.viptemplates.com p buy soma. Cyclobenzaprine buy prescription soma zanaflex.

Social comments and analytics for this post

uberVU - social comments — Tue, 02 Mar 2010 06:59:41 GMT

This post was mentioned on Twitter by nhibernate: Blogged: Db2hbm: convert db schema to hbm: Here you can find a reverse engineering tool, and a documentation on ho... http://bit.ly/cuNIGR

re: QueryOver in NH 3.0

SynC — Mon, 01 Mar 2010 16:43:02 GMT

Hi Richard, help please.

1. Can be done something similar:

session.QueryOver<Order>()

.SelectList(list =>

{

list.Select(c => c.Price * c.Count);

}); ?

2. What about using anonymous types for projecting?

re: NHibernate Mapping -

Stefan Steinegger — Tue, 16 Feb 2010 14:07:17 GMT

Great Post!

I wonder what happens with fetch="subselect" if you had a very complex query before to load the entities (or a lot of queries, for instance from another N+1 situation). How will NH create the subquery? will batch-size be more efficient for such situations?

re: QueryOver in NH 3.0

Buthrakaur — Fri, 12 Feb 2010 12:23:43 GMT

sorry for my blindness :)

qry.Select(Projections.RowCount()).List<int>().FirstOrDefault()

re: QueryOver in NH 3.0

Buthrakaur — Fri, 12 Feb 2010 11:01:49 GMT

Is there any simple method how to set projections on QueryOver queries? I need to get count of entities returned by a QueryOver query and didn't find other method than using underlying CriteriaAPI like this:

var qry = customerRepo.QueryOver()

.WhereRestrictionOn(c => c.Name).IsInsensitiveLike(query.Name, MatchMode.Start)

.AndRestrictionOn(c => c.Address.City).IsInsensitiveLike(query.City, MatchMode.Start);

var countCrit = (ICriteria)qry.UnderlyingCriteria.Clone();

countCrit.SetProjection(Projections.RowCount());

res.TotalItemsCount = Convert.ToInt32(countCrit.UniqueResult());