SqlServer数据类型、C#SqlDbType对应关系及转换

 1 // SqlDbType转换为C#数据类型
 2 public static Type SqlType2CsharpType(SqlDbType sqlType)
 3 {
 4 switch (sqlType)
 5 {
 6        case SqlDbType.BigInt:
 7          return typeof(Int64);
 8        case SqlDbType.Binary:
 9          typeof(Object);
10        case SqlDbType.Bit:
11          typeof(Boolean);
12        case SqlDbType.Char:
13          typeof(String);
14        case SqlDbType.DateTime:
15          typeof(DateTime);
16        case SqlDbType.Decimal:
17          typeof(Decimal);
18        case SqlDbType.Float:
19          typeof(Double);
20        case SqlDbType.Image:
21          22        case SqlDbType.Int:
23          typeof(Int32);
24        case SqlDbType.Money:
25          26        case SqlDbType.NChar:
27          28        case SqlDbType.NText:
29          30        case SqlDbType.NVarChar:
31          32        case SqlDbType.Real:
33          typeof(Single);
34        case SqlDbType.SmallDateTime:
35          36        case SqlDbType.SmallInt:
37          typeof(Int16);
38        case SqlDbType.SmallMoney:
39          40        case SqlDbType.Text:
41          42        case SqlDbType.Timestamp:
43          44        case SqlDbType.TinyInt:
45          typeof(Byte);
46        case SqlDbType.Udt:自定义的数据类型47          48        case SqlDbType.UniqueIdentifier:
49          50        case SqlDbType.VarBinary:
51          52        case SqlDbType.VarChar:
53          54        case SqlDbType.Variant:
55          56        case SqlDbType.Xml:
57          58        default:
59          null;
60 }
61 }

 sql server数据类型（如：varchar）
 转换为SqlDbType类型 3 static SqlDbType SqlTypeString2SqlType(string sqlTypeString)
 4 {
 5 SqlDbType dbType = SqlDbType.Variant;默认为Object 6 
 7 switch (sqlTypeString)
 8 {
 9        case "int":
10          dbType = SqlDbType.Int;
break;
varchar13          dbType = SqlDbType.VarChar;
14          15        bit16          dbType = SqlDbType.Bit;
datetime19          dbType = SqlDbType.DateTime;
20          21        decimal22          dbType = SqlDbType.Decimal;
float25          dbType = SqlDbType.Float;
26          27        image28          dbType = SqlDbType.Image;
money31          dbType = SqlDbType.Money;
32          33        ntext34          dbType = SqlDbType.NText;
nvarchar37          dbType = SqlDbType.NVarChar;
38          39        smalldatetime40          dbType = SqlDbType.SmallDateTime;
smallint43          dbType = SqlDbType.SmallInt;
44          45        text46          dbType = SqlDbType.Text;
bigint49          dbType = SqlDbType.BigInt;
50          51        binary52          dbType = SqlDbType.Binary;
char55          dbType = SqlDbType.Char;
56          57        nchar58          dbType = SqlDbType.NChar;
60        numeric61          dbType = SqlDbType.Decimal;
62          63        real64          dbType = SqlDbType.Real;
65          66        smallmoney67          dbType = SqlDbType.SmallMoney;
68          69        sql_variant70          dbType = SqlDbType.Variant;
71          72        timestamp73          dbType = SqlDbType.Timestamp;
74          75        tinyint76          dbType = SqlDbType.TinyInt;
77          78        uniqueidentifier79          dbType = SqlDbType.UniqueIdentifier;
80          81        varbinary82          dbType = SqlDbType.VarBinary;
83          84        xml85          dbType = SqlDbType.Xml;
86          87 }
88 return dbType;
89 }

（编辑：李大同）

【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容!