数据库中与C#中的数据类型对照

最新推荐文章于 2023-06-18 15:27:37 发布

转载最新推荐文章于 2023-06-18 15:27:37 发布 · 807 阅读

文章标签：

#数据库 #c# #string #object #image #float

C# 专栏收录该内容

17 篇文章

订阅专栏

本文介绍了一种从数据库字段类型转换为C#类型的方法，涵盖了多种常见数据库类型及其对应的C#数据类型，如Int、Text、DateTime等。

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