Conversion error

Ramco Ramco

Error - Cannot implicitly convert type system.linq.Iqueryable to system.collection.generic.list

public List GetStudentCurrent(Int32 StudentId)
{
    List Result = (from t in context.StudentDetails
                                  join t2 in context.Student
                                  on t.LoginCode equals t2.StudentID
                                  orderby t.StudentID,t.CreatedOn
                                  select t).Take(1);

    return Result;
}

Thanks

2 Replies

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

Rajanikant Hawaldar3y ago

Accepted answer

public List GetStudentCurrent(Int32 StudentId)
{
    List Result = (from t in context.StudentDetails
                                  join t2 in context.Student
                                  on t.LoginCode equals t2.StudentID
                                  orderby t.StudentID,t.CreatedOn
                                  select t).Take(1).ToList();

    return Result;
}

Amit Mohanty3y ago
To convert IQuerable or IEnumerable to a list, you have to add .ToList() in your query.