|
1. SqlServer 数据类型对应.Net?的 SqlDbType数据类型
?
public string DBTypeToDotNetDBType(string DBType)
?? {
??? switch (DBType)
??? {
???? case "bigint": return "System.Data.SqlDbType.BigInt";
???? case "binary": return "System.Data.SqlDbType.Binary";
???? case "bit": return "System.Data.SqlDbType.Bit";
???? case "char": return "System.Data.SqlDbType.Char";
???? case "datetime": return "System.Data.SqlDbType.DateTime";
???? case "decimal": return "System.Data.SqlDbType.Decimal";
???? case "float": return "System.Data.SqlDbType.Float";
???? case "image": return "System.Data.SqlDbType.Image";
???? case "int": return "System.Data.SqlDbType.Int";
???? case "money": return "System.Data.SqlDbType.Money";
???? case "nchar": return "System.Data.SqlDbType.NChar";
???? case "ntext": return "System.Data.SqlDbType.NText";
???? case "numeric": return "System.Data.SqlDbType.Decimal";
???? case "nvarchar": return "System.Data.SqlDbType.NVarChar";
???? case "real": return "System.Data.SqlDbType.Real";
???? case "uniqueidentifier": return "System.Data.SqlDbType.UniqueIdentifier";
???? case "smalldatetime": return "System.Data.SqlDbType.SmallDateTime";
???? case "smallint": return "System.Data.SqlDbType.SmallInt";
???? case "smallmoney": return "System.Data.SqlDbType.SmallMoney";
???? case "text": return "System.Data.SqlDbType.Text";
???? case "timestamp": return "System.Data.SqlDbType.Timestamp";
???? case "tinyint": return "System.Data.SqlDbType.TinyInt";
???? case "varbinary": return "System.Data.SqlDbType.VarBinary";
???? case "varchar": return "System.Data.SqlDbType.VarChar";
???? case "variant": return "System.Data.SqlDbType.Variant";
???? case "udt": return "System.Data.SqlDbType.Udt";
???? default:
????? return "";
??? }
?? }
?
?
1. SqlServer 数据类型对应.Net?的 DBType数据类型
?
public string DBTypeToDotNetDataType(string DBType) ?? { ??? switch (DBType) ??? { ???? case "bigint": return "System.Int64"; ???? case "binary": return "System.Byte[]"; ???? case "bit": return "System.Boolean"; ???? case "char": return "System.String"; ???? case "datetime": return "System.DateTime"; ???? case "decimal": return "System.Decimal"; ???? case "float": return "System.Double"; ???? case "image": return "System.Byte[]"; ???? case "int": return "System.Int32"; ???? case "money": return " System.Decimal"; ???? case "nchar": return "System.String"; ???? case "ntext": return "System.String";???? ???? case "numeric": return "System.Decimal"; ???? case "nvarchar": return "System.String"; ???? case "real": return "System.Single"; ???? case "uniqueidentifier": return "System.Guid"; ???? case "smalldatetime": return "System.DateTime"; ???? case "smallint": return "System.Int16"; ???? case "smallmoney": return "System.Decimal"; ???? case "text": return "System.String"; ???? case "timestamp": return "System.Byte[]"; ???? case "tinyint": return "System.Byte"; ???? case "varbinary": return "System.Byte[]"; ???? case "varchar": return "System.String"; ???? case "variant": return "System.Object"; ???? default: ????? return ""; ??? } ?? }
（编辑：李大同）
【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容!
|
