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. Review the following help topics 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. Review the following help topics for code examples:
- Bind a Report to an MDB Database (Runtime Sample)
- Bind a Report to a Microsoft SQL Server Database at Runtime
- Register a Custom Schema Provider for a Synonym Database
Use query parameters to filter data or pass values to a stored procedure. Review the following help topic for more information: Specify Query Parameters.
Note
Use the Rebuild Result Schema command or call the SqlDataSource.RebuildResultSchema method on any changes in the connection, queries, or database structure. The RebuildResultSchema method applies changes to the data source, and refreshes fields available for report bindings and fields displayed in the field list.