Silverlight RIA Services. Query fails on large table but works with Where clause
        Posted  
        
            by FauxReal
        on Stack Overflow
        
        See other posts from Stack Overflow
        
            or by FauxReal
        
        
        
        Published on 2010-05-25T21:27:20Z
        Indexed on 
            2010/05/25
            21:31 UTC
        
        
        Read the original article
        Hit count: 701
        
I have a somewhat large table, maybe 2000 rows by 50 columns.
When using the most basic imaginable RIA implementation.
Create one-table Model
Create DomainService
Drop datagrid onto MainPage.xaml
Drop datasource onto datagrid
Ctrl-F5
I get this error:
System.ServiceModel.DomainServices.Client.DomainOperationException: Load operation faild for query. Value cannot be null.
Error is much larger, but thats the beginning of it.
The weird thing is that if I narrow the results down with a where clause on the GetQuery, it works fine. In fact six different querys which together result in all of the rows being called works fine also. So basically, I'm sure its not some sort of rogue row.
Why do I get this "Value cannot be null" error if I query the whole table?
Thanks
© Stack Overflow or respective owner