What are the C# Equivalents for Common SQL Server Data Types?

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!