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

最新推荐文章于 2023-06-06 20:27:05 发布

Dcboy

最新推荐文章于 2023-06-06 20:27:05 发布

阅读量773

点赞数

分类专栏： MSSQL 文章标签： sql server c# string object image 数据库

本文链接：https://blog.csdn.net/dcboy/article/details/95837

版权

MSSQL 专栏收录该内容

5 篇文章

订阅专栏

?///

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