General Information
WinForms Controls
	Prerequisites
	What's Installed
	Build an Application
	Controls and Libraries
		Forms and User Controls
		Messages, Notifications, and Dialogs
		Editors and Simple Controls
		Ribbon, Bars and Menu
		Application UI Manager
		Docking Library
		Data Grid
			Get Started With Data Grid and Views
			Data Binding
				Large Data Sources: Server and Instant Feedback Modes
					Data Stores Supported in Server Mode When Using XPO
					Server Mode: Binding to a Data Source Using eXpress Persistent Objects
					Entity Framework 4.0+ Server Mode Specifics
				Post Data to an Underlying Data Source
			Unbound Columns
			Views
			Data Editing and Validation
			Grouping
			Sorting
			Filter and Search
			Summaries
			Focus and Selection Handling
			Format Cell Values
			Master-Detail Relationships
			Asynchronous Image Load
			Export and Printing
			Appearance and Conditional Formatting
			Split Presentation
			Row Preview Sections
			Scrolling
			Batch Modifications
			Hit Information
			Hints
			Popup Menus
			Save and Restore Layout
			Visual Elements
			Design-Time Features
			Examples
			End-User Capabilities
			Included Components
		Vertical Grid
		Property Grid
		Pivot Grid
		Tree List
		Chart Control
		Diagrams
		Gauges
		Map Control
		Scheduler
		Spreadsheet
		Rich Text Editor
		Spell Checker
		Form Layout Managers
		Navigation Controls
		Printing-Exporting
		PDF Viewer
		Reporting
		Snap
		TreeMap Control
		Sunburst Control
	Common Features
	Get More Help
	API Reference
ASP.NET Controls and MVC Extensions
ASP.NET Bootstrap Controls
ASP.NET Core Bootstrap Controls
WPF Controls
Xamarin Controls
Windows 10 App Controls
Office File API
Reporting
Report and Dashboard Server
Dashboard
eXpressApp Framework
eXpress Persistent Objects
CodeRush
CodeRush Classic
Cross-Platform Core Libraries
Tools and Utilities
End-User Documentation

WinForms Controls > Controls and Libraries > Data Grid > Data Binding > Large Data Sources: Server and Instant Feedback Modes > Data Stores Supported in Server Mode When Using XPO

View this topic on docs.devexpress.com (Learn more)

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 IBM.Data.DB2.Core.dll 1.2.2.100 (.NET Standard 2.0)
Firebird	Firebird 1.5, Firebird 2.5.7, Firebird 3.0.2	FirebirdConnectionProvider	FirebirdSql.Data.Firebird.dll 2.5.1.0 FirebirdSql.Data.FirebirdClient.dll 5.12.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), SQL Server 2017	MSSqlConnectionProvider	System.Data.dll System.Data.SqlClient 4.4.0 (.NET Standard 2.0)
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.7, MySQL Server 8.0.12	MySqlConnectionProvider	MySql.Data.dll 8.0.12.0 (.NET Standard 2.0)
Oracle	Oracle 9i, Oracle 10g, Oracle 11g, Oracle 12c	OracleConnectionProvider ODPConnectionProvider ODPManagedConnectionProvider	System.Data.OracleClient.dll 2.0.0.0 Oracle.DataAccess.dll 4.122.1.0 Oracle.ManagedDataAccess.dll 4.122.1.0 Oracle.ManagedDataAccess.Core.dll 2.18.3 (.NET Standard 2.0)
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
PostgreSQL	PostgreSQL 7, PostgreSQL 8, PostgreSQL 9, PostgreSQL 10, PostgreSQL 11	PostgreSqlConnectionProvider	Npgsql.dll 2.0.11.0 Npgsql.dll 3.2.5.0 Npgsql.dll 3.2.5.0 (.NET Standard 2.0) Npgsql.dll 4.0.3.0 Npgsql.dll 4.0.3.0 (.NET Standard 2.0)
SQLite	SQLite 3	SQLiteConnectionProvider	System.Data.SQLite.dll 1.0.88.0 Microsoft.Data.SQLite 2.0.0 (.NET Standard 2.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).

Is this topic helpful?