摘要:
下文讲述c#中SqlDbType同DbType之间的对应关系，如下所示:
1.c# SqlDbType同DbType之间对应关系
| c#类型 | sqlserver类型 |
| SqlDbType.BigInt | DbType.Int64 |
| SqlDbType.Binary | DbType.Binary |
| SqlDbType.Bit | DbType.Boolean |
| SqlDbType.Char | DbType.AnsiStringFixedLength |
| SqlDbType.DateTime | DbType.DateTime |
| SqlDbType.Decimal | DbType.Decimal |
| SqlDbType.Float | DbType.Double |
| SqlDbType.Image | DbType.Binary |
| SqlDbType.Int | DbType.Int32 |
| SqlDbType.Money | DbType.Currency |
| SqlDbType.NChar | DbType.StringFixedLength |
| SqlDbType.NText | DbType.String |
| SqlDbType.NVarChar | DbType.String |
| SqlDbType.Real | DbType.Single |
| SqlDbType.UniqueIdentifier | DbType.Guid |
| SqlDbType.SmallDateTime | DbType.DateTime |
| SqlDbType.SmallInt | DbType.Int16 |
| SqlDbType.SmallMoney | DbType.Currency |
| SqlDbType.Text | DbType.AnsiString |
| SqlDbType.Timestamp | DbType.Binary |
| SqlDbType.TinyInt | DbType.Byte |
| SqlDbType.VarBinary | DbType.Binary |
| SqlDbType.VarChar | DbType.AnsiString |
| SqlDbType.Variant | DbType.Object |
| SqlDbType.Xml | DbType.Xml |
| SqlDbType.Udt | DbType.Object |
| SqlDbType.Structured | DbType.Object |
| SqlDbType.Date | DbType.Date |
| SqlDbType.Time | DbType.Time |
| SqlDbType.DateTime2 | DbType.DateTime2 |
| SqlDbType.DateTimeOffset | DbType.DateTimeOffset |
