SQL、CodeSmith、C#数据类型对照

本表格只针对SQL中常用数据类型转换成CodeSmith与C#的对照表，并非官网提供

分类	Sql Server	CodeSmith	C#类型	C#简写	SQL精度与范围
整数	bit	Boolean	System.Boolean	bool	0,1
	tinyint	Byte	System.Byte	byte	0 - 255
	smallint	Int16	System.Int16	short	-32768 ~ +32767
	int	Int32	System.Int32	int	-2147483648 ~ +2147483647
	bigint	Int64	System.Int64	long	-9223372036854775808 ~ +9223372036854775807
小数	decimal	Decimal	System.Decimal	decimal	-79228162514264337593543950335M ~ +79228162514264337593543950335M
	real	Single	System.Single	float	-3.40282347E+38F ~ +3.40282347E+38F
	float	Double	System.Double	double	-1.7976931348623157E+308 ~ +1.7976931348623157E+308
日期、时间	date	DateTime	System.DateTime	DateTime	0001-01-01 ~ 9999-12-31
	time	DateTime	System.DateTime	DateTime	00:00:00.0000000 ~ 23:59:59.9999999
	datetime	DateTime	System.DateTime	DateTime	精确到3位毫秒
	datetime2	DateTime	System.DateTime	DateTime	date类型+time类型
字符串	char	String	System.String	string
	varchar	String	System.String	string
	text	String	System.String	string
	nchar	String	System.String	string
	nvarchar	String	System.String	string
	ntext	String	System.String	string
节点	hierarchyid	String	System.String	string