Every once in a while I want to know how the CLR datatypes map up to the SQL Server data types and I can never remember the link.  Well, here it is.

http://msdn.microsoft.com/en-us/library/ms131092.aspx

Here's a quick chart.

SQL Server data type	CLR data type (SQL Server)	CLR data type (.NET Framework)
binary	SqlBytes, SqlBinary	Byte[]
bit	SqlBoolean	Boolean, Nullable
char	None	None
date	SqlDateTime	DateTime, Nullable
datetime	SqlDateTime	DateTime, Nullable
decimal	SqlDecimal	Decimal, Nullable
float	SqlDouble	Double, Nullable
int	SqlInt32	Int32, Nullable
money	SqlMoney	Decimal, Nullable
nchar	SqlChars, SqlString	String, Char[]
ntext	None	None
numeric	SqlDecimal	Decimal, Nullable
nvarchar	SqlChars, SqlString SQLChars is a better match for data transfer and access, and SQLString is a better match for performing String operations.	String, Char[]
text	None	None
time	TimeSpan	TimeSpan, Nullable
timestamp	None	None
tinyint	SqlByte	Byte, Nullable
uniqueidentifier	SqlGuid	Guid, Nullable
User-defined type(UDT)	None	The same class that is bound to the user-defined type in the same assembly or a dependent assembly.
varchar	None	None
xml	SqlXml	None

Trackback Print

Tags:

Categories:

Location: Blogs TechTidBits

Your name:
Your email:
	(Optional) Email used only to show Gravatar.
Your website:
Title:
Comment:
Add Comment   Cancel