SQL Serve和C# 数据类型之间的转换

最新推荐文章于 2024-04-29 17:34:03 发布

zzg16888

最新推荐文章于 2024-04-29 17:34:03 发布

阅读量70

点赞数

本文介绍了一个实用的方法，用于将数据库中的各种字段类型映射到C#语言中的相应类型。通过一个C#函数实现了从数据库字段类型到C#类型的转换，包括整型、字符串、日期时间等多种常见类型。

public string ChangeDBTypeToCSharpType(string type)
{
string reval=string.Empty;
switch(type.ToLower())
{
case "int":
reval= "int";
break;
case "text":
reval= "string";
break;
case "bigint":
reval= "long";
break;
case "binary":
reval= "object";
break;
case "bit":
reval= "bool";
break;
case "char":
reval= "string";
break;
case "datetime":
reval= "DateTime";
break;
case "decimal":
reval= "decimal";
break;
case "float":
reval= "double";
break;
case "image":
reval= "byte[]";
break;
case "money":
reval= "decimal";
break;
case "nchar":
reval= "string";
break;
case "ntext":
reval= "string";
break;
case "numeric":
reval= "decimal";
break;
case "nvarchar":
reval= "string";
break;
case "real":
reval= "float";
break;
case "smalldatetime":
reval= "DateTime";
break;
case "smallint":
reval= "short";
break;
case "smallmoney":
reval= "decimal";
break;
case "timestamp":
reval= "System.DateTime";
break;
case "tinyint":
reval= "byte[]";
break;
case "uniqueidentifier":
reval= "Guid";
break;
case "varbinary":
reval= "byte[]";
break;
case "varchar":
reval= "string";
break;
case "Variant":
reval="object";
break;
default:
reval= "string";
break;
}
return reval;
}