Skip to main content
BuyLog In
ASP.NET Web Forms Controls
Search in…
Docs > Components > Card View > Bind to Data > Bind to Large Data (Database Server Mode) > Bind to Large Data (LINQ)
All docs
V23.2
ASP.NET Web Forms Controls
Prerequisites
Supported Browsers
What's Installed
Get Started
Upgrade to a New Version
Common Concepts
Components
Card View
Deployment
Get Started
Bind to Data
Built-in Card Cache
Connecting ASPxCardView to a Data Source
Bind to Large Data (Database Server Mode)
Bind to Large Data (EF)
Bind to Large Data (LINQ)
Bind to Large Data (XPO)
Database Server Mode Limitations
Data Representation Basics
Focus and Navigation
Edit Data
Data Shaping and Manipulation
Data Formatting
Appearance Customization
Adaptivity
Layout
Templates
Export
Toolbars
Visual Elements
Member Tables
Accessibility Support
Examples
Chart Control
Data and Image Navigation
Data Editors
Diagram
Docking and Popups
File Management
Gantt
Gauges
Grid View
HTML Editor
Multi-Use Site Controls
Pivot Grid
Reporting
Rich Text Editor
Scheduler
Site Navigation and Layout
Spell Checker
Spreadsheet
Tree List
Vertical Grid
Query Builder
Security Considerations
Redistribution and Deployment
Troubleshooting
Get More Help
.NET Framework API Reference
Client API Reference
Download CHM

Bind Card View to Large Data via LINQ

  • 2 minutes to read

The ASPxCardView control allows you to bind to large data sets with the LinqServerModeDataSource component. This component fully supports database server mode (which delegates all data processing to the database server), and loads only records to be displayed on screen. This functionality dramatically increases the control’s performance when working with large datasets.

Server mode can be enabled for any Language-Integrated Query (LINQ) provider. The LinqServerModeDataSource component is designed for ASP.NET applications, and serves as a data source for the ASPxCardView control.

When an end user performs data operations (sorting, filtering, etc.), the LinqServerModeDataSource component analyzes the grid’s current state and generates smart queries that retrieve only records to be displayed on screen. These requests are passed to the associated LINQ Provider. The LINQ Provider translates them into the required queries and executes them.

Example

The LinqServerModeDataSource component allows you to bind ASPxCardView to ‘LINQ to SQL Classes’ and enable server mode.

Create Data Classes

  1. Add ‘LINQ to SQL Classes’.

    ASPxCardView_LINQ-SQLClasses

  2. Data classes can then be created and edited in the Object Relational Designer (O/R Designer). The O/R Designer provides a visual design surface to create LINQ to SQL entity classes and relationships based on database objects. The O/R Designer currently supports only SQL Server 2000, SQL Server 2005, SQL Server 2008, and SQL Server Express databases.

    You can drag database tables and views from Server Explorer/Database Explorer onto the O/R Designer to create entity classes, and map them to tables and views.

  3. Save your changes, close the O/R Designer, and rebuild the solution.

LinqServerModeDataSource

  1. Drag the LinqServerModeDataSource component and drop it onto the Page.
  2. Specify the type of objects retrieved from a data source, using the LinqServerModeDataSource.ContextTypeName property.
  3. Use the LinqServerModeDataSource.TableName property to specify the data table name.
  4. Bind the ASPxCardView control to the LinqServerModeDataSource component, and specify the grid’s ASPxGridBase.KeyFieldName property.

Database Server Mode Limitations

In database server mode, ASPxCardView does not have simultaneous access to bound data in its entirety. This imposes some limitations on the grid’s features, which are still available in regular binding mode. See the following help topic for information on features that are not supported in server mode: Database Server Mode Limitations.

See Also