DbType → SQL Server 类型 映射表
| DbType |
SQL Server 类型 |
| AnsiString | VarChar |
| Binary | VarBinary |
| Byte | TinyInt |
| Boolean | Bit |
| Currency | Money |
| Date | DateTime |
| DateTime | DateTime |
| Decimal | Decimal |
| Double | Float |
| Guid | UniqueIdentifier |
| Int16 | SmallInt |
| Int32 | Int |
| Int64 | BigInt |
| Object | Variant |
| Single | Real |
| String | NVarChar |
| Time | DateTime |
| AnsiStringFixedLength | Char |
| StringFixedLength | NChar |
| Xml | Xml |
| DateTime2 | DateTime2 |
| DateTimeOffset | DateTimeOffset |
映射关系定义位置(源码参考)
\DataBase\SqlServer\SqlMapping.cs // GetDBType
DatatypeMap.cfg // ValueType
\AiExpressionTurn\Base\AiExpressionWriterSql.cs // VisitConstant