I am on the latest version here are some queries and the results, I will do things the old way for now.
Dim q1 = From d In meta.Document Where d.PartId = Nothing Select d
q1.ToArray()
The binary operator Equal is not defined for the types 'System.Int32' and 'System.Nullable`1[System.Int32]'.
Dim q2 = From d In meta.Document Where d.PartId <> Nothing Select d
q2.ToArray()
The binary operator NotEqual is not defined for the types 'System.Int32' and 'System.Nullable`1[System.Int32]'.
Dim q3 = From d In meta.Document Where d.PartId = 5 Select d
q3.ToArray()
The binary operator Equal is not defined for the types 'System.Int32' and 'System.Nullable`1[System.Int32]'.
Dim q4 = From d In meta.Document Where d.PartId.Value = 5 Select d
q4.ToArray()
No known database function mapping found for property 'Value'
Dim q5a = From d In meta.Document Where d.CompanyId = 5 Select d
q5a.ToArray()
Works
Dim q6 = From d In meta.Document Where CInt(d.PartId) = 2 Select d
q6.ToArray()
Works
Dim q7 = From d In meta.Document Where d.PartId.Value.Equals(5) Select d
q7.ToArray()
No known database function mapping found for property 'Value'
Dim q8 = From d In meta.Document Where d.PartId.Equals(Nothing) Select d
q8.ToArray()
The binary operator Equal is not defined for the types 'System.Int32' and 'System.Object'.