I was basing my code off the "Performance 300,000 rowcount example". I just assumed that by following that model that the filtering MUST be done at the SQL server level. Is that not correct?
I created a similar grid with a LinqDataSource that uses a DataContext that is LinqToSql.
The paging seems to be done at the SQL server level but when I filter I don't see any additional "where" clause which tells me that SQL server is returning ALL the rows and then .NET/Linq/Telerik/SomeoneElse is doing the filtering.
Is that right? Or do I not have something configured properly so that the LinqDataSource will cause the WHERE to show up at SQL Server?
Thanks,
Kevin
I created a similar grid with a LinqDataSource that uses a DataContext that is LinqToSql.
The paging seems to be done at the SQL server level but when I filter I don't see any additional "where" clause which tells me that SQL server is returning ALL the rows and then .NET/Linq/Telerik/SomeoneElse is doing the filtering.
Is that right? Or do I not have something configured properly so that the LinqDataSource will cause the WHERE to show up at SQL Server?
Thanks,
Kevin