Wsrtjtyk

I want to get the check in status of employees but it is only letting me to return one of them, First or FirstOrDefault when i try to convert it to a list it's telling me:

Cannot convert List<> to ..Data.Entities.Checkinout

EmployeeCollection = (from userinfo in context.Userinfo

   join department in context.Dept on userinfo.Deptid equals department.Deptid

   where id == userinfo.Userid

   select new Employee()

   {

     Name = userinfo.Name,

     Department = department.DeptName,

     CardNumber = userinfo.CardNum,

     Status = userinfo.UserFlag.ToString(),

     ActualCheckinStatuse = (from checkinout in context.Checkinout

         join status in context.Status on checkinout.CheckType equals status.Statusid

         where checkinout.Userid == userinfo.Userid

         orderby checkinout.CheckTime descending

         select new Checkinout

         {

           CheckStatus = status.StatusText,

           CheckTime = checkinout.CheckTime

         }).First()

   }

).ToList()

A part of your code looks like this:

       new Employee()

{

  Name = ...,

  Department = ...,

  CardNumber = ...,

  Status = ...,

  ActualCheckinStatuse = (from checkinout in context.Checkinout

      join status in context.Status on checkinout.CheckType equals status.Statusid

      where checkinout.Userid == userinfo.Userid

      orderby checkinout.CheckTime descending

      select new Checkinout

      {

        CheckStatus = status.StatusText,

        CheckTime = checkinout.CheckTime

      }).First()

}

Here, the expression (from checkinout in ... select new Checkinout { ... }) will be an enumeration (or sequence, if you prefer) of Checkinout instances. When you do .First() on that, as above, the result will be one instance of type Checkinout.

As far as I understand, that compiles well. And it is because the property ActualCheckinStatuse that you assign to in this initializer, has the same declared type, Checkinout.

If instead after this parenthesis (from checkinout in ... select new Checkinout { ... }) you append .ToList(), then what you get is all those Checkinout instances in a .NET List<> in memory. Sure enough you cannot assign that to ActualCheckinStatuse because the types are not compatible. One Checkinout called ActualCheckinStatuse cannot be set to a whole List<> of such Checkinouts.