精確數值
| SQL Server Data Type | C# Data Type (SQL Server) | C# Data Type (.NET Framework) |
|---|---|---|
| bigint | SqlInt64 | Int64 |
| numeric | SqlDecimal | Decimal |
| bit | SqlBoolean | Boolean |
| smallint | SqlInt16 | Int16 |
| decimal | SqlDecimal | Decimal |
| smallmoney | SqlMoney | Decimal |
| int | SqlInt32 | Int32 |
| tinyint | SqlByte | Byte |
| money | SqlMoney | Decimal |
近似值數字
| SQL Server Data Type | C# Data Type (SQL Server) | C# Data Type (.NET Framework) |
|---|---|---|
| float | SqlSingle | Single |
| real | SqlDouble | Double |
日期和時間
| SQL Server Data Type | C# Data Type (SQL Server) | C# Data Type (.NET Framework) |
|---|---|---|
| date | SqlDate | None |
| datetimeoffset | SqlDateTimeOffset | None |
| datetime2 | SqlDateTime2 | None |
| smalldatetime | None | DateTime |
| datetime | SqlDateTime | DateTime |
| time | SqlTime | None |
字串
| SQL Server Data Type | C# Data Type (SQL Server) | C# Data Type (.NET Framework) |
|---|---|---|
| char | SqlChars, SqlString | String, Char[] |
| varchar | None | None |
| text | None | None |
Unicode字元字串
| SQL Server Data Type | C# Data Type (SQL Server) | C# Data Type (.NET Framework) |
|---|---|---|
| nchar | SqlChars, SqlString | String, Char[] |
| nvarchar | SqlChars, SqlString | String, Char[] |
| ntext | None | None |
二進位字串
| SQL Server Data Type | C# Data Type (SQL Server) | C# Data Type (.NET Framework) |
|---|---|---|
| binary | SqlBytes, SqlBinary | Byte[] |
| varbinary | SqlBytes, SqlBinary | Byte[] |
| image | None | None |
其他資料型別
| SQL Server Data Type | C# Data Type (SQL Server) | C# Data Type (.NET Framework) |
|---|---|---|
| cursor | None | None |
| timestamp | None | None |
| hierarchyid | None | None |
| uniqueidentifier | SqlGuid | Guid |
| sql_variant | None | Object |
| xml | SqlXml | None |
| table | None | None |
以上是常見 SQL Server 資料類型的 C# 等效項是什麼？的詳細內容。更多資訊請關注PHP中文網其他相關文章！
