This question is locked. New answers and comments are not allowed.
Hi,
I'm solving pretty common scenario. I have say 500 records in some database table. I want to show them as quickly as possible into RagGrid with some paging, sorting and filtering. As far as I know there ase many ways. Which one is "best pratice" and most performance capable?
I'm solving pretty common scenario. I have say 500 records in some database table. I want to show them as quickly as possible into RagGrid with some paging, sorting and filtering. As far as I know there ase many ways. Which one is "best pratice" and most performance capable?
- Standard OpenAccessLinqDatasource with dynamic "where" in code
<
telerik:OpenAccessLinqDataSource
runat
=
"server"
ID
=
"ldsCustomers"
ContextTypeName
=
"MyDataContext"
EnableDelete
=
"True"
EnableInsert
=
"True"
EnableUpdate
=
"True"
ResourceSetName
=
"Customers"
/>
- Using NeedDataSource event of RadGrid
Dim
dc
As
New
DataContext
'it is declared in masterpage in real application
Dim
myRecords=from q in dc.Customers OrderBy q.Name
Select
q
rgCustomers.DataSource=myRecords
- Using OpenAccessLinqDataSource, but replace results
Dim
dc
As
New
DataContext
'it is declared in masterpage in real application
Dim
myRecords=from q in dc.Customers OrderBy q.Name
Select
q
e.Result=myRecords
Are there some performance guidelines for OpenAccess in ASP.NET applications?