Although NH I think would happily do it, I think LINQ itself won't let you
do it straight forward.
However, there is some way:
var baseProducyQuery = session.Query<Product>();var query = from p in
baseProducyQuery
select new
{
Product = p,
Count = baseProducyQuery.Count(),
PriceOfAllProducts = baseProducyQuery.Sum(x
=> x.Price)
};
The generated SQL (working with Product model from
http://gurustop.net/blog/2011/04/17/nh-nhibernate-mapping-jose-romaniello-ef-conform-domain-using-fnh-fluentnhibernate/
is:
select
> product0_.Id as col_0_0_,
> (select
> cast(count(*) as INT)
> from
> [Product] product1_) as col_1_0_,
> (select
> cast(sum(product2_.Price) as DECIMAL(19,
> 5))
> from
> [Product] product2_) as col_2_0_,
> product0_.Id as Id4_,
> product0_.Name as Name4_,
> product0_.Price as Price4_
> from
> [Product] product0_
*Mohamed Meligy
*Readify | Senior Developer
M:+61 451 835006 | W: readify.net
[image: Description: Description: Description: Description:
rss_16]<http://gurustop.net>
[image: Description: Description: Description: Description:
cid:[email protected]]
<http://www.linkedin.com/in/meligy> [image:
Description: Description: Description: Description:
cid:[email protected]] <http://twitter.com/meligy>
<http://www.greatplacetowork.com.au/best/best-companies-australia.php><http://www.readify.net/AboutUs/NewsItem.aspx?id=10>
On Fri, May 6, 2011 at 10:12 AM, Andrei Alecu <[email protected]>wrote:
> Is it possible to generate a *single* query to the database, like:
>
> select sum(x.value), count(*) from sometable
>
> With NHibernate Linq?
>
> I was able to do this with HQL and with QueryOver using
> ProjectionList, but I can't seem to be able to find how to do it with
> Linq.
>
> Note that there's no grouping involved, I believe that if I had a
> grouping I could've used GroupBy() and the query would've gotten
> translated properly into one database hit.
>
> If I need to tap into some deeply hidden Linq to HQL converters to do
> it, it's fine, if only someone could point me in the right direction.
>
> Thanks!
>
> --
> 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.
>
>
--
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.
