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

 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             return typeof(Object);10         case sqlDbType.Bit:11             return typeof(Boolean);12         case sqlDbType.Char:13             return typeof(String);14         case sqlDbType.DateTime:15             return typeof(DateTime);16         case sqlDbType.Decimal:17             return typeof(Decimal);18         case sqlDbType.float:19             return typeof(Double);20         case sqlDbType.Image:21             return typeof(Object);22         case sqlDbType.Int:23             return typeof(Int32);24         case sqlDbType.Money:25             return typeof(Decimal);26         case sqlDbType.NChar:27             return typeof(String);28         case sqlDbType.NText:29             return typeof(String);30         case sqlDbType.NVarChar:31             return typeof(String);32         case sqlDbType.Real:33             return typeof(Single);34         case sqlDbType.SmallDateTime:35             return typeof(DateTime);36         case sqlDbType.Smallint:37             return typeof(Int16);38         case sqlDbType.SmallMoney:39             return typeof(Decimal);40         case sqlDbType.Text:41             return typeof(String);42         case sqlDbType.Timestamp:43             return typeof(Object);44         case sqlDbType.tinyint:45             return typeof(Byte);46         case sqlDbType.Udt://自定义的数据类型47             return typeof(Object);48         case sqlDbType.UniqueIDentifIEr:49             return typeof(Object);50         case sqlDbType.VarBinary:51             return typeof(Object);52         case sqlDbType.VarChar:53             return typeof(String);54         case sqlDbType.Variant:55             return typeof(Object);56         case sqlDbType.Xml:57             return typeof(Object);58         default:59             return null;60     }61 }

 1 // sql server数据类型（如：varchar）转换为sqlDbType类型 2 public static sqlDbType sqlTypetosqlDbType(string sqlTypestring) 3 { 4     sqlDbType dbType = sqlDbType.Variant;//默认为Object 5  6     switch (sqlTypestring.Tolower()) 7     { 8         case "int": 9             dbType = sqlDbType.Int;10             break;11         case "varchar":12             dbType = sqlDbType.VarChar;13             break;14         case "bit":15             dbType = sqlDbType.Bit;16             break;17         case "datetime":18             dbType = sqlDbType.DateTime;19             break;20         case "decimal":21             dbType = sqlDbType.Decimal;22             break;23         case "float":24             dbType = sqlDbType.float;25             break;26         case "image":27             dbType = sqlDbType.Image;28             break;29         case "money":30             dbType = sqlDbType.Money;31             break;32         case "ntext":33             dbType = sqlDbType.NText;34             break;35         case "nvarchar":36             dbType = sqlDbType.NVarChar;37             break;38         case "smalldatetime":39             dbType = sqlDbType.SmallDateTime;40             break;41         case "smallint":42             dbType = sqlDbType.Smallint;43             break;44         case "text":45             dbType = sqlDbType.Text;46             break;47         case "bigint":48             dbType = sqlDbType.BigInt;49             break;50         case "binary":51             dbType = sqlDbType.Binary;52             break;53         case "char":54             dbType = sqlDbType.Char;55             break;56         case "nchar":57             dbType = sqlDbType.NChar;58             break;59         case "numeric":60             dbType = sqlDbType.Decimal;61             break;62         case "real":63             dbType = sqlDbType.Real;64             break;65         case "smallmoney":66             dbType = sqlDbType.SmallMoney;67             break;68         case "sql_variant":69             dbType = sqlDbType.Variant;70             break;71         case "timestamp":72             dbType = sqlDbType.Timestamp;73             break;74         case "tinyint":75             dbType = sqlDbType.tinyint;76             break;77         case "uniqueIDentifIEr":78             dbType = sqlDbType.UniqueIDentifIEr;79             break;80         case "varbinary":81             dbType = sqlDbType.VarBinary;82             break;83         case "xml":84             dbType = sqlDbType.Xml;85             break;86     }87     return dbType;88 }

总结

以上是内存溢出为你收集整理的SqlServer数据类型、C#SqlDbType对应关系及转换全部内容，希望文章能够帮你解决SqlServer数据类型、C#SqlDbType对应关系及转换所遇到的程序开发问题。

如果觉得内存溢出网站内容还不错，欢迎将内存溢出网站推荐给程序员好友。