C#.NET数据类型(Type)与DbType的对应关系

作者:C/S框架网|www.cscode.ne 发布日期:2021/06/08 10:47:57

C#.NET数据类型(Type)与DbType的对应关系

C# Code:

/// <summary>
/// .NET数据类型与DbType对应关系
/// </summary>
public static IDictionary<Type, DbType> NetType2DbTypeMapping
{
get
{
IDictionary<Type, DbType> map = new Dictionary<Type, DbType>();

map[typeof(object)] = DbType.Object;
map[typeof(byte)] = DbType.Byte;
map[typeof(sbyte)] = DbType.SByte;
map[typeof(short)] = DbType.Int16;
map[typeof(ushort)] = DbType.UInt16;
map[typeof(int)] = DbType.Int32;
map[typeof(uint)] = DbType.UInt32;
map[typeof(long)] = DbType.Int64;
map[typeof(ulong)] = DbType.UInt64;
map[typeof(float)] = DbType.Single;
map[typeof(double)] = DbType.Double;
map[typeof(decimal)] = DbType.Decimal;
map[typeof(bool)] = DbType.Boolean;
map[typeof(string)] = DbType.String;
map[typeof(char)] = DbType.StringFixedLength;
map[typeof(Guid)] = DbType.Guid;
map[typeof(DateTime)] = DbType.DateTime;
map[typeof(DateTimeOffset)] = DbType.DateTimeOffset;
map[typeof(byte[])] = DbType.Binary;
map[typeof(byte?)] = DbType.Byte;
map[typeof(sbyte?)] = DbType.SByte;
map[typeof(short?)] = DbType.Int16;
map[typeof(ushort?)] = DbType.UInt16;
map[typeof(int?)] = DbType.Int32;
map[typeof(uint?)] = DbType.UInt32;
map[typeof(long?)] = DbType.Int64;
map[typeof(ulong?)] = DbType.UInt64;
map[typeof(float?)] = DbType.Single;
map[typeof(double?)] = DbType.Double;
map[typeof(decimal?)] = DbType.Decimal;
map[typeof(bool?)] = DbType.Boolean;
map[typeof(char?)] = DbType.StringFixedLength;
map[typeof(Guid?)] = DbType.Guid;
map[typeof(DateTime?)] = DbType.DateTime;
map[typeof(DateTimeOffset?)] = DbType.DateTimeOffset;

return map;
}
}

//来源:C/S框架网 | www.csframework.com | QQ:23404761

参考文档：

SqlServer数据类型、DbType类型、.NET类型与达梦数据类型关系表|C/S开发框架
Oracle数据类型(OracleDbType)名称对应.NET类型(Type)
MySql数据类型(MySqlDbType)名称对应.NET类型(Type)
MsSql数据类型(SqlDbType)名称对应.NET类型(Type)
Oracle数据类型（OracleDbType）与.NET类型(Type)对应关系
MySql数据类型（MySqlDbType）与.NET类型(Type)对应关系
MsSql数据类型（SqlDbType）与.NET类型(Type)对应关系
DbType与C#.NET数据类型（Type）对应关系
将SQLServer数据类型转换为.Net中SqlDbType类型
MySQL数据类型(MySqlDbType)数据类型名称对应DbType类型
MsSQL数据类型(SqlDbType)名称对应DbType类型
Oracle数据类型(OracleDbType)名称对应DbType类型
SQL Server 数据类型对应.NET类型的EF模型定义|C/S开发框架
C#.NET 处理SQL特殊数据类型Geography/Geometry/Hierarchyid/XML
将SQLServer数据类型转换为C#.Net类型
MsSQL/MySQL/Oracle三种常用数据库数据类型(Data Type)对应关系表