Error - Cannot implicitly convert Anonymous type to generic list

Ramco Ramco

4y1.5k.NET

On below code i am getting above error

public List GetOrderingInput()
{
List Result = (from t in context.View_SessionDeliveryCalendarDetails_Students
join t2 in context.View_BookDeliveryDetails
on new { p1 = (int)t.BookID, p2 = (int)t.StudentID} equals new { p1 = (int)t2.BookID, p2 = (int)t2.StudentID }
where t.CurrentStatus == "Due"
orderby t.Name
select new {t.Name,t2.AURL }).ToList();
return Result;
}

3 Replies

Know the answer? Post it — somebody with the same question will find it here.

Ramco Ramco4y ago
Hi sachin

On Aurl it says - View_SessionDeliveryCalendarDetails_Student does not contain a definition for AURL
AURL is in T2

Thanks
Sachin Singh4y ago
Yes, you can't send an anonymoust type a named .NET type.
use this
public List GetOrderingInput()
        {
            List Result = (from t in context.View_SessionDeliveryCalendarDetails_Students
                                                        join t2 in context.View_BookDeliveryDetails
                                                        on new { p1 = (int)t.BookID, p2 = (int)t.StudentID} equals new { p1 = (int)t2.BookID, p2 = (int)t2.StudentID }
                                                        where t.CurrentStatus == "Due"
                                                        orderby t.Name
                                                        select new View_SessionDeliveryCalendarDetails_Student{Name=t.Name,AURL=t2.AURL }).ToList();
             return Result;
        }
Guest User4y ago
You define a List to which you try to add the anonymous select new {t.Name,t2.AURL }

Try to use this instead:
select new View_SessionDeliveryCalendarDetails_Student { t.Name, t2.AURL }

Name and AURL need to match existing properties of your class, for example:
select new View_SessionDeliveryCalendarDetails_Student { Name = t.Name, Url = t2.AURL }