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: 1 | Hits: 0

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