MSSQL与C#中的数据类型对应表

最新推荐文章于 2024-08-07 02:15:59 发布

yw1688

最新推荐文章于 2024-08-07 02:15:59 发布

阅读量1.3k

点赞数

分类专栏： SQL C#

C# 同时被 2 个专栏收录

269 篇文章 1 订阅

订阅专栏

SQL

30 篇文章 0 订阅

订阅专栏

数据库	C#程序
int	int32
text	string
bigint	int64
binary	System.Byte[]
bit	Boolean
char	string
datetime	System.DateTime
decimal	System.Decimal
float	System.Double
image	System.Byte[]
money	System.Decimal
nchar	String
ntext	String
numeric	System.Decimal
nvarchar	String
real	System.Single
smalldatetime	System.DateTime
smallint	Int16
smallmoney	System.Decimal
timestamp	System.DateTime
tinyint	System.Byte
varbinary	System.Byte[]
varchar	String
Variant	Object
unique identifier	System.Guid

/// <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":
      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;
   }