Log In
Home
Support
Demos
Documentation
Blogs
Training
Webinars
[Expand]General Information
[Collapse]WinForms Controls
  Prerequisites
 [Expand]What's Installed
 [Expand]Build an Application
 [Collapse]Controls and Libraries
  [Expand]Forms and User Controls
  [Expand]Messages, Notifications and Dialogs
  [Expand]Editors and Simple Controls
  [Expand]Ribbon, Bars and Menu
  [Expand]Application UI Manager
  [Expand]Docking Library
  [Collapse]Data Grid
   [Expand]Getting Started
   [Collapse]Binding to Data
    [Collapse]Server Mode
      Regular Binding Mode vs Regular Server Mode vs Instant Feedback Mode
      Grid Features Supported in Server Mode
      Server Mode Limitations
      Data Stores Supported in Server Mode When Using XPO
      Server Mode: Binding to a Data Source Using eXpress Persistent Objects
      Instant Feedback Mode
      Tutorial: Large Data Sources and Instant Feedback with Server Mode
     Grid Control Binding Specifics
     Posting Data to a Connected Database
     Unbound Columns
     Binding to Entity Framework Models
     Binding via Data Source Configuration Wizard
     Fluent API Support
     Member Table: Data Binding
     Tutorial: ADO.NET Data
     Tutorial: Create and Manage Columns at Design Time
     Tutorial: Create and Manage Data in Code and Apply Data Annotation Attributes
     Tutorial: Entity Framework Data
     Tutorial: Unbound Columns
     Tutorial: Working with Columns in Code
   [Expand]Grid View
   [Expand]View Technology
   [Expand]Grouping
   [Expand]Sorting
   [Expand]Summaries
   [Expand]Data Editing
   [Expand]Filtering and Locating Rows
   [Expand]Focus and Selection Handling
   [Expand]Processing Rows
   [Expand]Formatting Cell Values
   [Expand]Master-Detail Relationships
   [Expand]Asynchronous Image Load
   [Expand]Export and Printing
   [Expand]Appearance and Conditional Formatting
   [Expand]Batch Modifications
   [Expand]Hit Information
   [Expand]Hints
   [Expand]Popup Menus
   [Expand]Saving and Restoring Layouts
   [Expand]Visual Elements
   [Expand]Design-Time Features
   [Expand]Examples
   [Expand]End-User Capabilities
    Included Components
  [Expand]Vertical Grid
  [Expand]Pivot Grid
  [Expand]Tree List
  [Expand]Chart Control
  [Expand]Diagrams
  [Expand]Gauges
  [Expand]Map Control
  [Expand]Scheduler
  [Expand]Spreadsheet
  [Expand]Rich Text Editor
  [Expand]Spell Checker
  [Expand]Form Layout Managers
  [Expand]Navigation Controls
  [Expand]Printing-Exporting
  [Expand]PDF Viewer
   Reporting
  [Expand]Snap
  [Expand]TreeMap Control
 [Expand]Common Features
  Get More Help
 [Expand]API Reference
[Expand]ASP.NET Controls and MVC Extensions
[Expand]ASP.NET Bootstrap Controls
[Expand]WPF Controls
[Expand]Xamarin Controls
[Expand]Windows 10 App Controls
[Expand]Document Server
[Expand]Reporting
[Expand]Report Server
[Expand]Dashboard
[Expand]eXpressApp Framework
[Expand]CodeRush
[Expand]Cross-Platform Core Libraries
[Expand]Tools and Utilities
 End-User Documentation

Data Stores Supported in Server Mode When Using XPO

This topic covers the databases supported in server mode when using the eXpress Persistent Objects (XPO) library. The databases supported by XPO are as follows:

