This is a migrated thread and some comments may be shown as answers.

Data virtualization query

1 Answer 25 Views

GridView

This is a migrated thread and some comments may be shown as answers.

Rus asked on 26 Apr 2010, 05:37 PM

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

Data virtualization query

1 Answer, 1 is accepted