SQL corresponds to C # types

Serial Number	category	SQL Server	C Sharp	Notes
1	integer	bit	Boolean	true to convert to 1False to 0
2		tinyint	Byte	C Sharp data types are located in the System namespace
3		smallint	Int16
4		int	Int32
5		bigint	Int64
6		smallmoney	Decimal
7		Money	Decimal
8		Numeric	Decimal
9		decimal	Decimal
Ten	floating point number	float	Double
One		Real	Single
A	Date and Time	smalldatetime	DateTime
-		datetime	DateTime
-		timestamp	DateTime
the	string	Char	String
-		text	String
-		varchar	String
-		nchar	String
+		ntext	String
-		nvarchar	String
+	Binary Data	binary	byte[]
A		varbinary	byte[]
at		Image	byte[]
-	other	uniqueidentifier	Guid
-		Variant	Object