Home Library Learn Samples Downloads Support Community Forums
This topic has not yet been rated - Rate this topic

SqlBinary Structure

.NET Framework 4.5

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)
C#
C++
F#
VB
Copy 
[SerializableAttribute]
public struct SqlBinary : INullable, IComparable, 
	IXmlSerializable

The SqlBinary type exposes the following members.

  NameDescription
Public methodSupported by the XNA FrameworkSqlBinaryInitializes a new instance of the SqlBinary structure, setting the Value property to the contents of the supplied byte array.
Top
  NameDescription
Public propertySupported by the XNA FrameworkIsNullIndicates whether this SqlBinary structure is null. This property is read-only.
Public propertySupported by the XNA FrameworkItemGets 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.
Public propertySupported by the XNA FrameworkLengthGets the length in bytes of the Value property. This property is read-only.
Public propertySupported by the XNA FrameworkValueGets the value of the SqlBinary structure. This property is read-only.
Top
  NameDescription
Public methodStatic memberSupported by the XNA FrameworkAddConcatenates two specified SqlBinary values to create a new SqlBinary structure.
Public methodSupported by the XNA FrameworkCompareTo(Object)Compares this SqlBinary object to the supplied object and returns an indication of their relative values.
Public methodSupported by the XNA FrameworkCompareTo(SqlBinary)Compares this SqlBinary object to the supplied SqlBinary object and returns an indication of their relative values.
Public methodStatic memberSupported by the XNA FrameworkConcatConcatenates two SqlBinary structures to create a new SqlBinary structure.
Public methodSupported by the XNA FrameworkEquals(Object)Compares the supplied object parameter to the Value property of the SqlBinary object. (Overrides ValueType.Equals(Object).)
Public methodStatic memberSupported by the XNA FrameworkEquals(SqlBinary, SqlBinary)Compares two SqlBinary structures to determine whether they are equal.
Public methodSupported by the XNA FrameworkGetHashCodeReturns the hash code for this SqlBinary structure. (Overrides ValueType.GetHashCode().)
Public methodSupported by the XNA FrameworkGetTypeGets the Type of the current instance. (Inherited from Object.)
Public methodStatic memberSupported by the XNA FrameworkGetXsdTypeReturns the XML Schema definition language (XSD) of the specified XmlSchemaSet.
Public methodStatic memberSupported by the XNA FrameworkGreaterThanCompares two SqlBinary structures to determine whether the first is greater than the second.
Public methodStatic memberSupported by the XNA FrameworkGreaterThanOrEqualCompares two SqlBinary structures to determine whether the first is greater than or equal to the second.
Public methodStatic memberSupported by the XNA FrameworkLessThanCompares two SqlBinary structures to determine whether the first is less than the second.
Public methodStatic memberSupported by the XNA FrameworkLessThanOrEqualCompares two SqlBinary structures to determine whether the first is less than or equal to the second.
Public methodStatic memberSupported by the XNA FrameworkNotEqualsCompares two SqlBinary structures to determine whether they are not equal.
Public methodSupported by the XNA FrameworkToSqlGuidConverts this instance of SqlBinary to SqlGuid.
Public methodSupported by the XNA FrameworkToStringConverts this SqlBinary object to a string. (Overrides ValueType.ToString().)
Top
  NameDescription
Public operatorStatic memberSupported by the XNA FrameworkAdditionConcatenates the two SqlBinary parameters to create a new SqlBinary structure.
Public operatorStatic memberSupported by the XNA FrameworkEqualityCompares two SqlBinary structures to determine whether they are equal.
Public operatorStatic memberSupported by the XNA FrameworkExplicit(SqlBinary to Byte[])Converts a SqlBinary structure to a Byte array.
Public operatorStatic memberSupported by the XNA FrameworkExplicit(SqlGuid to SqlBinary)Converts a SqlGuid structure to a SqlBinary structure.
Public operatorStatic memberSupported by the XNA FrameworkGreaterThanCompares two SqlBinary structures to determine whether the first is greater than the second.
Public operatorStatic memberSupported by the XNA FrameworkGreaterThanOrEqualCompares two SqlBinary structues to determine whether the first is greater than or equal to the second.
Public operatorStatic memberSupported by the XNA FrameworkImplicit(Byte[] to SqlBinary)Converts an array of bytes to a SqlBinary structure.
Public operatorStatic memberSupported by the XNA FrameworkInequalityCompares two SqlBinary structures to determine whether they are not equal.
Public operatorStatic memberSupported by the XNA FrameworkLessThanCompares two SqlBinary structures to determine whether the first is less than the second.
Public operatorStatic memberSupported by the XNA FrameworkLessThanOrEqualCompares two SqlBinary structures to determine whether the first is less than or equal to the second.
Top
  NameDescription
Public fieldStatic memberSupported by the XNA FrameworkNullRepresents a DBNull that can be assigned to this instance of the SqlBinary structure.
Top
  NameDescription
Explicit interface implemetationPrivate methodSupported by the XNA FrameworkIXmlSerializable.GetSchemaFor a description of this member, see GetSchema.
Explicit interface implemetationPrivate methodSupported by the XNA FrameworkIXmlSerializable.ReadXmlFor a description of this member, see ReadXml.
Explicit interface implemetationPrivate methodSupported by the XNA FrameworkIXmlSerializable.WriteXmlFor a description of this member, see WriteXml.
Top

.NET Framework

Supported in: 4.5, 4, 3.5, 3.0, 2.0, 1.1, 1.0

.NET Framework Client Profile

Supported in: 4, 3.5 SP1

Windows 8, Windows Server 2012, Windows 7, Windows Vista SP2, Windows Server 2008 (Server Core Role not supported), Windows Server 2008 R2 (Server Core Role supported with SP1 or later; Itanium not supported)

The .NET Framework does not support all versions of every platform. For a list of the supported versions, see .NET Framework System Requirements.

Any public static (Shared in Visual Basic) members of this type are thread safe. Any instance members are not guaranteed to be thread safe.
Did you find this helpful?
(1500 characters remaining)
© 2013 Microsoft. All rights reserved.