mybatis.net 자료형

CLR Type	Object/Map Property Mapping	Result Class/Parameter Class**	Type Alias**
System.ArrayList	Yes	Yes	list
System.Boolean	Yes	Yes	Boolean, bool
System.Byte	Yes	Yes	Byte, byte
System.Char	Yes	Yes	Char, char
System.DateTime	Yes	Yes	dateTime, date
System.Decimal	Yes	Yes	Decimal, decimal
System.Double	Yes	Yes	Double, double
System.Guid	Yes	Yes	guid
System.Hashtable	Yes	Yes	map, hashmap, hashtable
System.Int16	Yes	Yes	Int16, short, Short
System.Int32	Yes	Yes	Int32, int, Int, integer, Integer
System.Int64	Yes	Yes	Int64, long, Long
System.SByte	Yes	Yes	SByte, sbyte
System.Single	Yes	Yes	Float, float, Single, single
System.String	Yes	Yes	String, string
System.TimeSpan	Yes	Yes	N/A
System.UInt16	Yes	Yes	Short, short
System.UInt32	Yes	Yes	Uint, uint
System.UInt64	Yes	Yes	Ulong, ulong

CLR Type	iBatis support	SqlDbType	OleDbType	OdbcType	OracleType
Byte[]	Yes	Binary, Image, VarBinary	Binary, VarBinary	Binary, Image, VarBinary	Raw
Boolean	Yes	Bit	Boolean	Bit	Byte
Byte	–	TinyInt	–	TinyInt	Byte
DateTime	Yes	DateTime, SmallDateTime	Date	Date, DateTime, SmallDateTime, Time	DateTime
char	Yes	Not supported	Char	Char	Byte
Decimal	Yes	Decimal, Money, SmallMoney	Decimal, Currency, Numeric	Decimal, Numeric	Number
Double	Yes	Float	Double	Double	Double
Guid	Yes	UniqueIdentifier	Guid	UniqueIdentifier	Raw
Int16	Yes	SmallInt	SmallIInt	SmallInt	Int16
Int32	Yes	Int	Integer	Int	Int32
Int64	Yes	BigInt	BigInt	BigInt	Number
Single	Yes	Real	Single	Real	Float
String	Yes	Char, Nchar, NVarchar, Text, VarChar	Char, VarChar	Char, NChar, NText, NVarChar, Text, VarChar	NVarChar
TimeSpan	No	Not supported	DBTime	Time	DateTime
UInt16	yes	Int	–	–	UInt16
UInt32	yes	Decimal	–	–	UInt32
UInt64	yes	Decimal	–	–	Number

anydragon