What are the C# Equivalents of Common SQL Server Data Types?
Jan 07, 2025 am 11:23 AM
C# Equivalent of SQL Server Data Types
Exact Numerics
| 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 |
Approximate Numerics
| SQL Server Data Type | C# Data Type (SQL Server) | C# Data Type (.NET Framework) |
|---|---|---|
| float | SqlSingle | Single |
| real | SqlDouble | Double |
Date and Time
| 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 |
Character Strings
| 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 Character Strings
| 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 |
Binary Strings
| 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 |
Other Data Types
| 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 |
The above is the detailed content of What are the C# Equivalents of Common SQL Server Data Types?. For more information, please follow other related articles on the PHP Chinese website!
Hot Article
Hot tools Tags
Hot Article
Hot Article Tags
Notepad++7.3.1
Easy-to-use and free code editor
SublimeText3 Chinese version
Chinese version, very easy to use
Zend Studio 13.0.1
Powerful PHP integrated development environment
Dreamweaver CS6
Visual web development tools
SublimeText3 Mac version
God-level code editing software (SublimeText3)
Hot Topics
C language function format letter case conversion steps
Mar 03, 2025 pm 05:53 PM
C language function format letter case conversion steps
What are the types of values returned by c language functions? What determines the return value?
Mar 03, 2025 pm 05:52 PM
What are the types of values returned by c language functions? What determines the return value?
What are the definitions and calling rules of c language functions and what are the
Mar 03, 2025 pm 05:53 PM
What are the definitions and calling rules of c language functions and what are the
How does the C Standard Template Library (STL) work?
Mar 12, 2025 pm 04:50 PM
How does the C Standard Template Library (STL) work?
Where is the return value of the c language function stored in memory?
Mar 03, 2025 pm 05:51 PM
Where is the return value of the c language function stored in memory?
How do I use algorithms from the STL (sort, find, transform, etc.) efficiently?
Mar 12, 2025 pm 04:52 PM
How do I use algorithms from the STL (sort, find, transform, etc.) efficiently?
