This question is locked. New answers and comments are not allowed.
Hi
I'm looking for the best way to take advantage of the data virtualization capabilities in the GridView control.
I've built a simple test for this using the Northwind database querying the Orders table. I have built using WCF RIA a NorthwindDomainService providing me with an IQueryable<Order>.
I'm requesting the orders for the gridview by:
var data = _northwindContext.GetOrdersQuery();
LoadOperation<Order> loadOrders = _northwindContext.Load( data );
loadOrders.Completed += ( s, e ) =>
{
Orders = ( s as LoadOperation<Order> ).Entities.AsEnumerable();
};
( I have also tried binding the entity set as a List<Order> )
What I am seeing is all 830 records (about 277Kb of data) being served immediately even though only 30 records are on the screen.
Is this correct? Is there a way of streaming the data out so the gridview consumes what it needs?
I know that I could use data paging to solve this issue, but a virtualised display would be a better user experience.
The LOB application I am building will have large datasets and a large number of simultaneous connections.
Thanks
Russell
I'm looking for the best way to take advantage of the data virtualization capabilities in the GridView control.
I've built a simple test for this using the Northwind database querying the Orders table. I have built using WCF RIA a NorthwindDomainService providing me with an IQueryable<Order>.
I'm requesting the orders for the gridview by:
var data = _northwindContext.GetOrdersQuery();
LoadOperation<Order> loadOrders = _northwindContext.Load( data );
loadOrders.Completed += ( s, e ) =>
{
Orders = ( s as LoadOperation<Order> ).Entities.AsEnumerable();
};
( I have also tried binding the entity set as a List<Order> )
What I am seeing is all 830 records (about 277Kb of data) being served immediately even though only 30 records are on the screen.
Is this correct? Is there a way of streaming the data out so the gridview consumes what it needs?
I know that I could use data paging to solve this issue, but a virtualised display would be a better user experience.
The LOB application I am building will have large datasets and a large number of simultaneous connections.
Thanks
Russell