[Solved] VirtualQueryableCollectionView

[Sriram]

Dear Telerik Team,

How to use VirtualQueryableCollectionView with paging.. for large amount of data we r using domaindatasource. can i use VirtualQueryableCollectionView for the the alternate for DomainDataSource. please post example code

[Vlad]

Hello,

 Have you checked our demo? The grid is bound to VirtualQueryableCollectionView and data are loaded on demand from WCF RIA Service. You can download our QSF and check ExamplesDataContext in DataVirtualization project. I'm post the code here as well:

public class ExamplesDataContext : ViewModelBase
    {
        NorthwindDomainContext _Context;
        public NorthwindDomainContext Context
        {
            get
            {
                if (_Context == null)
                {
                    _Context = new NorthwindDomainContext();

                }

                return _Context;
            }
        }

        VirtualQueryableCollectionView _Customers;
        public VirtualQueryableCollectionView Customers
        {
            get
            {
                if (_Customers == null)
                {
                    _Customers = new VirtualQueryableCollectionView();
                    _Customers.VirtualItemCount = 100; // Force ItemsLoading to get the real total item count and data in a single request
                    _Customers.LoadSize = 10;

                    _Customers.ItemsLoading += Customers_ItemsLoading;
                }

                return _Customers;
            }
            private set
            {
                if (this._Customers != value)
                {
                    _Customers.ItemsLoading -= Customers_ItemsLoading;

                    this._Customers = value;
                    this.OnPropertyChanged("Customers");
                }
            }
        }

        void Customers_ItemsLoading(object sender, VirtualQueryableCollectionViewItemsLoadingEventArgs e)
        {
            EntityQuery<Customer> query = Context.GetCustomersQuery();
            query.IncludeTotalCount = true;
            Context.Load<Customer>(EntityQueryExtensions.Sort<Customer>(query, Customers.SortDescriptors).Skip(e.StartIndex).Take(e.ItemCount),
                LoadBehavior.RefreshCurrent, CustomersLoaded, e.StartIndex);
        }

        private void CustomersLoaded(LoadOperation lo)
        {
            if (lo.TotalEntityCount != Customers.VirtualItemCount)
            {
                Customers.VirtualItemCount = lo.TotalEntityCount;
            }

            Customers.Load((int)lo.UserState, lo.Entities);
        }

        public void ClearLoadedCustomers()
        {
            this.Customers = null;
        }
    }

Regards,
Vlad
the Telerik team

[Sriram]

Dear Telerik Team,

it is working great.
can i use

VirtualQueryableCollectionView as an alternate of domaindatasource??

[Vlad]

Hello,

Indeed you can use the collection to load data on demand similar to DomainDataSource 
and I'm happy to inform you that we will release our own DomainDataSource with the first service pack of our Q3 - most probably early December this year. 

All the best,
Vlad
the Telerik team

[Hicham]

I have not used your class yet but I would like to understand the logic.
Does it just encapsulate the order().skip().take() logic on the client side or does it offer some caching on the server side?
Thank you.

[Vlad]

Hello,

 VirtualQueryableCollectionView will cache item on the client once the item is loaded. 

Regards,
Vlad
the Telerik team