sql到C#的資料類型轉換

/// <summary>       /// sql到C#的資料類型轉換       /// </summary>       /// <param name="typename">sql資料類型名稱</param>       /// <returns>C#名稱</returns>       public static string SqlToCsharp(string typename)       {            switch (typename)           {               case "bit": return "Boolean";               case "bigint": return "Int64";               case "int": return "Int32";               case "smallint": return "Int16";               case "tinyint": return "Byte";               case "numeric":               case "money":               case"smallmoney":               case "decimal": return "Decimal";               case "float": return "Double";               case "real": return "Single";               case "smalldatetime":               case"timestamp":               case "datetime": return "DateTime";               case "char":               case"varchar":               case "text":               case "Unicode":               case"nvarchar":               case "ntext": return "string";               case"binary":               case"varbinary":               case "image": return "Byte[]";               case "uniqueidentifier": return "Guid";               default: return "Object";           }        }