Equivalencia de tipos entre SQL Server y .NET

Este post es simplemente un post-it para no tener que acceder millones de veces al documento en mi disco duro.

Net	Sql Server	SqlClient.SqlDbType	Data.DbType
Int64	bigint	BigInt	Int64
Byte[]	binary	Binary	Binary
Boolean	bit	Bit	Boolean
String	char	Char	AnsiStringFixedLength
DateTime	datetime	DateTime	DataTime
Decimal	decimal	Decimal	Decimal
Double	float	Float	Double
Byte[]	image	Image	Binary
Int32	int	Int	Int32
Decimal	money	Money	Currency
String	nchar	NChar	StringFixedLength
String	ntext	NText	String
Decimal	numeric	Decimal	Decimal
String	nvarchar	NVarChar	String
Single	real	Real	Single
DateTime	smalldatetime	SmallDateTime	DateTime
Int16	smallint	SmallInt	Int16
Decimal	smallmoney	SmallMoney	Currency
String	text	Text	AnsiString
Byte[]	timestamp	TimeStamp	Binary
Byte	tinyint	TinyInt	Byte
Guid	uniquedentifier	UniqueIdentifier	Guid
Byte[]	varbinary	VarBinary	Binary
String	varchar	VarChar	AnsiString

 

Un saludo!.