Converts a SQL query to Query in Entity

Question

Converts a SQL query to Query in Entity

Navigation

#1 by (1 votes)

3

I asked this question in another forum, but the content of the discussion followed another way so I decided to open this topic. Without skipping the subject, how do I perform this SQL query:

select p.RA, p.Nome, p.Modulo, a.Descricao
from inscricao as i, participante as p, Atividade as a 
where i.ParticipanteId = p.ParticipanteId and 
   i.AtividadeId = a.AtividadeId order by p.Modulo

In a query using Entity?

c# entity-framework

asked by anonymous 15.09.2017 / 14:43

1 answer

Is there still reason to use var in JavaScript? [duplicate] how to work with SASS / LESS in real time?

score 1 · Accepted Answer

Try to do as follows.

var query = (from i in dbContext.inscricao
                     join p in dbContext.participante on i.ParticipanteId equals p.ParticipanteId
                     join a in dbContext.Atividade on p.AtividadeId equals a.AtividadeId
                     where i.periodo == ViewModel.periodo && i.data == ViewModel.data.
                     select new {
                         RA = p.RA,
                         Nome = p.Nome,
                         Modulo = p.Modulo,
                         Descricao = a.Descricao
                     })
                     .OrderBy(x => x.Modulo);