Suppose an SQL table 'employees' (containing a nullable datetime field called 'endDate')
dim result = db.employees.where(function(c) not(c.endDate.hasValue))
dim result = db.employees.where("it.endDate == null")
Throws an error
Operator '=' incompatible with operand types 'DateTime?' and 'Boolean'
Now I am completely blocked in my project because of this issue. Any of you already faced this problem ?
Thanks a lot in advance - zSkk
there is nothing like ==(double equal) in SQL , use =(single equal) if you want to compare.