The corresponding relationship between the Dal and the database type

MSSQL Server Type	DbType type	C # types		MySQL type	DbType type	C # types
bit	boolean	bool	 	bit (1)	boolean	bool
tinyint	byte	byte	 	bit	uint64	ulong
smallint	int16	short	 	tinyint (1)	boolean	bool
int	int32	int	 	tinyint	byte	byte
bigint	int64	long	 	smallint	short	short
real	single	float	 	int	int32	int
float	double	double	 	bigint	int64	long
money	decimal	decimal	 	decimal	currency	decimal
numeric	decimal	decimal	 	double	double	double
decimal	currency	decimal	 	float	single	float
smallmoney	currency	decimal	 	char (1)	ansistringfixedlength	char
date	date	datetime	 	char	ansistringfixedlength	string
time	time	timespan	 	varchar	ansistring	string
datetime	datetime	datetime	 	date	datetime	datetime
smalldatetime	datetime	datetime	 	datetime	datetime	datetime
datetime2	datetime	datetime	 	time	time	timespan
datetimeoffset	datetimeoffset	datetime	 	timestamp	datetime	datetime
timestamp	binary	byte[]	 	year	int16	short
char (1)	ansistringfixedlength	char	 	binary	binary	byte["
char	ansistringfixedlength	string	 	text	string	string
varchar	ansistring	string	 		 
nchar	stringfixedlength	char	 		 
nvarchar	string	string	 		 
text	string	string	 		 
ntext	string	string	 		 
image	binary	byte[]	 		 
binary	binary	byte[]	 		 
uniqueidentifier	guid	guid	 		 
image	binary	byte[]	 		 
sql_variant	object	object	 		 
Xml	Xml	String

The corresponding relationship between the Dal and the database type