public class CustomersViewModel : ViewModelBase

public class MyDataContext

storeEntities _Context;

public storeEntities Context

{

get

if (_Context == null)

{

_Context = new storeEntities();

}

return _Context;

}

}

MyQueryableCollectionView _Data;

public MyQueryableCollectionView Data

{

get

if (_Data == null)

{

var collection = new RadObservableCollection<Customer>();

_Data = new MyQueryableCollectionView(collection);

_Data.PageSize = 10;

Refresh(true);

}

return _Data;

}

}

void Refresh(Boolean needsRefresh)

{

IdeaBlade.EntityModel.EntityScalarQueryOperation<int> countQuery;

if (needsRefresh)

{

countQuery = (from o in (EntityQuery<Customer>)Context.Customers.Where(_Data.FilterDescriptors) select o).AsScalarAsync().Count();

countQuery.Completed += (sender, args) =>

{

_Data.SetTotalItemsCount(args.Result);

};

}

var query = (EntityQuery<Customer>)Context.Customers.OrderBy(o => o.Company)

.Where(Data.FilterDescriptors)

.Sort(Data.SortDescriptors)

.Page(Data.PageIndex, Data.PageSize);

query.ExecuteAsync().Completed += (s, e) =>

{

var source = (RadObservableCollection<Customer>)_Data.SourceCollection;

source.SuspendNotifications();

source.Clear();

source.AddRange(e.Results);

source.ResumeNotifications();

_Data.CollectionChanged += CollectionChanged;

};

}

void CollectionChanged(object sender, System.Collections.Specialized.NotifyCollectionChangedEventArgs e)

{

_Data.CollectionChanged -= CollectionChanged;

Refresh((((Telerik.Windows.Data.QueryableCollectionView)(sender))).NeedsRefresh);

}

public class MyQueryableCollectionView : QueryableCollectionView

public MyQueryableCollectionView(IEnumerable source)

: base(source)

{ }

private int itemCount;

protected override IQueryable CreateView()

{

return IsGrouped ? QueryableSourceCollection.GroupBy(GroupDescriptors) : QueryableSourceCollection;

}

internal void SetTotalItemsCount(int count)

{

itemCount = count;

OnPropertyChanged(new PropertyChangedEventArgs("ItemCount"));

OnPropertyChanged(new PropertyChangedEventArgs("TotalItemCount"));

}

public override int TotalItemCount

{

get

return itemCount;

}

protected set

base.TotalItemCount = value;

}

}

public override int ItemCount

{

get

return itemCount;

}

}

}

}

}

}