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

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

数据库 int text bigint binary bit char datetime decimal float image money nchar ntext numeric nvarchar real smalldatetime

C#程序

int32 string int64 System.Byte[] Boolean string System.DateTime System.Decimal System.Double System.Byte[] System.Decimal String String System.Decimal String System.Single System.DateTime

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

/// <summary>

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

/// </summary>

/// <param name="type"></param>

/// <returns></returns>

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":

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":

break;

case "Variant": reval="Object";

break; default:

reval= "String";

break; }

return reval;

}