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: 648

Filed under:
|
|

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

Related posts about Silverlight

Related posts about Services