''SqlInt32'' '''

SqlInt32

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

A structure that represents a 32-bit signed integer that can contain a value ranging from -231 (-2,147,483,648) to 231-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 figs/U2192.gif System.ValueType figs/U2192.gif 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( )



    Part I: ADO.NET Tutorial
    Part II: ADO.NET Core Classes
    Part III: API Quick Reference
    Chapter 34. The System.Data Namespace