Simple Query resulting in error
Posted: Thu 14 Jul 2011 15:45
I have written a simple query that is producing the following error "The method is not supported with specified arguments"
The issue I have narrowed down to the where clause of the statement below, however it doesn't make sense to me. The field I am evaluating is a nullable DateTime fields, yet if I evaluate that field for != null I get this error.
var data1 = (from a in context.BATCH_UPLOAD
join b in context.STATUS on a.STAT_ID equals b.STAT_ID
join c in context.COMPONENT on a.COMP_ID equals c.COMP_ID
where a.LAST_UPDATE_TS != null
select a).ToList();
The issue I have narrowed down to the where clause of the statement below, however it doesn't make sense to me. The field I am evaluating is a nullable DateTime fields, yet if I evaluate that field for != null I get this error.
var data1 = (from a in context.BATCH_UPLOAD
join b in context.STATUS on a.STAT_ID equals b.STAT_ID
join c in context.COMPONENT on a.COMP_ID equals c.COMP_ID
where a.LAST_UPDATE_TS != null
select a).ToList();