What are the C# Equivalents for Common SQL Server Data Types?
Jan 07, 2025 am 11:26 AM
SQL Server Data Types and their C# Equivalents
In C#, there are a variety of data types that correspond to the data types used in Microsoft SQL Server. Here is a table showing the equivalents for various SQL Server data types:
| SQL Server Data Type | C# Data Type | |
|---|---|---|
| Exact Numerics | ||
| bigint | Int64 | |
| numeric | Decimal | |
| bit | Boolean | |
| smallint | Int16 | |
| decimal | Decimal | |
| smallmoney | Decimal | |
| int | Int32 | |
| tinyint | Byte | |
| money | Decimal | |
| Approximate Numerics | ||
| float | Double | |
| real | Single | |
| Date and Time | ||
| date | None | |
| datetimeoffset | None | |
| datetime2 | None | |
| smalldatetime | DateTime | |
| datetime | DateTime | |
| time | None | |
| Character Strings | ||
| char | None | |
| varchar | None | |
| text | None | |
| Unicode Character Strings | ||
| nchar | None | |
| nvarchar | None | |
| ntext | None | |
| Binary Strings | ||
| binary | Byte[] | |
| varbinary | Byte[] | |
| image | None | |
| Other Data Types | ||
| cursor | None | |
| timestamp | None | |
| hierarchyid | None | |
| uniqueidentifier | Guid | |
| sql_variant | Object | |
| xml | SqlXml | |
| table | None |
The above is the detailed content of What are the C# Equivalents for 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?
