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 |