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?