I'm trying to use a linq expression that has a join.I tried with the var result and with List result = , but with both i got the error.
The entity or complex type 'OdontoService.Dal.Consultas' cannot be constructed in a LINQ to Entities query. What is the problem, i cant do that?
Code below:
var result =
context.consultas
.Join(context.pacientes, left => left.id_paciente, right => right.id_paciente,
(left, right) => new { TableAColumns = left, TableBColumns = right }).Select(m => new Consultas
{
id_consulta = m.TableAColumns.id_consulta,
id_paciente = m.TableAColumns.id_paciente,
comentarios = m.TableAColumns.comentarios,
dt_alteracao = m.TableAColumns.dt_alteracao,
dt_inclusao = m.TableAColumns.dt_inclusao,
procedimento = m.TableAColumns.procedimento,
data_consulta = m.TableAColumns.data_consulta,
flg_Situacao = m.TableAColumns.flg_Situacao,
nome_paciente = m.TableBColumns.nome_paciente
}).ToList();