sqlserver与c#中数据类型的对应关系

sqlserver与c#中数据类型的对应关系

/// /// 数据库中与c#中的数据类型对照 /// ///?? 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":?? ?? // 0为false ???? 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; }

（编辑：李大同）

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

?