DbTypes x SqlServer

DbType x SqlServer

DbType	Precision	SqlServer Type
AnsiString	default	char(255)
AnsiStringFixedLength	1, 255	char(n)
AnsiStringFixedLength	256, 65535	text
AnsiStringFixedLength	65536, 16777215	mediumtext
AnsiString	default	char(255)
AnsiString	1, 255	char(n)
AnsiString	256, 65535	text
AnsiString	65536, 16777215	mediumtext
Binary		binary
Boolean		bit
Byte		tinyint unsigned
Currency		money
Date		datetime
DateTime		datetime
Decimal	default	numeric(19,5)
Decimal	n	numeric(19,n)
Double		float
Guid		uniqueidentifier
Int16		smallint
Int32		integer
Int64		bigint
Single		float
StringFixedLength	default	nchar(255)
StringFixedLength	1, 8000	nchar(n)
StringFixedLength	> 8000	text
String	default	nvarchar(255)
String	1, 8000	nvarchar(n)
String	> 8000	text
Time		time