5

I am adding a new column to my azure table. For ex., the table is called 'User' and the new column is called 'ComputationDate'. The 'User' table already exists with rows that do not have this new column 'ComputationDate'. I have a query over it as follows,

var usersDue = from user in Table.Query where user.ComputationDate != <somedate> select user;

I want this query to return all user rows that do not have ComputationDate set to 'somedate' and also user rows that do not have this new 'ComputationDate' column defined. But the query doesn't return the latter set of users. It only returns rows that have 'ComputationDate' set and where the value is not equal to 'somedate'. Is there any way to get the results I desire without having to get all users and filter it on the client?

STLDev
  • 5,950
  • 25
  • 36
user1198407
  • 381
  • 3
  • 16

1 Answers1

-1

It looks like you're trying to do a LINQ to SQL query.

This may serve your needs better:

var usersDue = from user in Table.Query 
                 where user.ComputationDate != <somedate> 
                    || user.ComputationDate == null
                 select user;
STLDev
  • 5,950
  • 25
  • 36
  • 'null' comparisons don't work with LINQ to SQL - http://stackoverflow.com/questions/4228460/querying-azure-table-storage-for-null-values. Any other ideas? – user1198407 Jan 05 '14 at 19:35
  • @user1198407, I think you meant to say that you cannot use a null comparison on a query to Azure table storage. I took a look at the link you posted - I would suggest modifying your approach to follow the accepted answer's advice for that post. – STLDev Jan 06 '14 at 02:09