By reading spring.net's English documents, I sorted out the databases supported by spring (1.3). net. dao, hoping to provide a reference for anyone who wants to use spring.net. dao to operate the database.
SqlServer-1.1
-Microsoft SQL Server, provider V1.0.5000.0 in framework. NET V1.1
SqlServer-2.0
(Aliased
System.Data.SqlClient
)-Microsoft SQL Server, provider V2.0.0.0 in framework. NET V2.0
SqlServerCe-3.1
-Microsoft SQL Server Compact Edition, provider V9.0.242.0
SqlServerCe-3.5.1
(Aliased
System.Data.SqlServerCe
)-Microsoft SQL Server Compact Edition, provider V3.5.1.0
OleDb-1.1
-OleDb, provider V1.0.5000.0 in framework. NET V1.1
OleDb-2.0
(AliasedSystem.Data.OleDb
)-OleDb, provider V2.0.0.0 in framework. NET V2.0
OracleClient-2.0
(Aliased
System.Data.OracleClient
)-Oracle, Microsoft provider V2.0.0.0
OracleODP-2.0
(AliasedSystem.DataAccess.Client
)-Oracle, Oracle provider V2.102.2.20 (Oracle 10g)
OracleODP-11-2.0
-Oracle, Oracle provider V2.111.7.20 (Oracle 11g)
MySql
-MySQL, MySQL provider 1.0.10.1
MySql-1.0.9
-MySQL, MySQL provider 1.0.9
MySql-5.0
-MySQL, MySQL provider 5.0.7.0
MySql-5.0.8.1
-MySQL, MySQL provider 5.0.8.1
MySql-5.1
-MySQL, MySQL provider 5.1.2.2
MySql-5.1.4
-MySQL, MySQL provider 5.1.2.2
MySql-5.2.3
-MySQL, MySQL provider 5.2.3.0
MySql-6.1.3
(AliasedMySql.Data.MySqlClient
)-MySQL, MySQL provider 6.1.3.0
Npgsql-1.0
-PostgreSQL provider 1.0.0.0 (and 1.0.0.1-were build with same version info)
Npgsql-2.0-beta1
-PostgreSQL provider 1.98.1.0 Beta 1
Npgsql-2.0
-PostgreSQL provider 2.0.0.0
DB2-9.0.0-1.1
-IBM DB2 data provider 9.0.0 for. NET Framework
1.1
DB2-9.0.0-2.0
(AliasedIBM.Data.DB2
)-IBM DB2 data provider 9.0.0 for. NET Framework 2.0
DB2-9.1.0-1.1
-IBM DB2 data provider 9.1.0 for. NET Framework
1.1
DB2-9.1.0.2
(AliasedIBM.Data.DB2.9.1.0
)-IBM DB2 data provider 9.1.0 for. NET Framework 2.0
iDB2-10.0.0.0
-IBM iSeries DB2 Data Provider 10.0.0.0 for. NET Framework 2.0
SQLite-1.0.43
-SQLite provider 1.0.43 for. NET Framework 2.0
SQLite-1.0.44
-SQLite provider 1.0.44 for. NET Framework 2.0
SQLite-1.0.47
-SQLite provider 1.0.47 for. NET Framework 2.0
SQLite-1.0.56
-SQLite provider 1.0.56 for. NET Framework 2.0
SQLite-1.0.65
(Aliased to System. Data. SQLite)-SQLite provider 1.0.65 for. NET Framework 2.0
|
Note |
The default parameter prefix used in SQLite is: and not @, please write your SQL accordingly or define a provider definition for SQLite. |
Firebird-2.1
(AliasedFirebird-2.1
)-Firebird Server, provider V2.1.0.0 in framework. NET V2.0
SybaseAse-12
-Sybase ASE provider for ASE 12.x
SybaseAse-15
-Sybase ASE provider for ASE 15.x
SybaseAse-AdoNet2
-Sybase ADO. NET 2.0 provider for ASE 12.x and 15.x
Odbc-1.1
-ODBC provider V1.0.5000.0 in framework. NET V1.1
Odbc-2.0
-ODBC provider V2.0.0.0 in framework. NET V2
Cache-2.0.0.1
(AliasedInterSystems.Data.CacheClient
)-Cache provider Version 2.0.0.1 in