[ Team LiB ] Previous Section Next Section

SqlBinary

System.Data.SqlTypes (system.data.dll) struct

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 figs/U2192.gif System.ValueType figs/U2192.gif SqlBinary(INullable, System.IComparable)

Returned By

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

    [ Team LiB ] Previous Section Next Section