How to filter a nullable column in linq to edm

R

Roy

I have a linq query
Select MyObject from db.MyObjectCollection
to select records from table.

The filter (where) is based on a nullable column in the table. The column
could be a simple string value or a reference to another table. I tried

"where MyObject.MyColumn == null"
and "where MyObject.MyAnotherObject.Id == null"

Both does not work.

Anyone has the syntax for the filter with nullable values?
Thanks.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

set a nullable property in object 2
Bug in the Entity Framework? 0
Linq GroupBy 4
Linq to Sql: Adding nullable association in O/R Designer 3
Merge binary serialized nullable datetime field 1
Linq Query of class PropertyInfo 2
DataTable.Load(DataReader) and nullable primary key problem 4
How is System.Data.DataTable.Load() determining whether a column is a primary key? 1

Top