SQL SERVER与C#的数据类型对应表

.NET | 2020-11-26 18:35:31 | 阅读 439 次 | 评论(0)
序号
类别
SQLServer
C Sharp
备注
1
整数
bit
Boolean
True转换为1False转换为0
2
tinyint
Byte
C Sharp 数据类型都位于System命名空间
3
smallint
Int16
4
int
Int32
5
bigint
Int64
6
smallmoney
Decimal
7
money
Decimal
8
numeric
Decimal
9
decimal
Decimal
10
浮点数
float
Double
11
real
Single
12
日期和时间
smalldatetime
DateTime
13
datetime
DateTime
14
timestamp
DateTime
15
字符串
char
String
16
text
String
17
varchar
String
18
nchar
String
19
ntext
String
20
nvarchar
String
21
二进制数据
binary
Byte[]
22
varbinary
Byte[]
23
image
Byte[]
24
其他
uniqueidentifier
Guid
25
Variant
Object


private string changetocsharptype(string type)
{
    string reval;
    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;
}

-------------------------------- 作者在 2020-11-26 18:36:02 补充以下内容 --------------------------------

转自:https://www.cnblogs.com/coce/p/9070961.html
文章评论,共0条
游客请输入验证码
浏览2189122次
文章归档