I am getting System.InvalidCastException

The original datatable can have null values but in my LINQ I want to exclude these from comparison

How to check for 'not null' in the WHERE clause?

var tmpQry = FROM recOra IN dtOra.AsEnumerable()
             WHERE  recOra.Field<int?>("ELAPSED_RUNTIME_SECS") >= 4
             SELECT NEW { nrecOra = recOra};

Thanks,

-srinivas y.

Hi ysrini;

Try it like this 

var tmpQry = from recOra in dtOra.AsEnumerable()
             where recOra.Field<int>("ELAPSED_RUNTIME_SECS") != null && recOra.Field<int>("ELAPSED_RUNTIME_SECS") >= 4
             select new { nrecOra = recOra};