Oracle与.NET数据类型对照

 https://docs.oracle.com/en/database/oracle/oracle-data-access-components/19.3/odpnt/ODPEFCore.html#GUID-80B07B35-46C9-408F-A688-F98CE1A4CD6C

 

 

ORACLE类映射.NET

Oracle 数据库数据类型	.NET 类型别名	.NET 数据类型
NUMBER(1)	bool	System.Boolean
NUMBER(2)自NUMBER(4)	byte	System.Byte
NUMBER(5)	short/int16	System.Int16
NUMBER(6)自NUMBER(10)	int/int32	System.Int32
NUMBER(11)自NUMBER(19)	long/int64	System.Int64
NUMBER(>19)	decimal	System.Decimal
NUMBER(p,s)	decimal	System.Decimal
NUMBER	decimal	System.Decimal
BINARY_FLOAT	float	System.Float
BINARY_DOUBLE	double	System.Double
TIMESTAMP	DateTime	System.DateTime
DATE	Date	System.Date
INTERVAL DAY TO SECOND	TimeSpan	System.TimeSpan
INTERVAL YEAR TO MONTH	string	System.String
VARCHAR2	string	System.String
NVARCHAR2	string	System.String
CHAR	string	System.String
NCHAR	string	System.String
CLOB	string	System.String
NCLOB	string	System.String
RAW	byte[]	System.Byte[]
BLOB	byte[]	System.Byte[]
XMLTYPE	string	System.String
ROWID	string	System.String
UROWID	string	System.String
LONG	string	System.String
BFILE	byte[]	System.Byte[]
LONG RAW	byte[]	System.Byte[]