Nested select not working in NHibernate.Linq

Question

I want to load the list of users and their roles, with this query:

var q = from u in session.Linq<User>()
    select new
    {
        u.Name,
        u.Password,                                
        Roles = from r in u.Roles
                select new { r.Code, r.Name }
    };

But this query is not working. Produce the following error: "The method 'Select' is not implemented."

¿The message suggest that NHibernate.Linq not support nested selects? I want to know if this is certain or exist other way to do this?

PD: please excuse my bad english.

Sly · Accepted Answer · 2010-02-26 10:59:41Z

1

Current implementation of Linq provider is based on CriteriaApi and that why it can create only simple queries

answered Feb 26, 2010 at 10:59

Sly

15.3k13 gold badges64 silver badges90 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Nested select not working in NHibernate.Linq

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related