Entity Framework LINQ Include - Child Entities

Question

I am loading the child entity UserStarted from my TransactionDetails

var result = (from A in context.Transactions.Include(_ => _.TransactionDetails.Select(us => us.UserStarted))
              select A).SingleOrDefault();

Now I want to load another entity, but I don't know how. The entity is similar to UserStarted, it's the UserEnded also from TransactionDetails

Thank you very much

a-h · Accepted Answer · 2014-06-21 14:10:03Z

1

You can chain multiple include predicates together:

var result = context.Transactions
  .Include(transaction => transaction.TransactionDetails.Select(us => us.UserStarted))
  .Include(transaction => transaction.TransactionDetails.Select(us => us.UserEnded))
  .SingleOrDefault();

answered Jun 21, 2014 at 14:10

a-h

4,3042 gold badges26 silver badges30 bronze badges

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

Comments

arjthakur · Accepted Answer · 2014-06-21 14:14:54Z

1

You can also try

 var result = (from A in context.Transactions.Include(_ => _.TransactionDetails.Select(us => new { UserStarted  = us.UserStarted, UserEnded = us.UserEnded }))
select A).SingleOrDefault();

answered Jun 21, 2014 at 14:14

arjthakur

616 bronze badges

Collectives™ on Stack Overflow

Entity Framework LINQ Include - Child Entities

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related