数据库中与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;        }