list in entity framework and webapi

Question

I am trying to return employee with three column in .net webapi with entity framework but return gives error saying cannot convert type pf anonymous to emp ..what I am missing

public List<EMPLOYEE_DTLS> GetLoginInfo(string UserId)
{
    var result = (from emp in db.EMPLOYEE_DTLS
                  where emp.UserId == UserId
                  select new
                  {
                      emp.FullName,
                      emp.Role,
                      emp.Designation
                   }).ToList();

    return result;
}

koryakinp · Answer 1 · 2018-08-21T16:16:07.643

Your method returns List<EMPLOYEE_DTLS>, but you are trying to return List of anonymous type.

Assuming you EMPLOYEE_DTLS class has properties FullName, Role and Designation change the type you are selecting:

public List<EMPLOYEE_DTLS> GetLoginInfo(string UserId)
{
   var result = (from emp in db.EMPLOYEE_DTLS
                 where emp.UserId == UserId
                 select new EMPLOYEE_DTLS
                 {
                    FullName = emp.FullName,
                    Role = emp.Role,
                    Designation = emp.Designation
                 }).ToList();

   return result;
}

umutcanturan · Accepted Answer · 2018-08-21T16:38:05.230

0

You should use a DTO to return the list.

public class EmployeeDTO
{
       public string FullName {get; set;}
       public string Role {get; set;}
       public string Designation {get; set;}
}


public List<EmployeeDTO> GetLoginInfo(string UserId)
{
    var result = (from emp in db.EMPLOYEE_DTLS
                   where emp.UserId == UserId
                   select new EmployeeDTO
                   {
                      FullName = emp.FullName,
                      Role = emp.Role,
                      Designation = emp.Designation
                   }).ToList();

    return result;
 }

edited Aug 21 '18 at 16:38

answered Aug 21 '18 at 16:19

umutcanturan

68
7

Thanks but getting error...The entity or complex type 'cannot be constructed in a LINQ to Entities query. – Vitthal Mokhare Aug 21 '18 at 16:28
Are you using the exactly same way? You can look the following link. https://stackoverflow.com/questions/5325797/the-entity-cannot-be-constructed-in-a-linq-to-entities-query By the way for the class properties emp.Designation should be Designation – umutcanturan Aug 21 '18 at 16:37

list in entity framework and webapi

2 Answers2