[Expand]General Information
[Expand]WinForms Controls
[Collapse]ASP.NET Controls and MVC Extensions
 [Expand]What's Installed
 [Expand]Common Concepts
 [Expand]ASP.NET WebForms Controls
 [Collapse]ASP.NET MVC Extensions
  [Expand]Product Information
  [Expand]Getting Started
  [Expand]Common Concepts
  [Expand]Grid View
  [Expand]Tree List
  [Collapse]Card View
    Overview - CardView
    Main Features - Card View
    [Collapse]Binding to Data
      Binding to Data via Entity Framework (Code First)
      Binding to Data via Entity Framework or LINQ to SQL (Database First)
      Binding to Large Data (Database Server Mode)
     [Expand]Custom Data Binding
    [Expand]Data Representation Basics
    [Expand]Focus and Navigation
    [Expand]Data Editing and Validation
   [Expand]Member Tables
   [Expand]Visual Elements
  [Expand]Pivot Grid
  [Expand]Rich Text Editor
  [Expand]Site Navigation and Layout
  [Expand]HTML Editor
  [Expand]Vertical Grid
  [Expand]Data Editors Extensions
  [Expand]Docking and Popups
  [Expand]File Management
  [Expand]Data and Image Navigation
  [Expand]Multi-Use Site Extensions
  [Expand]Query Builder
 [Expand]Redistribution and Deployment
  Get More Help
 [Expand]API Reference
[Expand]ASP.NET Bootstrap Controls
[Expand]ASP.NET Core Bootstrap Controls
[Expand]WPF Controls
[Expand]Xamarin Controls
[Expand]Windows 10 App Controls
[Expand]Office File API
[Expand]Report and Dashboard Server
[Expand]eXpressApp Framework
[Expand]eXpress Persistent Objects
[Expand]CodeRush Classic
[Expand]Cross-Platform Core Libraries
[Expand]Tools and Utilities
 End-User Documentation
View this topic on docs.devexpress.com (Learn more)

Binding to Large Data (Database Server Mode)

Expanded Database Server Mode Overview

The MVC CardView extension supports a specific binding mode designed to work with large datasets. Within this binding mode, data-aware operations (sorting, grouping, etc.) are performed on the database server side, which is why this mode is called database server mode.

In database server mode, the MVC CardView is bound to a queryable source using the CardViewExtension.BindToLINQ method, which allows the CardView to load data from the queryable source on demand.

When an end-user performs data operations (sorting, filtering, etc.), the CardView generates smart queries to receive only those records that must be displayed on screen. These requests are passed to the associated queryable source. The queryable source translates these requests into the required queries and executes them. This ensures a quick response and improved performance for large data sources.

For end-users, the MVC CardView functions identically in regular and server modes. In database server mode, end-users can use an automatic filtering feature to access a particular data range, sort and filter data, calculate summaries, etc.

Expanded Binding to Data

Perform the following steps to bind the CardView to a data source in database server mode.

  1. Add the CardView to your project

    Add the CardView to your project, and bind it to a data source in regular mode using the Code First development approach or Database First development approach.

  2. Change the View code

    In its View code, use the CardViewExtension.BindToLINQ method to bind the CardView to a data source. This enables binding to data in database server mode.

    Partial View code ("_CardViewPartial.cshtml"):

Expanded Server mode limitations

In server mode, the MVC CardView does not have simultaneous access to bound data in its entirety. This imposes some limitations on its features that are still available in regular binding mode. see the list below for information on features that have limitations in server mode.

  • Custom sorting (using CardViewSettings.CustomColumnSort) and sorting by displayed values are not supported.
  • Filtering by displayed values is not supported. Only filtering by edit values is allowed.
  • Case-sensitive filtering. The extension converts a search string to lower-case before filtering.
  • You can only enable sorting, filtering and summary calculation for unbound columns that are populated using expressions (see CardViewColumn.UnboundExpression).

Expanded See Also

Is this topic helpful?​​​​​​​