zzzprojects
Bug on where clause with composite string
Here is what to include in your request to make sure we implement a solution as quickly as possible.
1. Description
Try to execute a query with a where as :
.Where("field1 == @0 & Field2 <> @1", "xxx", "") The second parameter is empty string.
2. Exception
No ecexption raise
3. technical details
Get the log of what entity generates : WHERE (('XXX' = "Extent1"."field1 ") AND ("Extent1"."field1 " IS NOT NULL) AND ( NOT (('' = "Extent1"."Field2 ") AND ("Extent1"."Field2 " IS NOT NULL))))
The error is in Field2 " IS NOT NULL=> shoud be IS NULL without NOT because we set a NOT before :
with Field2 != @1 => gives the same issue
Finally à replace by :
and it works.
It sems that a empty string is not interpreted like a null . Is is interpreded like a char.
And we see EF always add IS NOT NULL....
it is still a bit confusing :)
I let you close or do something ?
