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

数据库	C#程序	数据库	C#程序	数据库	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;
   }