IT:AD:EF:HowTo:Queries/Compare Null or Empty Strings
Summary
Amazingly, EF fails when comparing a two strings, when one of them is null.
Solution
The work around is to compare as follows:
var result = from entry in table
where (value == null ? entry.something == null : entry.something == value)
select entry;