Database Engine Version(s) XPO Data Store Adapter Database Provider Assembly
Advantage Advantage Database Server v9.1, Advantage Database Server v10.1, Advantage Database Server v11.1 AdvantageConnectionProvider Advantage.Data.Provider.dll 9.10.2.0
Advantage.Data.Provider.dll 10.10.0.49
Advantage.Data.Provider.dll 11.10.2.24
ASA SQL Anywhere 16, SQL Anywhere 17 AsaConnectionProvider iAnywhere.Data.SQLAnywhere.dll 16.0.0.13242
Sap.Data.SQLAnywhere.v4.0 17.0.0.13584
Sap.Data.SQLAnywhere.v4.5 17.0.0.13584
ASE Sybase Adaptive Server 12, Sybase Adaptive Server 15.5, Sybase Adaptive Server 16 AseConnectionProvider Sybase.Data.AseClient.dll 1.15.50.0
Sybase.AdoNet2.AseClient 16.0.0.2
Sybase.AdoNet35.AseClient 16.0.0.2
Sybase.AdoNet4.AseClient 16.0.0.2
DB2 DB2 9.7.4 DB2ConnectionProvider IBM.Data.DB2.dll 9.7.4.4
Firebird Firebird 1.5, Firebird 2.1.3 FirebirdConnectionProvider FirebirdSql.Data.Firebird.dll 1.7.1.0
FirebirdSql.Data.FirebirdClient.dll 2.5.1.0
MSAccess Microsoft Jet AccessConnectionProvider System.Data.dll
MSSqlServer Microsoft SqlServer 7.0, Microsoft SqlServer 2000, MS SQL Server 2000 Desktop Engine (MSDE 2000), Microsoft SQL Server 2005,
SQL Server 2005 Express Edition, SQL Server 2008, SQL Azure™ Database, SQL Server 2008 R2, SQL Server 2008 R2 Express, SQL Server 2012, SQL Server 2012 Express (including LocalDB), SQL Server 2014, SQL Server 2014 Express (including LocalDB), SQL Server 2016, SQL Server 2016 Express (including LocalDB)
MSSqlConnectionProvider System.Data.dll
MSSqlServerCE Microsoft SqlServer 2005 Mobile, SQL Server 2005 Compact Edition (Microsoft SqlServer 2005 Everywhere Edition CTP), SQL Server Compact 3.5,
SQL Server Compact 4.0
MSSqlCEConnectionProvider System.Data.SqlServerCe.dll 3.5.0
System.Data.SqlServerCe.dll 4.0.8482.1
MySql MySQL Server 4.1, MySQL Server 5.0, MySQL Server 5.1, MySQL Server 5.5 MySqlConnectionProvider MySql.Data.dll 6.6.4.0
Oracle Oracle 9i, Oracle 10g, Oracle 11g OracleConnectionProvider
ODPConnectionProvider
ODPManagedConnectionProvider
System.Data.OracleClient.dll 2.0.0.0
Oracle.DataAccess.dll 4.121.2.0
Oracle.ManagedDataAccess.dll 4.121.20
Pervasive Pervasive PSQL 9, Pervasive PSQL 10, Pervasive PSQL 11 PervasiveSqlConnectionProvider Pervasive.Data.SqlClient.dll 2.10.0.15
Pervasive.Data.SqlClient.dll 3.5.0.1811
Postgres PostgreSQL 7, PostgreSQL 8, PostgreSQL 9 PostgreSqlConnectionProvider Npgsql.dll 2.0.11.0
Npgsql.dll 3.0.2.0
SQLite SQLite 3 SQLiteConnectionProvider System.Data.SQLite.dll 1.0.88.0
VistaDB VistaDB 4, VistaDB 5 VistaDBConnectionProvider VistaDB.4.dll 4.0.0.0
VistaDB.5.NET40.dll 5.2.0.0

Note that the database provider assembly versions listed in the table above are the versions that have been tested with the current XPO version. Since XPO loads ADO.NET provider assemblies dynamically, you can use any specific version of the provider.

Note

XPO does not support tables with multi-column (compound) keys or indexes in ASE databases. To avoid exceptions when connecting to ASE databases containing these tables, use one-column keys or indexes.

 

Note

When implementing a server mode, binding a grid control to a file-based database (e.g., MS Access, VistaDB and SQLite) is not recommended. The performance of these databases is slow, and you will notice a significant reduction in transaction speed, data security and integrity when using them, compared to server-based database engines (e.g., Microsoft SQL Server and Oracle).

How would you rate this topic?​​​​​​​