SqlBoolean Struct

Reference

Definition

Namespace:: System.Data.SqlTypes

Assembly:: System.Data.Common.dll

Assembly:: System.Data.SqlClient.dll

Assembly:: System.Data.dll

Assembly:: netstandard.dll

Source:: SQLBoolean.cs

Source:: SQLBoolean.cs

Source:: SQLBoolean.cs

Important

Some information relates to prerelease product that may be substantially modified before it’s released. Microsoft makes no warranties, express or implied, with respect to the information provided here.

Represents an integer value that is either 1 or 0 to be stored in or retrieved from a database.

public value class SqlBoolean : IComparable, System::Data::SqlTypes::INullable, System::Xml::Serialization::IXmlSerializable

public value class SqlBoolean : IComparable, IEquatable<System::Data::SqlTypes::SqlBoolean>, System::Data::SqlTypes::INullable, System::Xml::Serialization::IXmlSerializable

public value class SqlBoolean : IComparable, System::Data::SqlTypes::INullable

public struct SqlBoolean : IComparable, System.Data.SqlTypes.INullable, System.Xml.Serialization.IXmlSerializable

public struct SqlBoolean : IComparable, IEquatable<System.Data.SqlTypes.SqlBoolean>, System.Data.SqlTypes.INullable, System.Xml.Serialization.IXmlSerializable

public struct SqlBoolean : IComparable, System.Data.SqlTypes.INullable

[System.Serializable]
public struct SqlBoolean : IComparable, System.Data.SqlTypes.INullable, System.Xml.Serialization.IXmlSerializable

type SqlBoolean = struct
    interface INullable
    interface IXmlSerializable

type SqlBoolean = struct
    interface INullable

[<System.Serializable>]
type SqlBoolean = struct
    interface INullable
    interface IXmlSerializable

Public Structure SqlBoolean
Implements IComparable, INullable, IXmlSerializable

Public Structure SqlBoolean
Implements IComparable, IEquatable(Of SqlBoolean), INullable, IXmlSerializable

Public Structure SqlBoolean
Implements IComparable, INullable

Inheritance: Object

ValueType
SqlBoolean

Attributes: SerializableAttribute

Implements: INullable IComparable IXmlSerializable IEquatable<SqlBoolean>

Remarks

Any non-zero value is interpreted as 1.

The key difference between a SqlBoolean structure and a standard Boolean value is that, where a standard Boolean has two possible values, true and false, a SqlBoolean structure has three possible values, True, False, or Null.

Constructors

SqlBoolean(Boolean)	Initializes a new instance of the SqlBoolean structure using the supplied Boolean value.
SqlBoolean(Int32)	Initializes a new instance of the SqlBoolean structure using the specified integer value.

Fields

False	Represents a false value that can be assigned to the Value property of an instance of the SqlBoolean structure.
Null	Represents DBNull that can be assigned to this instance of the SqlBoolean structure.
One	Represents a one value that can be assigned to the ByteValue property of an instance of the SqlBoolean structure.
True	Represents a true value that can be assigned to the Value property of an instance of the SqlBoolean structure.
Zero	Represents a zero value that can be assigned to the ByteValue property of an instance of the SqlBoolean structure.

Properties

ByteValue	Gets the value of the SqlBoolean structure as a byte.
IsFalse	Indicates whether the current Value is False.
IsNull	Indicates whether this SqlBoolean structure is null.
IsTrue	Gets a value that indicates whether the current Value is True.
Value	Gets the SqlBoolean structure's value. This property is read-only.

Methods

