Consuming web api with various models

Question

In that question of mine Doubt Verb GET Webapi I face some mistakes because of relationships. But now taking it as a basis on account of my models, how could I consume this service? Because the Tabela1 model has relationships and I needed to bring them to the MVC that I’m using to consume... But what happens is that relationships, models, do not come filled, comes null...

My controller on Asp.net mvc:

    public ActionResult Index()
    {
        //Varialvel resposável por receber os dados que estão no banco de dados para mostrar na tela
        HttpResponseMessage resposta = cliente.GetAsync("http://meuservico/api/servico").Result;

        //Se der tudo certo, é porque trouxe os dados retornando código 200
        if (resposta.IsSuccessStatusCode)
        {
            //Formata o json para mostrar na tela
            var result = resposta.Content.ReadAsAsync<IEnumerable<Tabela1>>().Result;

            //retorna para a tela os json formatado
            return View(result);
        }

        //Caso tenha dado errado, retorna somente a tela sem dado algum
        return View();
    }

The result variable brings the model Table 1 filled in, but their relationships do not... What could be happening?

Answer 1

According to the link response code:

public IQueryable GetVerb()
{
    var dados = from d in db.Tabela1
                join a in db.Tabela2 on d.Tabela1_Tabela2Id equals a.Tabela2Id
                select new 
                {
                    nome = d.Nome,
                    cnpj = d.CNPJ,
                    endereco = a.Endereco,
                    cidade = a.Cidade,
                    cep = a.CEP,
                };

    return (dados);             
}

The method GetVerb() returns a list of a generic that was created in select. So if you are restricting to return all records from Tabela1 along with your relationships Tabela2, there is no way consumers of your API receive this data.

public IQueryable GetVerb()
{
    var dados = from d in db.Tabela1
                join a in db.Tabela2 on d.Tabela1_Tabela2Id equals a.Tabela2Id
                select new 
                {
                    nome = d.Nome,
                    cnpj = d.CNPJ,
                    endereco = a.Endereco,
                    cidade = a.Cidade,
                    cep = a.CEP,
                    tabela2 = a // <====
                };

    return (dados);             
}

Finally, make all your flow asynchronous:

public async Task<ActionResult> Index()
{
    var response = await cliente.GetAsync("http://meuservico/api/servico");
    if (!response.IsSuccessStatusCode) return View();

    var list = await response.Content.ReadAsAsync<IEnumerable<Table1>>();
    return View(list);
}