I am implementing a section of controls which get repeated and decided to use repeater which is a control I've used in the past. However, I'm noticing a drastic speed degradation using Entity Framework vs. ADO.Net. Not sure if I'm doing something incorrectly
but my data takes forever, up to several minutes on larger queries...Does anyone have a suggestion on how to improve my performance? Also, is there a better way? I've used the repeater in .Net 2.0 and 3.0 but am not sure if there is a better control to use
since 4.0 has been released. Also, last bit of information..I am binding alot of controls in the item_databound event of the repeater. Not sure if this matters.
FunkyMonk81
Member
109 Points
89 Posts
Repeater using Entity Framework
Apr 27, 2012 01:07 PM|LINK
I am implementing a section of controls which get repeated and decided to use repeater which is a control I've used in the past. However, I'm noticing a drastic speed degradation using Entity Framework vs. ADO.Net. Not sure if I'm doing something incorrectly but my data takes forever, up to several minutes on larger queries...Does anyone have a suggestion on how to improve my performance? Also, is there a better way? I've used the repeater in .Net 2.0 and 3.0 but am not sure if there is a better control to use since 4.0 has been released. Also, last bit of information..I am binding alot of controls in the item_databound event of the repeater. Not sure if this matters.
chiragtoad
Member
212 Points
51 Posts
Re: Repeater using Entity Framework
Apr 27, 2012 01:27 PM|LINK
check this link this may help you
http://asp.net.bigresource.com/c-Loading-a-nested-repeater-with-Data-from-2-Entity-Framework-Queries--hihh3MGta.html
ArifKIBRIT
Member
38 Points
9 Posts
Re: Repeater using Entity Framework
Apr 27, 2012 01:28 PM|LINK
i am using LINQ for all :)
http://msdn.microsoft.com/en-us/library/bb397972.aspx
check it ;)
FunkyMonk81
Member
109 Points
89 Posts
Re: Repeater using Entity Framework
Apr 27, 2012 03:06 PM|LINK
Is there any better control for repeating data and/or controls? Im familiar with the repeater but am not sure if something newer is used.
Qin Dian Tan...
All-Star
113532 Points
12480 Posts
Microsoft
Re: Repeater using Entity Framework
May 02, 2012 08:16 AM|LINK
Hi,
You can use GridView or ListView with pager, which can improve performance.
http://www.codeproject.com/Articles/125541/Effective-Paging-with-GridView-Control-in-ASP-NET
http://weblogs.asp.net/scottgu/archive/2006/01/01/434314.aspx
Thanks,
If you have any feedback about my replies, please contactmsdnmg@microsoft.com.
Microsoft One Code Framework