The mapping between the Java java.sql package and the corresponding .NET types is provided in Table F-10. See Chapter 16, for details of these .NET types.
Table F-10. The Java to .NET Mapping for the java.sql Package
Java | .NET |
---|---|
Interfaces | |
Array | N/A |
Blob | Blob objects are read through a DataReader; see the following types: System.Data.IDbDataReader System.Data.SqlClient.SqlDataReader System.Data.OleDb.OleDbDataReader |
CallableStatement | System.Data.IDbCommand System.Data.SqlClient.SqlCommand System.Data.OleDb.OleDbCommand |
Clob | Clob objects are read through a DataReader; see the following types: System.Data.IDbDataReader System.Data.SqlClient.SqlDataReader System.Data.OleDb.OleDbDataReader |
Connection | System.Data.IDb System.Data.SqlClient.Sql System.Data.OleDb.OleDb |
DatabaseMetaData | N/A |
Driver | N/A |
ParameterMetaData | System.Data.IDataParameter System.Data.IDbDataParameter System.Data.IDataParameterCollection System.Data.SqlClient.SqlParameter System.Data.SqlClient.SqlParameterCollection System.Data.OleDb.OleDbParameter System.Data.OleDb.OleDbParameterCollection |
PreparedStatement | System.Data.IDbCommand System.Data.SqlClient.SqlCommand System.Data.OleDb.OleDbCommand |
Ref | N/A |
ResultSet | System.Data.IDbDataReader System.Data.SqlClient.SqlDataReader System.Data.OleDb.OleDbDataReader System.Data.DataSet |
ResultSetMetaData | System.Data.IDbDataReader System.Data.SqlClient.SqlDataReader System.Data.OleDb.OleDbDataReader System.Data.DataSet |
Savepoint | System.Data.SqlClient.SqlTransaction |
SQLData | N/A |
SQLInput | N/A |
SQLOutput | N/A |
Statement | System.Data.IDbCommand System.Data.SqlClient.SqlCommand System.Data.OleDb.OleDbCommand |
Struct | N/A |
Classes | |
Date | System.Data.SqlTypes.SqlDateTime |
DriverManager | N/A |
DriverPropertyInfo | N/A |
SQLPermission | System.Data.Common.DBDataPermission System.Data.Common.DBDataPermissionAttribute System.Data.SqlClient.SqlClientPermission System.Data.SqlClient.SqlClientPermissionAttribute System.Data.OleDb.OleDbPermission System.Data.OleDb.OleDbPermissionAttribute |
Time | System.Data.SqlTypes.SqlDateTime |
TimeStamp | N/A |
Types | System.Data.DbTypes |