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: 465
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.
© Dot net Slackers or respective owner