c#和mysql之间的类型_数据库SQL SServer与C#中数据类型的对应关系

数据库

C#程序

int

int32

text

string

bigint

int64

binary

System.Byte[]

bit

Boolean

char

string

datetime

System.DateTime

decimal

System.Decimal

float

System.Double

image

System.Byte[]

money

System.Decimal

nchar

String

ntext

String

numeric

System.Decimal

nvarchar

String

real

System.Single

smalldatetime

System.DateTime

smallint

Int16

smallmoney

System.Decimal

timestamp

System.DateTime

tinyint

System.Byte

varbinary

System.Byte[]

varchar

String

Variant

Object

unique identifier

System.Guid

可以写写成一个方法进行转换

///

///数据库中与C#中的数据类型对照///

///

///

private string ChangeToCSharpType(string type)

{

string reval=string.Empty;

switch(type.ToLower())

{

case "int":

reval= "Int32";

break;

case "text":

reval= "String";

break;

case "bigint":

reval= "Int64";

break;

case "binary":

reval= "System.Byte[]";

break;

case "bit":

reval= "Boolean";

break;

case "char":

reval= "String";

break;

case "datetime":

reval= "System.DateTime";

break;

case "decimal":

reval= "System.Decimal";

break;

case "float":

reval= "System.Double";

break;

case "image":

reval= "System.Byte[]";

break;

case "money":

reval= "System.Decimal";

break;

case "nchar":

reval= "String";

break;

case "ntext":

reval= "String";

break;

case "numeric":

reval= "System.Decimal";

break;

case "nvarchar":

reval= "String";

break;

case "real":

reval= "System.Single";

break;

case "smalldatetime":

reval= "System.DateTime";

break;

case "smallint":

reval= "Int16";

break;

case "smallmoney":

reval= "System.Decimal";

break;

case "timestamp":

reval= "System.DateTime";

break;

case "tinyint":

reval= "System.Byte";

break;

case "uniqueidentifier":

reval= "System.Guid";

break;

case "varbinary":

reval= "System.Byte[]";

break;

case "varchar":

reval= "String";

break;

case "Variant":

reval="Object";

break;

default:

reval= "String";

break;

}

return reval;

}