ADO.NET in a Nutshell

A structure that represents a 32-bit signed integer that can contain a value ranging from -2 ³¹ (-2,147,483,648) to 2 ^31-1 (2,147,483,647). It maps to the SQL Server int data type.

public struct SqlInt32 : INullable, IComparable { // Public Constructors public SqlInt32 ( int value ); // Public Static Fields public static readonly SqlInt32 MaxValue ; // =2147483647 public static readonly SqlInt32 MinValue ; // =-2147483648 public static readonly SqlInt32 Null ; // =Null public static readonly SqlInt32 Zero ; // =0 // Public Instance Properties public bool IsNull {get; } // implements INullable public int Value {get; } // Public Static Methods public static SqlInt32 Add ( SqlInt32 x , SqlInt32 y ); public static SqlInt32 BitwiseAnd (SqlInt32 x , SqlInt32 y ); public static SqlInt32 BitwiseOr ( SqlInt32 x , SqlInt32 y ); public static SqlInt32 Divide ( SqlInt32 x , SqlInt32 y ); public static SqlBoolean Equals ( SqlInt32 x , SqlInt32 y ); public static SqlBoolean GreaterThan (SqlInt32 x , SqlInt32 y ); public static SqlBoolean GreaterThanOrEqual (SqlInt32 x , SqlInt32 y ); public static SqlBoolean LessThan (SqlInt32 x , SqlInt32 y ); public static SqlBoolean LessThanOrEqual (SqlInt32 x , SqlInt32 y ); public static SqlInt32 Mod ( SqlInt32 x , SqlInt32 y ); public static SqlInt32 Multiply ( SqlInt32 x , SqlInt32 y ); public static SqlBoolean NotEquals (SqlInt32 x , SqlInt32 y ); public static SqlInt32 OnesComplement ( SqlInt32 x ); public static SqlInt32 operator & (SqlInt32 x , SqlInt32 y ); public static SqlInt32 operator (SqlInt32 x , SqlInt32 y ); public static SqlInt32 operator ^ (SqlInt32 x , SqlInt32 y ); public static SqlInt32 operator ~ (SqlInt32 x ); public static SqlInt32 Parse ( string s ); public static SqlInt32 Subtract ( SqlInt32 x , SqlInt32 y ); public static SqlInt32 Xor ( SqlInt32 x , SqlInt32 y ); public static SqlInt32 operator % (SqlInt32 x , SqlInt32 y ); public static SqlInt32 operator * (SqlInt32 x , SqlInt32 y ); public static SqlInt32 operator / (SqlInt32 x , SqlInt32 y ); public static SqlInt32 operator - ( SqlInt32 x ); public static SqlInt32 operator - (SqlInt32 x , SqlInt32 y ); public static SqlInt32 operator + (SqlInt32 x , SqlInt32 y ); public static SqlBoolean operator != (SqlInt32 x , SqlInt32 y ); public static SqlBoolean operator < (SqlInt32 x , SqlInt32 y ); public static SqlBoolean operator <= (SqlInt32 x , SqlInt32 y ); public static SqlBoolean operator == (SqlInt32 x , SqlInt32 y ); public static SqlBoolean operator > (SqlInt32 x , SqlInt32 y ); public static SqlBoolean operator >= (SqlInt32 x , SqlInt32 y ); public static explicit operator int ( SqlInt32 x ); public static explicit operator SqlInt32 ( SqlBoolean x ); public static explicit operator SqlInt32 ( SqlDecimal x ); public static explicit operator SqlInt32 ( SqlDouble x ); public static explicit operator SqlInt32 ( SqlInt64 x ); public static explicit operator SqlInt32 ( SqlMoney x ); public static explicit operator SqlInt32 ( SqlSingle x ); public static explicit operator SqlInt32 ( SqlString x ); public static implicit operator SqlInt32 ( int x ); public static implicit operator SqlInt32 ( SqlByte x ); public static implicit operator SqlInt32 ( SqlInt16 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 SqlBoolean ToSqlBoolean ( ); public SqlByte ToSqlByte ( ); public SqlDecimal ToSqlDecimal ( ); public SqlDouble ToSqlDouble ( ); public SqlInt16 ToSqlInt16 ( ); public SqlInt64 ToSqlInt64 ( ); public SqlMoney ToSqlMoney ( ); public SqlSingle ToSqlSingle ( ); public SqlString ToSqlString ( ); public override string ToString ( ); // overrides ValueType }

Hierarchy

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

Returned By

System.Data.SqlClient.SqlDataReader.GetSqlInt32( ) , SqlBoolean.ToSqlInt32( ) , SqlByte.ToSqlInt32( ) , SqlDecimal.{Sign( ) , ToSqlInt32( )} , SqlDouble.ToSqlInt32( ) , SqlInt16.ToSqlInt32( ) , SqlInt64.ToSqlInt32( ) , SqlMoney.ToSqlInt32( ) , SqlSingle.ToSqlInt32( ) , SqlString.ToSqlInt32( )