I have a Query in SQL Server :
SELECT * FROM MyTable t WHERE ISNULL(t.Status,'') = ''
How I can do it in Entity Framework?
EDIT: Oh Sorry my code was like
WHERE ISNULL(t.Status,'') = ''
Try something like
MyTable.Where( t => (t.Status ?? "") == "CO" )
Although the question is ok, the logic isn't sound.
Because if a value is equal to
CO, it can never be equal to either
In this case you could just easily call it like this:
SELECT * FROM MyTable t WHERE t.Status = 'CO'
var items = (from t in db.MyTable where t.Status == "CO" select t);
However if you would need it to have a default value when
NULL and compare to that value it would make more sense (see example):
SELECT * FROM MyTable t WHERE ISNULL(t.Status, 'CO') = 'CO'
var items = (from t in db.MyTable where (t.Status ?? "CO") == "CO" select t);
This would give you all items where t.Status is
NULL or equal to
This is, of course, just an example.
Note: The generated sql would probably be slightly different, but the result is the same. It would probably look something like this:
SELECT * FROM MyTable t WHERE COALESCE(t.Status, 'CO') = 'CO'