2023年7月13日发(作者：)

SQL SERVER与C#中数据类型的对应关系

///

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

///

///

///

private string ChangeToCSharpType(string type)

{

string reval=;

switch(r())

{

case "int":

reval= "Int32";

break;

case "text":

reval= "String";

break;

case "bigint":

reval= "Int64";

break;

case "binary":

reval= "[]";

break;

case "bit":

reval= "Boolean";

break;

case "char":

reval= "String";

break;

case "datetime":

reval= "me";

break;

case "decimal":

reval= "l";

break;

case "float":

reval= "";

break;

case "image":

reval= "[]";

break;

case "money": reval= "l";

break;

case "nchar":

reval= "String";

break;

case "ntext":

reval= "String";

break;

case "numeric":

reval= "l";

break;

case "nvarchar":

reval= "String";

break;

case "real":

reval= "";

break;

case "smalldatetime":

reval= "me";

break;

case "smallint":

reval= "Int16";

break;

case "smallmoney":

reval= "l";

break;

case "timestamp":

reval= "me";

break;

case "tinyint":

reval= "";

break;

case "uniqueidentifier":

reval= "";

break;

case "varbinary":

reval= "[]";

break;

case "varchar":

reval= "String";

break;

case "Variant":

reval="Object";

break; default:

reval= "String";

break;

}

return reval;

}