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.

nhibernate linq-to-nhibernate
Edit
Report