C#与sql，数据类型对应关系

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