SQL Server数据类型,System.Data.SqlDbType,.NET数据类型
SQL Server数据类型 | System.Data.SqlDbType | .NET数据类型 |
int | SqlDbType.Int | int |
varchar | SqlDbType.VarChar | string |
bit | SqlDbType.Bit | bool |
datetime | SqlDbType.DateTime | DateTime |
decimal | SqlDbType.Decimal | Decimal |
float | SqlDbType.Float | Double |
image | SqlDbType.Image | Byte[] |
money | SqlDbType.Money | Single |
ntext | SqlDbType.NText | string |
nvarchar | SqlDbType.NVarChar | string |
smalldatetime | SqlDbType.SmallDateTime | DateTime |
smallint | SqlDbType.SmallInt | Int16 |
text | SqlDbType.Text | string |
bigint | SqlDbType.BigInt | Int64 |
binary | SqlDbType.Binary | Byte[] |
char | SqlDbType.Char | string |
nchar | SqlDbType.NChar | string |
numeric | SqlDbType.Decimal | Decimal |
real | SqlDbType.Real | Single |
smallmoney | SqlDbType.SmallMoney | Single |
sql_variant | SqlDbType.Variant | Object |
timestamp | SqlDbType.Timestamp | Byte[] |
tinyint | SqlDbType.TinyInt | Byte |
uniqueidentifier | SqlDbType.UniqueIdentifier | Guid |
varbinary | SqlDbType.VarBinary | Byte[] |
xml | SqlDbType.Xml |