Silverlight RIA Services. Query fails on large table but works with Where clause
- by FauxReal
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