通过看spring.net 的英文文档,整理了spring(1.3 ).net.dao 支持的数据库 ,希望可以给想用spring.net.dao操作数据库的朋友提供一个参考资料
-
SqlServer-1.1
- Microsoft SQL Server, provider V1.0.5000.0 in framework .NET V1.1 -
SqlServer-2.0
(aliased toSystem.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 toSystem.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
(aliased toSystem.Data.OleDb
) - OleDb, provider V2.0.0.0 in framework .NET V2.0 -
OracleClient-2.0
(aliased toSystem.Data.OracleClient
) - Oracle, Microsoft provider V2.0.0.0 -
OracleODP-2.0
(aliased toSystem.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
(aliased toMySql.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 Framework1.1 -
DB2-9.0.0-2.0
(aliased toIBM.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 Framework1.1 -
DB2-9.1.0.2
(aliased toIBM.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.0Note 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
(aliased toFirebird-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
(aliased toInterSystems.Data.CacheClient
) - Cache provider Version 2.0.0.1 in