Linq to SQL query question

I have a project which uses standard SQL commands/connections and am introducing some functions which use Linq to query the database.

The simple query below
        Dim Db As New CEDataContext
        Dim SysDet = From p In db.SystemDetails _
                     Where p.SysName = s _
                     Select p

        If IsDBNull(p.syscode) Then

        End If

produces an error stating that the variable p is not declared.  I did not think that these had to be declared as they were anonymous types.

Is this error a function of the mixed environment?
How do I resolve the error?

Thanks


AlanStart Free Trial