.Net 資料庫型態轉換

2014-06-11

1338
0
C#

.Net 資料庫型態轉換

.NetType	DbType	SqlDbType	OracleDbType
String	AnsiString	VarChar	Varchar2
Object	Binary	VarBinary	Raw
Byte	Byte	TinyInt	Byte
Boolean	Boolean	Bit	Boolean
Decimal	Currency	Money
DateTime	Date	DateTime	Date
DateTime	DateTime	DateTime	TimeStamp
Decimal	Decimal	Decimal	Decimal
Double	Double	Float	Double
Object	Guid	UniqueIdentifier
Int16	Int16	SmallInt	Int16
Int32	Int32	Int	Int32
Int64	Int64	BigInt	Int64
Object	Object	Variant	Object
SByte	SByte
Single	Single	Real	Single
String	String	NVarChar	Varchar2
DateTime	Time	DateTime	TimeStamp
UInt16	UInt16
UInt32	UInt32
UInt64	UInt64
Decimal	VarNumeric
String	AnsiStringFixedLength	Char	Char
String	StringFixedLength	NChar	Char
Object	Xml	Xml
DateTime	DateTime2	DateTime2
Object	DateTimeOffset	DateTimeOffset
Int64	Int64	BigInt	Int64
Object	Binary	Binary	Raw
Boolean	Boolean	Bit	Boolean
String	AnsiStringFixedLength	Char	Char
DateTime	DateTime	DateTime	TimeStamp
Decimal	Decimal	Decimal	Decimal
Double	Double	Float	Double
Object	Binary	Image	Raw
Int32	Int32	Int	Int32
Decimal	Currency	Money
String	StringFixedLength	NChar	Char
String	String	NText	Varchar2
String	String	NVarChar	Varchar2
Single	Single	Real	Single
Object	Guid	UniqueIdentifier
DateTime	DateTime	SmallDateTime	TimeStamp
Int16	Int16	SmallInt	Int16
Decimal	Currency	SmallMoney
String	AnsiString	Text	Varchar2
Object	Binary	Timestamp	Raw
Byte	Byte	TinyInt	Byte
Object	Binary	VarBinary	Raw
String	AnsiString	VarChar	Varchar2
Object	Object	Variant	Object
Object	Xml	Xml
Object	Object	Udt	Object
Object	Object	Structured	Object
DateTime	Date	Date	Date
DateTime	Time	Time	TimeStamp
DateTime	DateTime2	DateTime2
Object	DateTimeOffset	DateTimeOffset
Object	Object	Variant	BFile
Object	Object	Variant	Blob
Byte	Byte	TinyInt	Byte
String	StringFixedLength	NChar	Char
Object	Object	Variant	Clob
DateTime	Date	DateTime	Date
Decimal	Decimal	Decimal	Decimal
Double	Double	Float	Double
String	String	NVarChar	Long
Object	Binary	VarBinary	LongRaw
Int16	Int16	SmallInt	Int16
Int32	Int32	Int	Int32
Int64	Int64	BigInt	Int64
Object	Object	Variant	IntervalDS
Int64	Int64	BigInt	IntervalYM
Object	Object	Variant	NClob
String	StringFixedLength	NChar	NChar
String	String	NVarChar	NVarchar2
Object	Binary	VarBinary	Raw
Object	Object	Variant	RefCursor
Single	Single	Real	Single
DateTime	DateTime	DateTime	TimeStamp
DateTime	DateTime	DateTime	TimeStampLTZ
DateTime	DateTime	DateTime	TimeStampTZ
String	String	NVarChar	Varchar2
String	String	NVarChar	XmlType
Object	Object	Variant	Array
Object	Object	Variant	Object
Object	Object	Variant	Ref
Double	Double	Float	BinaryDouble
Single	Single	Real	BinaryFloat
Boolean	Boolean	Bit	Boolean

回首頁