Linq - Relationship with 3 tables

Question

Good morning. In my project (C# MVC), I need to make a query with three tables, being:

Tabcolecao 1 - N Tabvolume and Tabvolume 1 - N Tobacconist

Example:

I need to present the View as follows:

The first difficulty is to create this query, where a collection can have n volumes, and each volume can have n authors. I am using Entity Framework and Linq.

The second difficulty is the presentation in the View. How to work this data in View and/or Partial Views.

I really appreciate any help.

Carlos

Answer 1

var q = (from c in   Datacontext.Tbcolecao
        join b in Datacontext.Tbvolume on c.ColecaoId equals b.ColecaoId
        join d in Datacontext.tbautor on b.volumeId equals d.volumeId
        where c.ColecaoId == b.ColecaoId && b.volumeId == d.volumeId
                     select new
                     {
                         nomeColecao=c.descricaocolecao
                         .
                         .
                         .
                         nomeVolume = b.descricaoVolume
                         .
                         NomeAutor = d.Nome
                     }
                     );