{"id":497,"date":"2015-07-03T18:23:35","date_gmt":"2015-07-03T12:53:35","guid":{"rendered":"http:\/\/mairwa.com\/wordpress\/?p=497"},"modified":"2015-07-03T18:23:35","modified_gmt":"2015-07-03T12:53:35","slug":"sql-server-data-type-mappings","status":"publish","type":"post","link":"http:\/\/mairwa.com\/wordpress\/?p=497","title":{"rendered":"SQL Server Data Type Mappings"},"content":{"rendered":"

 <\/p>\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n
SQL Server Database Engine type<\/strong><\/td>\n.NET Framework type<\/strong><\/td>\nSqlDbType enumeration<\/strong><\/td>\nSqlDataReader SqlTypes typed accessor<\/strong><\/td>\nDbType enumeration<\/strong><\/td>\nSqlDataReader DbType typed accessor<\/strong><\/td>\n<\/tr>\n
bigint<\/td>\nInt64<\/td>\nBigInt<\/td>\nGetSqlInt64<\/td>\nInt64<\/td>\nGetInt64<\/td>\n<\/tr>\n
binary<\/td>\nByte[]<\/td>\nVarBinary<\/td>\nGetSqlBinary<\/td>\nBinary<\/td>\nGetBytes<\/td>\n<\/tr>\n
bit<\/td>\nBoolean<\/td>\nBit<\/td>\nGetSqlBoolean<\/td>\nBoolean<\/td>\nGetBoolean<\/td>\n<\/tr>\n
char<\/td>\nString<\/p>\n

Char[]<\/td>\n

Char<\/td>\nGetSqlString<\/td>\nAnsiStringFixedLength,<\/p>\n

String<\/td>\n

GetString<\/p>\n

GetChars<\/td>\n<\/tr>\n

date<\/p>\n

(SQL Server 2008 and later)<\/td>\n

DateTime<\/td>\nDate<\/td>\nGetSqlDateTime<\/td>\nDate<\/td>\nGetDateTime<\/td>\n<\/tr>\n
datetime<\/td>\nDateTime<\/td>\nDateTime<\/td>\nGetSqlDateTime<\/td>\nDateTime<\/td>\nGetDateTime<\/td>\n<\/tr>\n
datetime2<\/p>\n

(SQL Server 2008 and later)<\/td>\n

DateTime<\/td>\nDateTime2<\/td>\nNone<\/td>\nDateTime2<\/td>\nGetDateTime<\/td>\n<\/tr>\n
datetimeoffset<\/p>\n

(SQL Server 2008 and later)<\/td>\n

DateTimeOffset<\/td>\nDateTimeOffset<\/td>\nnone<\/td>\nDateTimeOffset<\/td>\nGetDateTimeOffset<\/td>\n<\/tr>\n
decimal<\/td>\nDecimal<\/td>\nDecimal<\/td>\nGetSqlDecimal<\/td>\nDecimal<\/td>\nGetDecimal<\/td>\n<\/tr>\n
FILESTREAM attribute (varbinary(max))<\/td>\nByte[]<\/td>\nVarBinary<\/td>\nGetSqlBytes<\/td>\nBinary<\/td>\nGetBytes<\/td>\n<\/tr>\n
float<\/td>\nDouble<\/td>\nFloat<\/td>\nGetSqlDouble<\/td>\nDouble<\/td>\nGetDouble<\/td>\n<\/tr>\n
image<\/td>\nByte[]<\/td>\nBinary<\/td>\nGetSqlBinary<\/td>\nBinary<\/td>\nGetBytes<\/td>\n<\/tr>\n
int<\/td>\nInt32<\/td>\nInt<\/td>\nGetSqlInt32<\/td>\nInt32<\/td>\nGetInt32<\/td>\n<\/tr>\n
money<\/td>\nDecimal<\/td>\nMoney<\/td>\nGetSqlMoney<\/td>\nDecimal<\/td>\nGetDecimal<\/td>\n<\/tr>\n
nchar<\/td>\nString<\/p>\n

Char[]<\/td>\n

NChar<\/td>\nGetSqlString<\/td>\nStringFixedLength<\/td>\nGetString<\/p>\n

GetChars<\/td>\n<\/tr>\n

ntext<\/td>\nString<\/p>\n

Char[]<\/td>\n

NText<\/td>\nGetSqlString<\/td>\nString<\/td>\nGetString<\/p>\n

GetChars<\/td>\n<\/tr>\n

numeric<\/td>\nDecimal<\/td>\nDecimal<\/td>\nGetSqlDecimal<\/td>\nDecimal<\/td>\nGetDecimal<\/td>\n<\/tr>\n
nvarchar<\/td>\nString<\/p>\n

Char[]<\/td>\n

NVarChar<\/td>\nGetSqlString<\/td>\nString<\/td>\nGetString<\/p>\n

GetChars<\/td>\n<\/tr>\n

real<\/td>\nSingle<\/td>\nReal<\/td>\nGetSqlSingle<\/td>\nSingle<\/td>\nGetFloat<\/td>\n<\/tr>\n
rowversion<\/td>\nByte[]<\/td>\nTimestamp<\/td>\nGetSqlBinary<\/td>\nBinary<\/td>\nGetBytes<\/td>\n<\/tr>\n
smalldatetime<\/td>\nDateTime<\/td>\nDateTime<\/td>\nGetSqlDateTime<\/td>\nDateTime<\/td>\nGetDateTime<\/td>\n<\/tr>\n
smallint<\/td>\nInt16<\/td>\nSmallInt<\/td>\nGetSqlInt16<\/td>\nInt16<\/td>\nGetInt16<\/td>\n<\/tr>\n
smallmoney<\/td>\nDecimal<\/td>\nSmallMoney<\/td>\nGetSqlMoney<\/td>\nDecimal<\/td>\nGetDecimal<\/td>\n<\/tr>\n
sql_variant<\/td>\nObject *<\/td>\nVariant<\/td>\nGetSqlValue\u00a0*<\/td>\nObject<\/td>\nGetValue\u00a0*<\/td>\n<\/tr>\n
text<\/td>\nString<\/p>\n

Char[]<\/td>\n

Text<\/td>\nGetSqlString<\/td>\nString<\/td>\nGetString<\/p>\n

GetChars<\/td>\n<\/tr>\n

time<\/p>\n

(SQL Server 2008 and later)<\/td>\n

TimeSpan<\/td>\nTime<\/td>\nnone<\/td>\nTime<\/td>\nGetDateTime<\/td>\n<\/tr>\n
timestamp<\/td>\nByte[]<\/td>\nTimestamp<\/td>\nGetSqlBinary<\/td>\nBinary<\/td>\nGetBytes<\/td>\n<\/tr>\n
tinyint<\/td>\nByte<\/td>\nTinyInt<\/td>\nGetSqlByte<\/td>\nByte<\/td>\nGetByte<\/td>\n<\/tr>\n
uniqueidentifier<\/td>\nGuid<\/td>\nUniqueIdentifier<\/td>\nGetSqlGuid<\/td>\nGuid<\/td>\nGetGuid<\/td>\n<\/tr>\n
varbinary<\/td>\nByte[]<\/td>\nVarBinary<\/td>\nGetSqlBinary<\/td>\nBinary<\/td>\nGetBytes<\/td>\n<\/tr>\n
varchar<\/td>\nString<\/p>\n

Char[]<\/td>\n

VarChar<\/td>\nGetSqlString<\/td>\nAnsiString\u00a0,\u00a0String<\/td>\nGetString<\/p>\n

GetChars<\/td>\n<\/tr>\n

xml<\/td>\nXml<\/td>\nXml<\/td>\nGetSqlXml<\/td>\nXml<\/td>\nnone<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

*<\/p>\n","protected":false},"excerpt":{"rendered":"

  SQL Server Database Engine type .NET Framework type SqlDbType enumeration SqlDataReader SqlTypes typed accessor DbType enumeration SqlDataReader DbType typed accessor bigint Int64 BigInt GetSqlInt64 Int64 GetInt64 binary Byte[] VarBinary GetSqlBinary Binary GetBytes bit Boolean Bit GetSqlBoolean Boolean GetBoolean char String Char[] Char GetSqlString AnsiStringFixedLength, String GetString GetChars date (SQL Server 2008 and later) DateTime Date GetSqlDateTime Date GetDateTime datetime… Read more →<\/a><\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3,14],"tags":[],"class_list":["post-497","post","type-post","status-publish","format-standard","hentry","category-c-vb","category-sql-server","xfolkentry"],"_links":{"self":[{"href":"http:\/\/mairwa.com\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/497","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/mairwa.com\/wordpress\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/mairwa.com\/wordpress\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/mairwa.com\/wordpress\/index.php?rest_route=\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"http:\/\/mairwa.com\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=497"}],"version-history":[{"count":1,"href":"http:\/\/mairwa.com\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/497\/revisions"}],"predecessor-version":[{"id":498,"href":"http:\/\/mairwa.com\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/497\/revisions\/498"}],"wp:attachment":[{"href":"http:\/\/mairwa.com\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=497"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/mairwa.com\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=497"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/mairwa.com\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=497"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}