Blazing fast performance with RadGridView for WPF 4.0 and Entity Framework 4.0
Posted by: the telerik blogs,
on 15 Apr 2010 |
View original | Bookmarked: 0 time(s)
Just before our upcoming release of Q1 2010 SP1 (early next week), Ive decided to check how RadGridView for WPF will handle complex Entity Framework 4.0 query with almost 2 million records:
public class MyDataContext{ IQueryable _Data; public IQueryable Data { get { if (_Data == null) { var northwindEntities = new NorthwindEntities(); var queryable = from o in northwindEntities.Orders from od in northwindEntities.Order_Details select new { od.OrderID, od.ProductID, od.UnitPrice, od.Quantity, od.Discount, o.CustomerID, o.EmployeeID, o.OrderDate }; _Data = queryable.OrderBy(i => i.OrderID); } return _Data; } }}
The grid is bound completely codeless in XAML using RadDataPager with PageSize set to 50:
<Window x:Class="WpfApplication1.MainWindow"
xmlns="http://schemas.microsoft.com/winfx/2006/xaml/presentation"
xmlns:x="http://schemas.microsoft.com/winfx/2006/xaml"
xmlns:telerik="http://schemas.telerik.com/2008/xaml/presentation"
Title="MainWindow" mc...