C# Equivalent of SQL Server DataTypes

by

This is for SQL Server 2005. There are updated versions of the table for SQL Server 2008, SQL Server 2008 R2, SQL Server 2012 and SQL Server 2014.

SQL Server Data Types and Their .NET Framework Equivalents

The following table lists Microsoft SQL Server data types, their equivalents in the common language runtime (CLR) for SQL Server in the System.Data.SqlTypes namespace, and their native CLR equivalents in the Microsoft .NET Framework.

SQL Server data type CLR data type (SQL Server) CLR data type (.NET Framework)
varbinary SqlBytes, SqlBinary Byte[]
binary SqlBytes, SqlBinary Byte[]
varbinary(1), binary(1) SqlBytes, SqlBinary byte, Byte[]
image None None
varchar None None
char None None
nvarchar(1), nchar(1) SqlChars, SqlString Char, String, Char[]
nvarchar SqlChars, SqlString String, Char[]
nchar SqlChars, SqlString String, Char[]
text None None
ntext None None
uniqueidentifier SqlGuid Guid
rowversion None Byte[]
bit SqlBoolean Boolean
tinyint SqlByte Byte
smallint SqlInt16 Int16
int SqlInt32 Int32
bigint SqlInt64 Int64
smallmoney SqlMoney Decimal
money SqlMoney Decimal
numeric SqlDecimal Decimal
decimal SqlDecimal Decimal
real SqlSingle Single
float SqlDouble Double
smalldatetime SqlDateTime DateTime
datetime SqlDateTime DateTime
sql_variant None Object
User-defined type(UDT) None user-defined type
table None None
cursor None None
timestamp None None
xml SqlXml None

More Related Contents:

  1. ExecuteReader requires an open and available Connection. The connection’s current state is Connecting
  2. How to directly execute SQL query in C#?
  3. How to deploy application with sql server database on clients
  4. How to execute an SSIS package from .NET?
  5. SqlConnection SqlCommand SqlDataReader IDisposable
  6. Bulk Update in C#
  7. How to catch SQLServer timeout exceptions
  8. Code to validate SQL Scripts
  9. Queuing in OneWay WCF Messages using Windows Service and SQL Server
  10. MultipleActiveResultSets=True or multiple connections?
  11. EF 6 – How to correctly perform parallel queries
  12. SqlConnection.Close() inside using statement
  13. How to keep single SQL Server connection instance open for multiple request in C#?
  14. Received an invalid column length from the bcp client for colid 6
  15. Failed to update .mdf database because the database is read-only (Windows application)
  16. Horrible performance using SqlCommand Async methods with large data
  17. Is it better to execute many sql commands with one connection, or reconnect every time?
  18. GO statements blowing up sql execution in .NET
  19. Is there a .NET equivalent to SQL Server’s newsequentialid()
  20. Know when to retry or fail when calling SQL Server from C#?
  21. How to Specify Primary Key Name in EF-Code-First
  22. Upload CSV file to SQL server
  23. Unable to load SqlServerSpatial.dll
  24. What is the equivalent of bigint in C#?
  25. “The operation is not valid for the state of the transaction” error and transaction scope
  26. Use SQL Server time datatype in C#.NET application?
  27. Should the order of LINQ query clauses affect Entity Framework performance?
  28. How do I connect to a SQL database from C#?
  29. Generating sql code programmatically
  30. Is SqlConnection.Close() need inside a Using statement?

Leave a Comment