LINQ in VB InvalidCastException

Question

Hi,

I run into this problem

System.InvalidCastException: Unable to cast object of type 'System.Data.Linq.DataQuery1[Student]' to type 'System.Collections.Generic.List1[Student]'

When I debug this function:

Public Shared Function SearchStudent(ByVal firstname As String) As List(Of Student)

    Dim db As New DemoDataContext()
    Dim query = From st In db.Students _
                Where (st.FirstName.StartsWith(firstname)) _
                Select st

    Return CType(query, List(Of Student))


End Function

My project property setting: Option explicit ON and Option strict ON

I want to return a List of Student from the query. Can anyone help me? Thank you.

Answer 1

    Dim query = (From st In db.Students _
            Where (st.FirstName.StartsWith(firstname)) _
            Select st).ToList()