SQL Database
- 2 minutes to read
DevExpress reports support the following SQL database systems:
Relational Database System | Supported Versions | .NET Framework Data Provider | .NET Standard 2.0 Data Provider |
---|---|---|---|
Microsoft SQL Server | 2005 or higher 2005 Express or higher Azure SQL Database |
System.Data.dll (Included in .NET Framework) | |
Microsoft Access | Access 2000 or higher Access 2007 or higher | System.Data.dll |
|
Microsoft SQL Server CE | 3.5, 4.0 | System.Data.SqlServerCe.dll (Included in .NET Framework) |
|
Oracle Database | 9i or higher |
System.Data.OracleClient.dll Oracle.DataAccess.dll | |
Amazon Redshift | n/a | ||
Google BigQuery | Only legacy SQL functions and operations are supported | ||
Teradata | 13.0 or higher | ||
SAP Sybase Advantage | Advantage Database Server 9.1 or higher |
| |
SAP Sybase ASE | Sybase Adaptive Server 12.0 or higher |
| |
SAP SQL Anywhere | 11 or higher |
| |
IBM DB2 | 9.5 or higher | IBM.Data.DB2.dll | |
Firebird | 1.5 or higher, Dialect 3 | FirebirdSql.Data.FirebirdClient.dll FirebirdSql.Data.Firebird.dll | |
MySQL | 4.1 or higher | ||
Pervasive PSQL | 9.x or higher | Pervasive.Data.SqlClient.dll |
|
PostgreSQL | 7.x or higher | ||
VistaDB | 4, 5 |
| |
SQLite | 3.x | ||
XML file | n/a | Built-in support | Built-in support |
Use the Report Wizard or the Data Source Wizard to bind a report to data at design time. See the following tutorials for details:
- Bind a Report to a Database
- Bind a Report to a Data Source Schema
- Bind a Report to a Stored Procedure
Use the SqlDataSource class to bind a report to an SQL database at runtime. See the following tutorials for code examples:
- Bind a Report to an MDB Database (Runtime Sample)
- Bind a Report to a Microsoft SQL Server Database (Runtime Sample)
- Register a Custom Schema Provider for a Synonym Database
Use query parameters to filter data on the database level or pass values to a stored procedure. See Specify Query Parameters for more information.
Tip
See Bind a Report to Standard .NET Data Providers to learn how to bind your report to an OLE DB provider or an existing DataSet object.