SQL SERVER DATATYPES and .NET Framework Datatypes mapping

SQL SERVER DATATYPES and .NET Framework Datatypes mapping

datetime

SQL SERVER DATA TYPES	.NET CLR DATATYPES
bigint	int64
int	int32
smallint	int16
tinyint	byte
decimal	SqlDecimal
numeric	SqlDecimal
float	double
real	short
smallmoney	decimal
money	decimal
date	datetime
datetime	datetime
time	timespan
smalldatetime	datetime
datetime2	datetime
datetimeoffset	datetimeoffset

tags: SQL DATA TYPES mapping in .NET Data types,SQL Data types  equivalent in C#,SQL Data types  equivalent in Vb.net, SQL Data types and .net data types mapping.