Skip to content

Latest commit

 

History

History
38 lines (31 loc) · 2.45 KB

sql-server-data-types-in-the-net-framework.md

File metadata and controls

38 lines (31 loc) · 2.45 KB
title description author ms.author ms.date ms.service ms.subservice ms.topic helpviewer_keywords
SQL Server Data Types in the .NET Framework
The SqlTypes library is part of the Microsoft .NET Framework. It provides data types with the same semantics and precision as those in the SQL Server database.
rwestMSFT
randolphwest
03/17/2017
sql
clr
reference
System.Data library
System.Data.SqlTypes namespace
data types [CLR integration]
SqlTypes library
database objects [CLR integration], data types
common language runtime [SQL Server], data types
building database objects [CLR integration], data types
mapping data types [CLR integration]

SQL Server Data Types in the .NET Framework

[!INCLUDE SQL Server] The SqlTypes library is part of the base class library of the [!INCLUDEmsCoName] .NET Framework. It is designed to provide data types with the same semantics and precision as those found in the [!INCLUDEssNoVersion] database. This topic describes the new semantics to .NET Framework programmers, and introduces the types implemented in the System.Data.SqlTypes namespace that is included in the System.Data library.

This following table lists the topics in this section.

Nullability and Three-Value Logic Comparisons
Discusses how NULL values are handled with common language runtime (CLR) integration data types.

Collation and CLR Integration Data Types
Describes how collations are handled with CLR integration.

Handling Large Object (LOB) Parameters in the CLR
Describes how to pass LOB types between [!INCLUDEssNoVersion] and the CLR.

Mapping CLR Parameter Data
Shows data type mappings between [!INCLUDEssNoVersion], CLR integration, and the .NET Framework.