How to select in select by Linq (Entity framework)

Question

I using entity framework for my database and select or/and include revealing so many data so basically i'm looking for query like this:

var result = DbContext.products
            .select(p=> new {
             p.Id,
             p.Name,
             p.Notes
             .select(n=> new {
                n.date,
                n.text
                             }
            });

Peyman · Accepted Answer · 2015-04-21 01:26:53Z

6

You can use this code:

var result = DbContext.products
        .select(p=> new {
                         Id = p.Id,
                         Name = p.Name,
                         SelectedNodes = p.Notes.select(n=> 
                                             new {n.date, n.text}).ToList()                            
        });

edited Apr 21, 2015 at 1:26

answered Apr 21, 2015 at 0:50

Peyman

3,1361 gold badge21 silver badges32 bronze badges

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

Collectives™ on Stack Overflow

How to select in select by Linq (Entity framework)

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