Entity Framework .Include() Navigation of another Navigation property

Question

I have an entity Test. It contains a Navaigation Property Question and Question contains a Navigation Property QuestionLocale.

var test = context.Tests
       .Include("Question")
       .FirstOrDefault();

works as expected. But how is it possible to include the QuestionLocale?

Klinger · Accepted Answer · 2019-06-07T03:33:21.027

66

You can use:


var test = context.Tests
                  .Include("Question.QuestionLocale")
                  .FirstOrDefault();

edited Jun 07 '19 at 03:33

answered Mar 05 '09 at 13:51

Klinger

2

With EntityFramework 4.1 and later, I believe, there is an extension in System.Data.Entity on IDbSet where you can write .Include(x => x.Question.QuestionLocale). – angularsen Oct 11 '12 at 09:11
1

@AndreasLarsen, any specifics on `.Include(x => x.Question.QuestionLocale)`? I can't figure out exactly how to do that... – edobry Dec 15 '12 at 19:50
@edobry add a using statement: `System.Data.Entity` then when you type `.Include()` there will be overloads for the lambda. – The Muffin Man Dec 16 '12 at 03:39
1

This answer has just saved me from hours of headache. Thanks a lot ! – ZipionLive Aug 21 '14 at 09:20
fantastic. I wasted several hours to find this solution. – magicandre1981 May 06 '16 at 15:42

score 4 · Answer 2 · answered Jan 09 '20 at 19:37

4

You can do it in a strongly typed way too

var test = context.Tests
                .Include(x => x.Question.Select(child => child.QuestionLocale))
                .FirstOrDefault()

answered Jan 09 '20 at 19:37

score 4 · Answer 3 · answered May 16 '22 at 06:57

4

Now there is ThenInclude see Microsoft Documentation, that solved it for me

var test = context.Tests.Include(x => x.Question).ThenInclude(q => q.QuestionLocale).FirstOrDefault();

answered May 16 '22 at 06:57

N3Q

3 Answers3