Blazing fast performance with RadGridView for WPF 4.0 and Entity Framework 4.0

Posted on Dot net Slackers See other posts from Dot net Slackers
Published on Thu, 15 Apr 2010 00:00:00 GMT Indexed on 2010/04/15 14:43 UTC
Read the original article Hit count: 462

Filed under:

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...

Did you know that DotNetSlackers also publishes .net articles written by top known .net Authors? We already have over 80 articles in several categories including Silverlight. Take a look: here.



Email this Article

© Dot net Slackers or respective owner