So far, the literals in our examples have been either String
or Int32
, both of which use the syntax you’d expect from programming. But Entity SQL isn’t very smart about interpreting literal values, and the syntax can be, well, a little verbose. You can find all the gory details on MSDN (search for “Literals (Entity SQL”), but here are the basics:
Now the ugly bit: If you express a literal value using the wrong syntax, you won’t necessarily get an error. But you won’t necessarily get the correct results, either. (And yes, once again, the voice of experience. I want the three days I spent debugging that query back.)
Put On Your Thinking Hat
Can you write an Entity SQL query expression that returns recipes that have no SourceId
assigned?