Note

Access to this page requires authorization. You can try signing in or .

Access to this page requires authorization. You can try .

SqlBinary Struct

Definition

Namespace:
System.Data.SqlTypes
Assemblies:
netstandard.dll, System.Data.Common.dll
Assembly:
System.Data.SqlClient.dll
Assembly:
System.Data.Common.dll
Assembly:
System.Data.dll
Assembly:
netstandard.dll
Source:
SQLBinary.cs
Source:
SQLBinary.cs
Source:
SQLBinary.cs
Source:
SQLBinary.cs
Source:
SQLBinary.cs

Important

Some information relates to prerelease product that may be substantially modified before it’s released. Microsoft makes no warranties, express or implied, with respect to the information provided here.

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

public value class SqlBinary : IComparable, IEquatable<System::Data::SqlTypes::SqlBinary>, System::Data::SqlTypes::INullable, System::Xml::Serialization::IXmlSerializable
public value class SqlBinary : IComparable, System::Data::SqlTypes::INullable, System::Xml::Serialization::IXmlSerializable
public value class SqlBinary : IComparable, System::Data::SqlTypes::INullable
public struct SqlBinary : IComparable, IEquatable<System.Data.SqlTypes.SqlBinary>, System.Data.SqlTypes.INullable, System.Xml.Serialization.IXmlSerializable
public struct SqlBinary : IComparable, System.Data.SqlTypes.INullable, System.Xml.Serialization.IXmlSerializable
public struct SqlBinary : IComparable, System.Data.SqlTypes.INullable
[System.Serializable]
public struct SqlBinary : IComparable, System.Data.SqlTypes.INullable, System.Xml.Serialization.IXmlSerializable
type SqlBinary = struct
 interface INullable
 interface IXmlSerializable
type SqlBinary = struct
 interface INullable
[<System.Serializable>]
type SqlBinary = struct
 interface INullable
 interface IXmlSerializable
Public Structure SqlBinary
Implements IComparable, IEquatable(Of SqlBinary), INullable, IXmlSerializable
Public Structure SqlBinary
Implements IComparable, INullable, IXmlSerializable
Public Structure SqlBinary
Implements IComparable, INullable
Inheritance
SqlBinary
Attributes
Implements

Constructors

Name Description
SqlBinary(Byte[])

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

Fields

Name Description
Null

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

Properties

Name Description
IsNull

Indicates whether this SqlBinary structure is null. This property is read-only.
Item[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.
Length

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

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

Methods

Name Description
Add(SqlBinary, SqlBinary)

Concatenates two specified SqlBinary values to create a new SqlBinary structure.
CompareTo(Object)

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

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

Concatenates two SqlBinary structures to create a new SqlBinary structure.
Equals(Object)

Compares the supplied object parameter to the Value property of the SqlBinary object.
Equals(SqlBinary, SqlBinary)

Compares two SqlBinary structures to determine whether they are equal.
Equals(SqlBinary)

Indicates whether the current instance is equal to another instance of the same type.
GetHashCode()

Returns the hash code for this SqlBinary structure.
GetXsdType(XmlSchemaSet)

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

Compares two SqlBinary structures to determine whether the first is greater than the second.
GreaterThanOrEqual(SqlBinary, SqlBinary)

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

Compares two SqlBinary structures to determine whether the first is less than the second.
LessThanOrEqual(SqlBinary, SqlBinary)

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

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

Converts this instance of SqlBinary to SqlGuid.
ToString()

Converts this SqlBinary object to a string.
WrapBytes(Byte[])

Converts an array of bytes into a SqlBinary structure.

Operators

Name Description
Addition(SqlBinary, SqlBinary)

Concatenates the two SqlBinary parameters to create a new SqlBinary structure.
Equality(SqlBinary, SqlBinary)

Compares two SqlBinary structures to determine whether they are equal.
Explicit(SqlBinary to Byte[])

Converts a SqlBinary structure to a Byte array.
Explicit(SqlGuid to SqlBinary)

Converts a SqlGuid structure to a SqlBinary structure.
GreaterThan(SqlBinary, SqlBinary)

Compares two SqlBinary structures to determine whether the first is greater than the second.
GreaterThanOrEqual(SqlBinary, SqlBinary)

Compares two SqlBinary structures to determine whether the first is greater than or equal to the second.
Implicit(Byte[] to SqlBinary)

Converts an array of bytes to a SqlBinary structure.
Inequality(SqlBinary, SqlBinary)

Compares two SqlBinary structures to determine whether they are not equal.
LessThan(SqlBinary, SqlBinary)

Compares two SqlBinary structures to determine whether the first is less than the second.
LessThanOrEqual(SqlBinary, SqlBinary)

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

Explicit Interface Implementations

Name Description
IXmlSerializable.GetSchema()

For a description of this member, see GetSchema().
IXmlSerializable.ReadXml(XmlReader)

For a description of this member, see ReadXml(XmlReader).
IXmlSerializable.WriteXml(XmlWriter)

For a description of this member, see WriteXml(XmlWriter).

Applies to

See also

Feedback

Was this page helpful?