Angka Tepat
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 |
Anggaran Angka
SQL Server Data Type | C# Data Type (SQL Server) | C# Data Type (.NET Framework) |
---|---|---|
float | SqlSingle | Single |
real | SqlDouble | Double |
Tarikh dan Masa
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 |
Rentetan Aksara
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 |
Rentetan Aksara Unikod
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 |
Rentetan Perduaan
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 |
Jenis Data Lain
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 |
Atas ialah kandungan terperinci Apakah Setara C# Jenis Data Pelayan SQL Biasa?. Untuk maklumat lanjut, sila ikut artikel berkaitan lain di laman web China PHP!