Name

SqlGuid

Synopsis

A structure that represents a GUID, which maps to the SQL Server uniqueidentifier data type. Any generated GUID is statistically unique. A GUID converts to strings in the format xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx, in which each x is a hexadecimal digit in the range 0-9 or A-F, e.g., 6F9619FF-8B86-D011-B42D-00C04FC964FF.

public struct SqlGuid : INullable, IComparable {

// Public Constructors

   public SqlGuid(byte[ ] value);  

   public SqlGuid(Guid g);  

   public SqlGuid(int a, short b, short c, byte d, byte e, byte f, byte g, byte h, byte i, byte j, byte k);

   public SqlGuid(string s);  

// Public Static Fields

   public static readonly SqlGuid Null;                        // =Null

                  // Public Instance Properties

   public bool IsNull{get; }                                   // implements INullable

   public Guid Value{get; } 

// Public Static Methods

   public static SqlBoolean Equals(SqlGuid x, SqlGuid y);  

   public static SqlBoolean GreaterThan(SqlGuid x, SqlGuid y);

   public static SqlBoolean GreaterThanOrEqual(SqlGuid x, SqlGuid y);

   public static SqlBoolean LessThan(SqlGuid x, SqlGuid y);  

   public static SqlBoolean LessThanOrEqual(SqlGuid x,  SqlGuid y); 

   public static SqlBoolean NotEquals(SqlGuid x, SqlGuid y);  

   public static SqlGuid Parse(string s);  

   public static SqlBoolean operator !=(SqlGuid x, SqlGuid y); 

   public static SqlBoolean operator <(SqlGuid x, SqlGuid y);

   public static SqlBoolean operator <=(SqlGuid x, SqlGuid y);

   public static SqlBoolean operator ==(SqlGuid x, SqlGuid y);

   public static SqlBoolean operator >(SqlGuid x, SqlGuid y);

   public static SqlBoolean operator >=(SqlGuid x, SqlGuid y);

   public static explicit operator Guid(SqlGuid x);  

   public static explicit operator SqlGuid(SqlBinary x);  

   public static explicit operator SqlGuid(SqlString x);  

   public static implicit operator SqlGuid(Guid 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 byte[  ] ToByteArray( );  

   public SqlBinary ToSqlBinary( );  

   public SqlString ToSqlString( );  

   public override string ToString( );                          // overrides ValueType

}

Hierarchy

System.Object → System.ValueType → SqlGuid(INullable, System.IComparable)

Returned By

System.Data.SqlClient.SqlDataReader.GetSqlGuid( ), SqlBinary.ToSqlGuid( ), SqlString.ToSqlGuid( )