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

最新推荐文章于 2021-11-09 22:07:22 发布

清山博客

最新推荐文章于 2021-11-09 22:07:22 发布

阅读量1.7k

点赞数

分类专栏：源代码文章标签： c# sql string byte object float

本文链接：https://blog.csdn.net/a497785609/article/details/4958047

版权

源代码专栏收录该内容

55 篇文章 1 订阅

订阅专栏

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;
      }