ADO.NET in a Nutshell

A structure that represents a variable-length stream of bytes, which corresponds to the SQL Server binary or varbinary data types. You can retrieve the number of bytes using the Length property.

public struct SqlBinary : INullable, IComparable { // Public Constructors public SqlBinary ( byte[ ] value ); // Public Static Fields public static readonly SqlBinary Null ; // =Null // Public Instance Properties public bool IsNull {get; } // implements INullable public int Length {get; } public byte this[int index ] {get;} public byte[ ] Value {get; } // Public Static Methods public static SqlBinary Concat ( SqlBinary x , SqlBinary y ); public static SqlBoolean Equals (SqlBinary x , SqlBinary y ); public static SqlBoolean GreaterThan (SqlBinary x , SqlBinary y ); public static SqlBoolean GreaterThanOrEqual (SqlBinary x , SqlBinary y ); public static SqlBoolean LessThan (SqlBinary x , SqlBinary y ); public static SqlBoolean LessThanOrEqual (SqlBinary x , SqlBinary y ); public static SqlBoolean NotEquals (SqlBinary x , SqlBinary y ); public static SqlBinary operator + (SqlBinary x , SqlBinary y ); public static SqlBoolean operator != (SqlBinary x , SqlBinary y ); public static SqlBoolean operator < (SqlBinary x , SqlBinary y ); public static SqlBoolean operator <= (SqlBinary x , SqlBinary y ); public static SqlBoolean operator == (SqlBinary x , SqlBinary y ); public static SqlBoolean operator > (SqlBinary x , SqlBinary y ); public static SqlBoolean operator >= (SqlBinary x , SqlBinary y ); public static explicit operator Byte ( SqlBinary x ); public static explicit operator SqlBinary ( SqlGuid x ); public static implicit operator SqlBinary ( byte[ ] x ); // Public Instance Methods public int CompareTo ( object value ); // implements IComparable public override bool Equals ( object value ); // overrides ValueType public override int GetHashCode ( ); // overrides ValueType public SqlGuid ToSqlGuid ( ); public override string ToString ( ); // overrides ValueType }

Hierarchy

System.Object System.ValueType SqlBinary(INullable, System.IComparable)

Returned By

System.Data.SqlClient.SqlDataReader.GetSqlBinary( ) , SqlGuid.ToSqlBinary( )