System.Data.SqlTypes Namespace

 

The System.Data.SqlTypes namespace provides classes for native data types in SQL Server. These classes provide a safer, faster alternative to the data types provided by the .NET Framework common language runtime (CLR). Using the classes in this namespace helps prevent type conversion errors caused by loss of precision. Because other data types are converted to and from SqlTypes behind the scenes, explicitly creating and using objects within this namespace also yields faster code.

ClassDescription
System_CAPS_pubclassSqlAlreadyFilledException

The SqlAlreadyFilledException class is not intended for use as a stand-alone component, but as a class from which other classes derive standard functionality.

System_CAPS_pubclassSqlBytes

Represents a mutable reference type that wraps either a Buffer or a Stream.

System_CAPS_pubclassSqlChars

SqlChars is a mutable reference type that wraps a Char array or a SqlString instance.

System_CAPS_pubclassSqlFileStream

Exposes SQL Server data that is stored with the FILESTREAM column attribute as a sequence of bytes.

System_CAPS_pubclassSqlNotFilledException

The SqlNotFilledException class is not intended for use as a stand-alone component, but as a class from which other classes derive standard functionality.

System_CAPS_pubclassSqlNullValueException

The exception that is thrown when the Value property of a System.Data.SqlTypes structure is set to null.

System_CAPS_pubclassSqlTruncateException

The exception that is thrown when you set a value into a System.Data.SqlTypes structure would truncate that value.

System_CAPS_pubclassSqlTypeException

The base exception class for the System.Data.SqlTypes.

System_CAPS_pubclassSqlTypesSchemaImporterExtensionHelper

The SqlTypesSchemaImporterExtensionHelper class is not intended for use as a stand-alone component, but as a class from which other classes derive standard functionality.

System_CAPS_pubclassSqlXml

Represents XML data stored in or retrieved from a server.

System_CAPS_pubclassTypeBigIntSchemaImporterExtension

The TypeBigIntSchemaImporterExtension class is not intended for use as a stand-alone component, but as a class from which other classes derive standard functionality.

System_CAPS_pubclassTypeBinarySchemaImporterExtension

The TypeBinarySchemaImporterExtension class is not intended for use as a stand-alone component, but as a class from which other classes derive standard functionality.

System_CAPS_pubclassTypeBitSchemaImporterExtension

The TypeBitSchemaImporterExtension class is not intended for use as a stand-alone component, but as a class from which other classes derive standard functionality.

System_CAPS_pubclassTypeCharSchemaImporterExtension

The TypeCharSchemaImporterExtension class is not intended for use as a stand-alone component, but as a class from which other classes derive standard functionality.

System_CAPS_pubclassTypeDateTimeSchemaImporterExtension

The TypeDateTimeSchemaImporterExtension class is not intended for use as a stand-alone component, but as a class from which other classes derive standard functionality.

System_CAPS_pubclassTypeDecimalSchemaImporterExtension

The TypeDecimalSchemaImporterExtension class is not intended for use as a stand-alone component, but as a class from which other classes derive standard functionality.

System_CAPS_pubclassTypeFloatSchemaImporterExtension

The TypeFloatSchemaImporterExtension class is not intended for use as a stand-alone component, but as a class from which other classes derive standard functionality.

System_CAPS_pubclassTypeIntSchemaImporterExtension

The TypeIntSchemaImporterExtension class is not intended for use as a stand-alone component, but as a class from which other classes derive standard functionality.

System_CAPS_pubclassTypeMoneySchemaImporterExtension

The TypeMoneySchemaImporterExtension class is not intended for use as a stand-alone component, but as a class from which other classes derive standard functionality.

System_CAPS_pubclassTypeNCharSchemaImporterExtension

The TypeNCharSchemaImporterExtension class is not intended for use as a stand-alone component, but as a class from which other classes derive standard functionality.

System_CAPS_pubclassTypeNTextSchemaImporterExtension

The TypeNTextSchemaImporterExtension class is not intended for use as a stand-alone component, but as a class from which other classes derive standard functionality.

System_CAPS_pubclassTypeNumericSchemaImporterExtension

The TypeNumericSchemaImporterExtension class is not intended for use as a stand-alone component, but as a class from which other classes derive standard functionality.

System_CAPS_pubclassTypeNVarCharSchemaImporterExtension

The TypeNVarCharSchemaImporterExtension class is not intended for use as a stand-alone component, but as a class from which other classes derive standard functionality.

System_CAPS_pubclassTypeRealSchemaImporterExtension

The TypeRealSchemaImporterExtension class is not intended for use as a stand-alone component, but as a class from which other classes derive standard functionality.

System_CAPS_pubclassTypeSmallDateTimeSchemaImporterExtension

The TypeSmallDateTimeSchemaImporterExtension class is not intended for use as a stand-alone component, but as a class from which other classes derive standard functionality.

System_CAPS_pubclassTypeSmallIntSchemaImporterExtension

The TypeSmallIntSchemaImporterExtension class is not intended for use as a stand-alone component, but as a class from which other classes derive standard functionality.

System_CAPS_pubclassTypeSmallMoneySchemaImporterExtension

The TypeSmallMoneySchemaImporterExtension class is not intended for use as a stand-alone component, but as a class from which other classes derive standard functionality.

System_CAPS_pubclassTypeTextSchemaImporterExtension

The TypeTextSchemaImporterExtension class is not intended for use as a stand-alone component, but as a class from which other classes derive standard functionality.

