文章作者：激萌の小宅

促销：￥0

价格：￥0

配送方式：购买后立即生效（如购买异常，请联系站长）

付款之后一定要等待自动跳转结束，否则购买可能会失败

0 天

有效期
0

总销量
0

累计评价

详细说明

<h1>MySql与C#数据关系对应表 - <span class="color_h1">(对应表)</span></h1><p><br/></p><table class="w_table" style="table-layout: fixed;" width="40%" border="1"><thead><tr style="height:35px" align="center" class="firstRow"><th style="width: 50%; border-width: 2px 1px 1px; border-style: solid; border-color: windowtext;">MySql</th><th style="border-width: 2px 1px 1px; border-style: solid; border-color: windowtext;">C#</th></tr></thead><tbody><tr style="height:35px"><td style="white-space: normal; border-width: 1px; border-style: solid;">bigint</td><td style="white-space: normal; border-width: 1px; border-style: solid;">long</td></tr><tr style="height:35px"><td style="white-space: normal; border-width: 1px; border-style: solid;">int</td><td style="white-space: normal; border-width: 1px; border-style: solid;">int</td></tr><tr style="height:35px"><td style="white-space: normal; border-width: 1px; border-style: solid;">bigint</td><td style="white-space: normal; border-width: 1px; border-style: solid;">long</td></tr><tr style="height:35px"><td style="white-space: normal; border-width: 1px; border-style: solid;">int</td><td style="white-space: normal; border-width: 1px; border-style: solid;">int</td></tr><tr style="height:35px"><td style="white-space: normal; border-width: 1px; border-style: solid;">smallint</td><td style="white-space: normal; border-width: 1px; border-style: solid;">short</td></tr><tr style="height:35px"><td style="white-space: normal; border-width: 1px; border-style: solid;">guid</td><td style="white-space: normal; border-width: 1px; border-style: solid;">Guid</td></tr><tr style="height:35px"><td style="white-space: normal; border-width: 1px; border-style: solid;">smalldatetime</td><td style="white-space: normal; border-width: 1px; border-style: solid;">DateTime</td></tr><tr style="height:35px"><td style="white-space: normal; border-width: 1px; border-style: solid;">date</td><td style="white-space: normal; border-width: 1px; border-style: solid;">DateTime</td></tr><tr style="height:35px"><td style="white-space: normal; border-width: 1px; border-style: solid;">datetime</td><td style="white-space: normal; border-width: 1px; border-style: solid;">DateTime</td></tr><tr style="height:35px"><td style="white-space: normal; border-width: 1px; border-style: solid;">timestamp</td><td style="white-space: normal; border-width: 1px; border-style: solid;">DateTime</td></tr><tr style="height:35px"><td style="white-space: normal; border-width: 1px; border-style: solid;">float</td><td style="white-space: normal; border-width: 1px; border-style: solid;">float</td></tr><tr style="height:35px"><td style="white-space: normal; border-width: 1px; border-style: solid;">double</td><td style="white-space: normal; border-width: 1px; border-style: solid;">double</td></tr><tr style="height:35px"><td style="white-space: normal; border-width: 1px; border-style: solid;">numeric</td><td style="white-space: normal; border-width: 1px; border-style: solid;">Decimal</td></tr><tr style="height:35px"><td style="white-space: normal; border-width: 1px; border-style: solid;">smallmoney</td><td style="white-space: normal; border-width: 1px; border-style: solid;">Decimal</td></tr><tr style="height:35px"><td style="white-space: normal; border-width: 1px; border-style: solid;">decimal</td><td style="white-space: normal; border-width: 1px; border-style: solid;">Decimal</td></tr><tr style="height:35px"><td style="white-space: normal; border-width: 1px; border-style: solid;">money</td><td style="white-space: normal; border-width: 1px; border-style: solid;">Decimal</td></tr><tr style="height:35px"><td style="white-space: normal; border-width: 1px; border-style: solid;">bit</td><td style="white-space: normal; border-width: 1px; border-style: solid;">bool</td></tr><tr style="height:35px"><td style="white-space: normal; border-width: 1px; border-style: solid;">bool</td><td style="white-space: normal; border-width: 1px; border-style: solid;">bool</td></tr><tr style="height:35px"><td style="white-space: normal; border-width: 1px; border-style: solid;">boolean</td><td style="white-space: normal; border-width: 1px; border-style: solid;">bool</td></tr><tr style="height:35px"><td style="white-space: normal; border-width: 1px; border-style: solid;">tinyint</td><td style="white-space: normal; border-width: 1px; border-style: solid;">Byte</td></tr><tr style="height:35px"><td style="white-space: normal; border-width: 1px; border-style: solid;">image</td><td style="white-space: normal; border-width: 1px; border-style: solid;">Byte[]</td></tr><tr style="height:35px"><td style="white-space: normal; border-width: 1px; border-style: solid;">binary</td><td style="white-space: normal; border-width: 1px; border-style: solid;">Byte[]</td></tr><tr style="height:35px"><td style="white-space: normal; border-width: 1px; border-style: solid;">blob</td><td style="white-space: normal; border-width: 1px; border-style: solid;">Byte[]</td></tr><tr style="height:35px"><td style="white-space: normal; border-width: 1px; border-style: solid;">mediumblob</td><td style="white-space: normal; border-width: 1px; border-style: solid;">Byte[]</td></tr><tr style="height:35px"><td style="white-space: normal; border-width: 1px; border-style: solid;">longblob</td><td style="white-space: normal; border-width: 1px; border-style: solid;">Byte[]</td></tr><tr style="height:35px"><td style="white-space: normal; border-width: 1px; border-style: solid;">varbinary</td><td style="white-space: normal; border-width: 1px; border-style: solid;">Byte[]</td></tr><tr style="height:35px"><td style="white-space: normal; border-width: 1px; border-style: solid;">text</td><td style="white-space: normal; border-width: 1px; border-style: solid;">string</td></tr><tr style="height:35px"><td style="white-space: normal; border-width: 1px; border-style: solid;">char</td><td style="white-space: normal; border-width: 1px; border-style: solid;">string</td></tr><tr style="height:35px"><td style="white-space: normal; border-width: 1px; border-style: solid;">nchar</td><td style="white-space: normal; border-width: 1px; border-style: solid;">String</td></tr><tr style="height:35px"><td style="white-space: normal; border-width: 1px; border-style: solid;">ntext</td><td style="white-space: normal; border-width: 1px; border-style: solid;">String</td></tr><tr style="height:35px"><td style="white-space: normal; border-width: 1px; border-style: solid;">nvarchar</td><td style="white-space: normal; border-width: 1px; border-style: solid;">String</td></tr><tr style="height:35px"><td style="white-space: normal; border-width: 1px; border-style: solid;">real</td><td style="white-space: normal; border-width: 1px; border-style: solid;">Single</td></tr><tr style="height:35px"><td style="white-space: normal; border-width: 1px; border-style: solid;">uniqueidentifier</td><td style="white-space: normal; border-width: 1px; border-style: solid;">Guid</td></tr><tr style="height:35px"><td style="white-space: normal; border-width: 1px; border-style: solid;">varbinary</td><td style="white-space: normal; border-width: 1px; border-style: solid;">Byte[]</td></tr><tr style="height:35px"><td style="white-space: normal; border-width: 1px; border-style: solid;">varchar</td><td style="white-space: normal; border-width: 1px; border-style: solid;">String</td></tr><tr style="height:35px"><td style="white-space: normal; border-width: 1px; border-style: solid;">Variant</td><td style="white-space: normal; border-width: 1px; border-style: solid;">Object</td></tr></tbody></table>

MySql与C#数据关系对应表 - (对应表)

MySql	C#
bigint	long
int	int
bigint	long
int	int
smallint	short
guid	Guid
smalldatetime	DateTime
date	DateTime
datetime	DateTime
timestamp	DateTime
float	float
double	double
numeric	Decimal
smallmoney	Decimal
decimal	Decimal
money	Decimal
bit	bool
bool	bool
boolean	bool
tinyint	Byte
image	Byte[]
binary	Byte[]
blob	Byte[]
mediumblob	Byte[]
longblob	Byte[]
varbinary	Byte[]
text	string
char	string
nchar	String
ntext	String
nvarchar	String
real	Single
uniqueidentifier	Guid
varbinary	Byte[]
varchar	String
Variant	Object