SqlBinary Structure

 
System_CAPS_noteNote

The .NET API Reference documentation has a new home. Visit the .NET API Browser on docs.microsoft.com to see the new experience.

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

Namespace:   System.Data.SqlTypes
Assembly:  System.Data (in System.Data.dll)

[SerializableAttribute]
public struct SqlBinary : INullable, IComparable, IXmlSerializable

NameDescription
System_CAPS_pubmethodSqlBinary(Byte[])

Initializes a new instance of the SqlBinary structure, setting the Value property to the contents of the supplied byte array.

NameDescription
System_CAPS_pubpropertyIsNull

Indicates whether this SqlBinary structure is null. This property is read-only.

System_CAPS_pubpropertyItem[Int32]

Gets the single byte from the Value property located at the position indicated by the integer parameter, index. If index indicates a position beyond the end of the byte array, a SqlNullValueException will be raised. This property is read-only.

System_CAPS_pubpropertyLength

Gets the length in bytes of the Value property. This property is read-only.

System_CAPS_pubpropertyValue

Gets the value of the SqlBinary structure. This property is read-only.

NameDescription
System_CAPS_pubmethodSystem_CAPS_staticAdd(SqlBinary, SqlBinary)

Concatenates two specified SqlBinary values to create a new SqlBinary structure.

System_CAPS_pubmethodCompareTo(Object)

Compares this SqlBinary object to the supplied object and returns an indication of their relative values.

System_CAPS_pubmethodCompareTo(SqlBinary)

Compares this SqlBinary object to the supplied SqlBinary object and returns an indication of their relative values.

System_CAPS_pubmethodSystem_CAPS_staticConcat(SqlBinary, SqlBinary)

Concatenates two SqlBinary structures to create a new SqlBinary structure.

System_CAPS_pubmethodEquals(Object)

Compares the supplied object parameter to the Value property of the SqlBinary object.(Overrides ValueType.Equals(Object).)

System_CAPS_pubmethodSystem_CAPS_staticEquals(SqlBinary, SqlBinary)

Compares two SqlBinary structures to determine whether they are equal.

System_CAPS_pubmethodGetHashCode()

Returns the hash code for this SqlBinary structure.(Overrides ValueType.GetHashCode().)

System_CAPS_pubmethodGetType()

Gets the Type of the current instance.(Inherited from Object.)

System_CAPS_pubmethodSystem_CAPS_staticGetXsdType(XmlSchemaSet)

Returns the XML Schema definition language (XSD) of the specified XmlSchemaSet.

System_CAPS_pubmethodSystem_CAPS_staticGreaterThan(SqlBinary, SqlBinary)

Compares two SqlBinary structures to determine whether the first is greater than the second.

System_CAPS_pubmethodSystem_CAPS_staticGreaterThanOrEqual(SqlBinary, SqlBinary)

Compares two SqlBinary structures to determine whether the first is greater than or equal to the second.

System_CAPS_pubmethodSystem_CAPS_staticLessThan(SqlBinary, SqlBinary)

Compares two SqlBinary structures to determine whether the first is less than the second.

System_CAPS_pubmethodSystem_CAPS_staticLessThanOrEqual(SqlBinary, SqlBinary)

Compares two SqlBinary structures to determine whether the first is less than or equal to the second.

System_CAPS_pubmethodSystem_CAPS_staticNotEquals(SqlBinary, SqlBinary)

Compares two SqlBinary structures to determine whether they are not equal.

System_CAPS_pubmethodToSqlGuid()

Converts this instance of SqlBinary to SqlGuid.

System_CAPS_pubmethodToString()

Converts this SqlBinary object to a string.(Overrides ValueType.ToString().)

NameDescription
System_CAPS_pubfieldSystem_CAPS_staticNull

Represents a DBNull that can be assigned to this instance of the SqlBinary structure.

NameDescription
System_CAPS_puboperatorSystem_CAPS_staticAddition(SqlBinary, SqlBinary)

Concatenates the two SqlBinary parameters to create a new SqlBinary structure.

System_CAPS_puboperatorSystem_CAPS_staticEquality(SqlBinary, SqlBinary)

Compares two SqlBinary structures to determine whether they are equal.

System_CAPS_puboperatorSystem_CAPS_staticExplicit(SqlBinary to Byte[])

Converts a SqlBinary structure to a Byte array.

System_CAPS_puboperatorSystem_CAPS_staticExplicit(SqlGuid to SqlBinary)

Converts a SqlGuid structure to a SqlBinary structure.

System_CAPS_puboperatorSystem_CAPS_staticGreaterThan(SqlBinary, SqlBinary)

Compares two SqlBinary structures to determine whether the first is greater than the second.

System_CAPS_puboperatorSystem_CAPS_staticGreaterThanOrEqual(SqlBinary, SqlBinary)

Compares two SqlBinary structues to determine whether the first is greater than or equal to the second.

System_CAPS_puboperatorSystem_CAPS_staticImplicit(Byte[] to SqlBinary)

Converts an array of bytes to a SqlBinary structure.

System_CAPS_puboperatorSystem_CAPS_staticInequality(SqlBinary, SqlBinary)

Compares two SqlBinary structures to determine whether they are not equal.

System_CAPS_puboperatorSystem_CAPS_staticLessThan(SqlBinary, SqlBinary)

Compares two SqlBinary structures to determine whether the first is less than the second.

System_CAPS_puboperatorSystem_CAPS_staticLessThanOrEqual(SqlBinary, SqlBinary)

Compares two SqlBinary structures to determine whether the first is less than or equal to the second.

NameDescription
System_CAPS_pubinterfaceSystem_CAPS_privmethodIXmlSerializable.GetSchema()

For a description of this member, see GetSchema.

System_CAPS_pubinterfaceSystem_CAPS_privmethodIXmlSerializable.ReadXml(XmlReader)

For a description of this member, see ReadXml.

System_CAPS_pubinterfaceSystem_CAPS_privmethodIXmlSerializable.WriteXml(XmlWriter)

For a description of this member, see WriteXml.

.NET Framework
Available since 1.1

Any public static ( Shared in Visual Basic) members of this type are thread safe. Any instance members are not guaranteed to be thread safe.

Return to top
Show: