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

最新推荐文章于 2023-08-22 02:45:25 发布

原创最新推荐文章于 2023-08-22 02:45:25 发布 · 797 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#sql server #c# #string #object #image #数据库

MSSQL 专栏收录该内容

5 篇文章

订阅专栏

博客展示了一个将数据库数据类型转换为C#数据类型的函数。通过`switch`语句，针对不同的数据库数据类型，如`int`、`text`、`image`等，返回对应的C#数据类型，如`Int32`、`String`、`System.Byte[]`等。

?///

??/// 数据库中与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;
??}