Ibatis.Net支持的数据类型

Table supported Types for Parameter Maps and Result Maps (.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
Nullable<bool>	Yes	Yes	bool?
Nullable<byte>	Yes	Yes	byte?
Nullable<char>	Yes	Yes	char?
Nullable<DateTime>	Yes	Yes	DateTime?
Nullable<decimal>	Yes	Yes	decimal?
Nullable<double>	Yes	Yes	double?
Nullable<Int16>	Yes	Yes	Int16?
Nullable<Int32>	Yes	Yes	Int32?
Nullable<Int64>	Yes	Yes	Int64?
Nullable<SByte>	Yes	Yes	SByte?
Nullable<Single>	Yes	Yes	Single?
Nullable<UInt16>	Yes	Yes	UInt16?
Nullable<UInt32>	Yes	Yes	UInt32?
Nullable<UInt64>	Yes	Yes	UInt64?

Table supported DbTypes for Parameter Maps and Result Maps (.NET)

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

转载于:https://www.cnblogs.com/jifsu/archive/2010/03/01/1675343.html