CODEWITHSUNDEEP
nhibernatelinq-to-nhibernate
Leon
Leon

Reputation: 141

fluent nhibernate not supported exception newexpression

can anyone help me figure out what I'm doing wrong. I'm new to nhibernate and I'm finding it quite hard to really get comfortable with it. I have this query:

        var results2 = (from purchase in _session.Query<Purchase>()
                        group purchase by new { purchase.symbol } into purchases
                        select new Quote()
                        {
                            shares= purchases.Sum(p => p.shares)
                        }).ToList();

but I get notsupportedexception and the error message is just newexpression.

Upvotes: 10

Views: 1047

Answers (1)

NOtherDev
NOtherDev

Reputation: 9672

Looking at the question's date, I guess that question was about NHibernate pre-3.2.

Assuming that your Quote is a simple POCO class and you use NHibernate 3.2 or later, this query works fine - see my blog post for some details about GroupBy capabilities in NHibernate.

So the solution simply is to upgrade.

Upvotes: 1

Related Questions