Sql类型 | DbType | SqlDbType | Type |
bit | Boolean | Bit | System.Boolean |
tinyint | Byte | TinyInt | System.Byte |
smallint | Int16 | SmallInt | System.Int16 |
int | Int32 | Int | System.Int32 |
bigint | Int64 | BigInt | System.Int64 |
real | Single | Real | System.Single |
float | Double | Float | System.Double |
smallmoney | Decimal | SmallMoney | System.Decimal |
money | Decimal | Money | System.Decimal |
numeric | Decimal | Decimal | System.Decimal |
decimal | Decimal | Decimal | System.Decimal |
smalldatetime | DateTime | SmallDateTime | System.DateTime |
datetime | DateTime | DateTime | System.DateTime |
binary | Byte[] | Binary | System.Byte的Array |
varbinary | Byte[] | VarBinary | System.Byte的Array |
image | Byte[] | Image | System.Byte的Array |
timestamp | Byte[] | Timestamp | System.Byte的Array |
char | String | Char | System.String |
nchar | String | NChar | System.String |
varchar | String | VarChar | System.String |
nvarchar | String | NVarChar | System.String |
text | String | Text | System.String |
ntext | String | NText | System.String |
xml | String | Xml | System.String |
uniqueidentifier | Guid | UniqueIdentifier | System.Guid |
sql_variant | Object | Variant | System.Object |
DbType + SqlDbType + 系统数据类型对照表
最新推荐文章于 2023-08-08 17:41:37 发布