System_CAPS_pubclassTypeTinyIntSchemaImporterExtension

The TypeTinyIntSchemaImporterExtension class is not intended for use as a stand-alone component, but as a class from which other classes derive standard functionality.

System_CAPS_pubclassTypeUniqueIdentifierSchemaImporterExtension

The TypeUniqueIdentifierSchemaImporterExtension class is not intended for use as a stand-alone component, but as a class from which other classes derive standard functionality.

System_CAPS_pubclassTypeVarBinarySchemaImporterExtension

The TypeVarBinarySchemaImporterExtension class is not intended for use as a stand-alone component, but as a class from which other classes derive standard functionality.

System_CAPS_pubclassTypeVarCharSchemaImporterExtension

The TypeVarCharSchemaImporterExtension class is not intended for use as a stand-alone component, but as a class from which other classes derive standard functionality.

System_CAPS_pubclassTypeVarImageSchemaImporterExtension

The TypeVarImageSchemaImporterExtension class is not intended for use as a stand-alone component, but as a class from which other classes derive standard functionality.

StructureDescription
System_CAPS_pubstructureSqlBinary

Represents a variable-length stream of binary data to be stored in or retrieved from a database.

System_CAPS_pubstructureSqlBoolean

Represents an integer value that is either 1 or 0 to be stored in or retrieved from a database.

System_CAPS_pubstructureSqlByte

Represents an 8-bit unsigned integer, in the range of 0 through 255, to be stored in or retrieved from a database.

System_CAPS_pubstructureSqlDateTime

Represents the date and time data ranging in value from January 1, 1753 to December 31, 9999 to an accuracy of 3.33 milliseconds to be stored in or retrieved from a database. The SqlDateTime structure has a different underlying data structure from its corresponding .NET Framework type, DateTime, which can represent any time between 12:00:00 AM 1/1/0001 and 11:59:59 PM 12/31/9999, to the accuracy of 100 nanoseconds. SqlDateTime actually stores the relative difference to 00:00:00 AM 1/1/1900. Therefore, a conversion from "00:00:00 AM 1/1/1900" to an integer will return 0.

System_CAPS_pubstructureSqlDecimal

Represents a numeric value between - 10^38 +1 and 10^38 - 1, with fixed precision and scale.

System_CAPS_pubstructureSqlDouble

Represents a floating-point number within the range of -1.79E +308 through 1.79E +308 to be stored in or retrieved from a database.

System_CAPS_pubstructureSqlGuid

Represents a GUID to be stored in or retrieved from a database.

System_CAPS_pubstructureSqlInt16

Represents a 16-bit signed integer to be stored in or retrieved from a database.

System_CAPS_pubstructureSqlInt32

Represents a 32-bit signed integer to be stored in or retrieved from a database.

System_CAPS_pubstructureSqlInt64

Represents a 64-bit signed integer to be stored in or retrieved from a database.

System_CAPS_pubstructureSqlMoney

Represents a currency value ranging from -2 63 (or -922,337,203,685,477.5808) to 2 63 -1 (or +922,337,203,685,477.5807) with an accuracy to a ten-thousandth of currency unit to be stored in or retrieved from a database.

System_CAPS_pubstructureSqlSingle

Represents a floating point number within the range of -3.40E +38 through 3.40E +38 to be stored in or retrieved from a database.

System_CAPS_pubstructureSqlString

Represents a variable-length stream of characters to be stored in or retrieved from the database. SqlString has a different underlying data structure from its corresponding .NET Framework String data type.

InterfaceDescription
System_CAPS_pubinterfaceINullable

All the System.Data.SqlTypes objects and structures implement the INullable interface.

EnumerationDescription
System_CAPS_pubenumSqlCompareOptions

Specifies the compare option values for a SqlString structure.

System_CAPS_pubenumStorageState

The StorageState enumeration is not intended for use as a stand-alone component, but as an enumeration from which other classes derive standard functionality.

Each data type in SqlTypes has its equivalent data type in SQL Server, with the same underlying data representation. Many of them also have equivalent data types in the CLR. However, SqlDateTime, SqlDecimal, and SqlString have different underlying data structures with their corresponding .NET Framework data types.

The following table maps the members of the SqlTypes namespace to Microsoft SQL Server data types and to the members of the SqlDbType enumeration.

.NET Framework SqlTypes

Native SQL Server

.NET Framework SqlDbType

SqlBinary

binary, image, timestamp, varbinary

Binary, Image, TimeStamp, VarBinary

SqlBoolean

bit

Bit

SqlByte

tinyint

TinyInt

SqlBytes

binary, image, timestamp, varbinary

Binary, Image, TimeStamp, VarBinary

SqlChars

char, nchar, text, ntext, nvarchar, varchar

Char, NChar, Text, Ntext, NVarChar, VarChar

SqlDateTime

datetime, smalldatetime

DateTime, SmallDateTime

SqlDecimal

numeric, decimal

Decimal

SqlDouble

float

Float

SqlFileStream

varbinary

VarBinary

SqlGuid

uniqueidentifier

UniqueIdentifier

SqlInt16

smallint

SmallInt

SqlInt32

int

Int

SqlInt64

bigint

BigInt

SqlMoney

money, smallmoney

Money, SmallMoney

SqlSingle

real

Real

SqlString

char, nchar, text, ntext, nvarchar, varchar

Char, NChar, Text, Ntext, NVarChar, VarChar

SqlXml

xml

Xml

Return to top
Show: