How do I write a query to include three connected tables

Marius Vasile

I have three tables, PTWMain, PTWSubsequent and PTWContent. The relation between them is PTWMain can have multiple PTWSubsequent but only one PTWContent and PTWSubsequent can have only one PTWContent. I try to write a query to get related data from all tables but I failed. What I tried is

PTWContents = await _context.PTWContents.Include(s => s.PTWMain).Include(s => s.PTWSubsequent).ToListAsync();

but this query simple ignore the PTWSubsequent. How it should be written?

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Sachin Singh5y ago
Accepted answer
each Main has multiple Contents and each content has one subsequent
PTWContents = await _context.Main.Include(s => s.PTWContents).ThenInclude(s => s.PTWSubsequent).ToListAsync();
Marius Vasile5y ago
Each Main and Sub has only one Content. Main can have multiple Sub