Mapping parameter data

The following table lists SQL Server data types, their equivalents in the common language

runtime (CLR) for SQL Server in the

namespace, and their native CLR

equivalents in the.NET Framework.

data

None

ﾉ

Expand table

System.Data.SqlTypes
System.Data.SqlTypes
Microsoft.SqlServer.Types
SqlInt64
Int64
Nullable<Int64>
SqlBytes
SqlBinary
Byte[]
SqlBoolean
Boolean
Nullable<Boolean>
SqlDateTime
DateTime
Nullable<DateTime>
SqlDateTime
DateTime
Nullable<DateTime>
DateTime
Nullable<DateTime>
None
DateTimeOffset
Nullable<DateTimeOffset>
SqlDecimal
Decimal
Nullable<Decimal>
SqlDouble
Double
Nullable<Double>
SqlGeography
SqlGeometry
SqlHierarchyId
SqlInt32
Int32
Nullable<Int32>
SqlMoney
Decimal
Nullable<Decimal>