The java.sql Package

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

..................Content has been hidden....................

You can't read the all page of ebook, please click here login for view all page.
Reset