|
Oracle 类型 |
.NET Framework 类型 |
.NET Framework 类型化访问器 |
OracleType 类型化访问器 |
|---|---|---|---|
|
BFILE |
Byte[] |
GetBytes() |
GetOracleBFile() |
|
BLOB |
Byte[] |
GetBytes() |
GetOracleLob() |
|
CHAR |
String Char[] |
GetString() GetChars() |
GetOracleString() |
|
CLOB |
String Char[] |
GetString() GetChars() |
GetOracleLob() |
|
DATE |
DateTime |
GetDateTime() |
GetOracleDateTime() |
|
FLOAT |
Decimal |
GetDecimal() |
GetOracleNumber() ** |
|
INTEGER |
Decimal |
GetDecimal() |
GetOracleNumber() ** |
|
INTERVAL YEAR TO MONTH * |
Int32 |
GetInt32() |
GetOracleMonthSpan() |
|
INTERVAL DAY TO SECOND * |
TimeSpan |
GetTimeSpan() |
GetOracleTimeSpan() |
|
LONG |
String Char[] |
GetString() GetChars() |
GetOracleString() |
|
LONG RAW |
Byte[] |
GetBytes() |
GetOracleBinary() |
|
NCHAR |
String Char[] |
GetString() GetChars() |
GetOracleString() |
|
NCLOB |
String Char[] |
GetString() GetChars() |
GetOracleLob() |
|
NUMBER |
Decimal |
GetDecimal() |
GetOracleNumber() ** |
|
NVARCHAR2 |
String Char[] |
GetString() GetChars() |
GetOracleString() |
|
RAW |
Byte[] |
GetBytes() |
GetOracleBinary() |
|
REF CURSOR |
|||
|
ROWID |
String Char[] |
GetString() GetChars() |
GetOracleString() |
|
TIMESTAMP * |
DateTime |
GetDateTime() |
GetOracleDateTime() |
|
TIMESTAMP WITH LOCAL TIME ZONE * |
DateTime |
GetDateTime() |
GetOracleDateTime() |
|
TIMESTAMP WITH TIME ZONE * |
DateTime |
GetDateTime() |
GetOracleDateTime() |
|
UNSIGNED INTEGER |
Decimal |
GetDecimal() |
GetOracleNumber() ** |
|
VARCHAR2 |
String Char[] |
GetString() GetChars() |
GetOracleString |