And(SqlBoolean, SqlBoolean)	Computes the bitwise AND operation of two specified SqlBoolean structures.
CompareTo(Object)	Compares this SqlBoolean structure to a specified object and returns an indication of their relative values.
CompareTo(SqlBoolean)	Compares this SqlBoolean object to the supplied SqlBoolean object and returns an indication of their relative values.
Equals(Object)	Compares the supplied object parameter to the SqlBoolean.
Equals(SqlBoolean, SqlBoolean)	Compares two SqlBoolean structures to determine whether they are equal.
Equals(SqlBoolean)	Indicates whether the current instance is equal to another instance of the same type.
GetHashCode()	Returns the hash code for this instance.
GetXsdType(XmlSchemaSet)	Returns the XML Schema definition language (XSD) of the specified XmlSchemaSet.
GreaterThan(SqlBoolean, SqlBoolean)	Compares two instances of SqlBoolean to determine whether the first is greater than the second.
GreaterThanOrEquals(SqlBoolean, SqlBoolean)	Compares two instances of SqlBoolean to determine whether the first is greater than or equal to the second.
LessThan(SqlBoolean, SqlBoolean)	Compares two instances of SqlBoolean to determine whether the first is less than the second.
LessThanOrEquals(SqlBoolean, SqlBoolean)	Compares two instances of SqlBoolean to determine whether the first is less than or equal to the second.
NotEquals(SqlBoolean, SqlBoolean)	Compares two instances of SqlBoolean for equality.
OnesComplement(SqlBoolean)	Performs a one's complement operation on the supplied SqlBoolean structures.
Or(SqlBoolean, SqlBoolean)	Performs a bitwise OR operation on the two specified SqlBoolean structures.
Parse(String)	Converts the specified String representation of a logical value to its SqlBoolean equivalent.
ToSqlByte()	Converts this SqlBoolean structure to SqlByte.
ToSqlDecimal()	Converts this SqlBoolean structure to SqlDecimal.
ToSqlDouble()	Converts this SqlBoolean structure to SqlDouble.
ToSqlInt16()	Converts this SqlBoolean structure to SqlInt16.
ToSqlInt32()	Converts this SqlBoolean structure to SqlInt32.
ToSqlInt64()	Converts this SqlBoolean structure to SqlInt64.
ToSqlMoney()	Converts this SqlBoolean structure to SqlMoney.
ToSqlSingle()	Converts this SqlBoolean structure to SqlSingle.
ToSqlString()	Converts this SqlBoolean structure to SqlString.
ToString()	Converts this SqlBoolean structure to a string.
Xor(SqlBoolean, SqlBoolean)	Performs a bitwise exclusive-OR operation on the supplied parameters.

Operators

BitwiseAnd(SqlBoolean, SqlBoolean)	Computes the bitwise AND operation of two specified SqlBoolean structures.
BitwiseOr(SqlBoolean, SqlBoolean)	Computes the bitwise OR of its operands.
Equality(SqlBoolean, SqlBoolean)	Compares two instances of SqlBoolean for equality.
ExclusiveOr(SqlBoolean, SqlBoolean)	Performs a bitwise exclusive-OR (XOR) operation on the supplied parameters.
Explicit(SqlBoolean to Boolean)	Converts a SqlBoolean to a Boolean.
Explicit(SqlByte to SqlBoolean)	Converts the SqlByte parameter to a SqlBoolean structure.
Explicit(SqlDecimal to SqlBoolean)	Converts the SqlDecimal parameter to a SqlBoolean structure.
Explicit(SqlDouble to SqlBoolean)	Converts the SqlDouble parameter to a SqlBoolean structure.
Explicit(SqlInt16 to SqlBoolean)	Converts the SqlInt16 parameter to a SqlBoolean structure.
Explicit(SqlInt32 to SqlBoolean)	Converts the SqlInt32 parameter to a SqlBoolean structure.
Explicit(SqlInt64 to SqlBoolean)	Converts the SqlInt64 parameter to a SqlBoolean structure.
Explicit(SqlMoney to SqlBoolean)	Converts the SqlMoney parameter to a SqlBoolean structure.
Explicit(SqlSingle to SqlBoolean)	Converts the SqlSingle parameter to a SqlBoolean structure.
Explicit(SqlString to SqlBoolean)	Converts the SqlString parameter to a SqlBoolean structure.
False(SqlBoolean)	The false operator can be used to test the Value of the SqlBoolean to determine whether it is false.
GreaterThan(SqlBoolean, SqlBoolean)	Compares two SqlBoolean structures to determine whether the first is greater than the second.
GreaterThanOrEqual(SqlBoolean, SqlBoolean)	Compares two SqlBoolean structures to determine whether the first is greater than or equal to the second.
Implicit(Boolean to SqlBoolean)	Converts the supplied byte value to a SqlBoolean.
Inequality(SqlBoolean, SqlBoolean)	Compares two instances of SqlBoolean to determine whether they are not equal.
LessThan(SqlBoolean, SqlBoolean)	Compares two instances of SqlBoolean to determine whether the first is less than the second.
LessThanOrEqual(SqlBoolean, SqlBoolean)	Compares two instances of SqlBoolean to determine whether the first is less than or equal to the second.
LogicalNot(SqlBoolean)	Performs a NOT operation on a SqlBoolean.
OnesComplement(SqlBoolean)	Performs a one's complement operation on the supplied SqlBoolean structures.
True(SqlBoolean)	The true operator can be used to test the Value of the SqlBoolean to determine whether it is true.

Explicit Interface Implementations

IXmlSerializable.GetSchema()	This member supports the .NET Framework infrastructure and is not intended to be used directly from your code.
IXmlSerializable.ReadXml(XmlReader)	This member supports the .NET Framework infrastructure and is not intended to be used directly from your code.
IXmlSerializable.WriteXml(XmlWriter)	This member supports the .NET Framework infrastructure and is not intended to be used directly from your code.

Applies to

Jaa