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 "";
}
}