CODEWITHSUNDEEP
nhibernatequeryover
yonexbat
yonexbat

Reputation: 3012

QueryOver, GroupBy and Subselect

how can I do this with queryover and a subquery?

FakturaObjektGutschrift fog = null;
int[] idS = Session.QueryOver(() => fog)
            .SelectList( list => list
                .SelectMax(() => fog.Id)
                .SelectGroup(() => fog.SammelKontierung)   
             ).List<object[]>().Select(x => (int)x[0]).ToArray();

And using the ids in another query

IQueryOver<Beleg, Beleg> sdfsd = Session.QueryOver(() => bGut)
    .AndRestrictionOn(() => fog.Id).IsIn(idS); //iDs is a list of int.

I would like do this with a subquery because there is a limitation on the number of parameters for a SQL query. How do I do this?

How do I write the first query, but without selecting the SelectGroup()? This is exactly where I got stuck.

Upvotes: 1

Views: 458

Answers (1)

Najera
Najera

Reputation: 2879

Group by without projection in QueryOver API is currently not supported link.

You can use LINQ to create the projection in a subquery:

 var subquery = Session.Query<FakturaObjektGutschrift>()
     .GroupBy(x => x.SammelKontierung)
     .Select(x => x.Max(y => y.Id));

 var query = Session.Query<Beleg>()
     .Where(x => subquery.Contains(x.Id));

If you really needs QueryOver to create more complex queries check this solution link.

Upvotes: 2

Related Questions