Maximum performance using Telerik RadGrid client-side data-binding with LINQ to SQL

Posted by: the telerik blogs, on 17 Jul 2008 | View original | Bookmarked: 0 time(s)

As I mentioned in one of my previous posts with RadGrid for ASP.NET AJAX Q2 2008 you can access the grid sort and filter expressions on the client.

While filter expressions toString() method will create SQL syntax representing current grid filtering now you have toDynamicLinq() method which will create LINQ expression that can be used directly with Dynamic LINQ library.

With few lines of code you will get minimum transfer between server and client (pure JSON):

Post request to the server

Response from the server

and on the server side LINQ to SQL will apply all requested operations directly on the data-base server:

SQL Server Profiler

Live Demo | Download

Category: SQL | Other Posts: View all posts by this blogger | Report as irrelevant | View bloggers stats | Views: 3454 | Hits: 17

Similar Posts

  • CodeDigest.Com Article,Codes,FAQs - April,2009 more
  • Microsoft Ajax 4.0 Preview 4 now available more
  • Convert Web.UI Grid into a data entry spreadsheet more
  • Running the Same Query Against Multiple Databases more
  • RadTreeView for ASP.NET Ajax - Binding to LinqDataSource more
  • RadTips, Episode 7: Customizing RadScheduler Appointments with Resources more
  • Emulating Paging with RadGridView for WinForms and LINQ with 1 million records more
  • Telerik Unveils RadControls for ASP.NET AJAX Q1 2008 more
  • LINQ To SQL more
  • Speed Development Time by 50% more

News Categories

.NET | Agile | Ajax | Architecture | ASP.NET | BizTalk | C# | Certification | Data | DataGrid | DataSet | Debugger | DotNetNuke | Events | GridView | IIS | Indigo | JavaScript | Mobile | Mono | Patterns and Practices | Performance | Podcast | Refactor | Regex | Security | Sharepoint | Silverlight | Smart Client Applications | Software | SQL | VB.NET | Visual Studio | W3 | WCF | WinFx | WPF | WSE | XAML | XLinq | XML | XSD