資料庫中與c#中的資料類型對照

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