System.Data.SqlTypes.SqlString

SqlString

public struct SqlString : INullable, IComparable

Represents a variable-length stream of characters to be stored in or retrieved from the database. SqlString has a different underlying data structure from its corresponding .NET Framework String data type.

public static readonly int BinarySort

Specifies that sorts should be based on a characters numeric value instead of its alphabetical value.

public static readonly int BinarySort2

Specifies that sorts should be based on a character's numeric value instead of its alphabetical value.

public static readonly int IgnoreCase

Specifies that SqlString comparisons should ignore case.

public static readonly int IgnoreKanaType

Specifies that the string comparison must ignore the Kana type.

public static readonly int IgnoreNonSpace

Specifies that the string comparison must ignore non-space combining characters, such as diacritics.

public static readonly int IgnoreWidth

Specifies that the string comparison must ignore the character width.

public static readonly SqlString Null

Represents a DBNull that can be assigned to this instance of the SqlString structure.

public CompareInfo CompareInfo { get; }

Gets the CompareInfo object that defines how string comparisons should be performed for this SqlString structure.

public CultureInfo CultureInfo { get; }

Gets the CultureInfo structure that represents information about the culture of this SqlString object.

public bool IsNull { get; }

Indicates whether this SqlString structure is null.

public int LCID { get; }

Specifies the geographical locale and language for the SqlString structure.

public SqlCompareOptions SqlCompareOptions { get; }

A combination of one or more of the SqlCompareOptions enumeration values that represent the way in which this SqlString should be compared to other SqlString structures.

public string Value { get; }

Gets the string that is stored in this SqlString structure. This property is read-only.

public SqlString(int lcid, SqlCompareOptions compareOptions, byte[] data)

Initializes a new instance of the SqlString structure using the specified locale id, compare options, and data.

public SqlString(int lcid, SqlCompareOptions compareOptions, byte[] data, bool fUnicode)

Initializes a new instance of the SqlString class.

public SqlString(int lcid, SqlCompareOptions compareOptions, byte[] data, int index, int count)

Initializes a new instance of the SqlString class.

public SqlString(int lcid, SqlCompareOptions compareOptions, byte[] data, int index, int count, bool fUnicode)

Initializes a new instance of the SqlString class.

public SqlString(string data)

Initializes a new instance of the SqlString structure using the specified string.

public SqlString(string data, int lcid)

Initializes a new instance of the SqlString structure using the specified string and locale id values.

public SqlString(string data, int lcid, SqlCompareOptions compareOptions)

Initializes a new instance of the SqlString structure using the specified string, locale id, and compare option values.

public static SqlString Add(SqlString x, SqlString y)

Concatenates two specified SqlString values to create a new SqlString structure.

public static CompareOptions CompareOptionsFromSqlCompareOptions(SqlCompareOptions compareOptions)

Gets the CompareOptions enumeration equilvalent of the specified SqlCompareOptions value.

public static SqlString Concat(SqlString x, SqlString y)

Concatenates the two specified SqlString structures.

public static SqlBoolean Equals(SqlString x, SqlString y)

Performs a logical comparison of the two SqlString operands to determine whether they are equal.

public static SqlBoolean GreaterThan(SqlString x, SqlString y)

Performs a logical comparison of the two SqlString operands to determine whether the first is greater than the second.

public static SqlBoolean GreaterThanOrEqual(SqlString x, SqlString y)

Performs a logical comparison of the two SqlString operands to determine whether the first is greater than or equal to the second.

public static SqlBoolean LessThan(SqlString x, SqlString y)

Performs a logical comparison of the two SqlString operands to determine whether the first is less than the second.

public static SqlBoolean LessThanOrEqual(SqlString x, SqlString y)

Performs a logical comparison of the two SqlString operands to determine whether the first is less than or equal to the second.

public static SqlBoolean NotEquals(SqlString x, SqlString y)

Performs a logical comparison of the two SqlString operands to determine whether they are not equal.

public static SqlString op_Addition(SqlString x, SqlString y)

Concatenates the two specified SqlString structures.

public static SqlBoolean op_Equality(SqlString x, SqlString y)

Performs a logical comparison of the two SqlString operands to determine whether they are equal.

public static SqlString op_Explicit(SqlBoolean x)

Converts the specified SqlBoolean structure to SqlString.

public static SqlString op_Explicit(SqlByte x)

Converts the specified SqlByte structure to SqlString.

public static SqlString op_Explicit(SqlDateTime x)

Converts the specified SqlDateTime parameter to SqlString.

public static SqlString op_Explicit(SqlDecimal x)

Converts the specified SqlDecimal parameter to SqlString.

public static SqlString op_Explicit(SqlDouble x)

Converts the specified SqlDouble parameter to SqlString.

public static SqlString op_Explicit(SqlGuid x)

Converts the specified SqlGuid parameter to SqlString.

public static SqlString op_Explicit(SqlInt16 x)

Converts the specified SqlInt16 parameter to SqlString.

public static SqlString op_Explicit(SqlInt32 x)

Converts the specified SqlInt32 parameter to SqlString.

public static SqlString op_Explicit(SqlInt64 x)

Converts the specified SqlInt64 parameter to SqlString.

public static SqlString op_Explicit(SqlMoney x)

Converts the specified SqlMoney parameter to SqlString.

public static SqlString op_Explicit(SqlSingle x)

Converts the specified SqlSingle parameter to SqlString.

public static string op_Explicit(SqlString x)

Converts a SqlString to a String

public static SqlBoolean op_GreaterThan(SqlString x, SqlString y)

Performs a logical comparison of the two SqlString operands to determine whether the first is greater than the second.

public static SqlBoolean op_GreaterThanOrEqual(SqlString x, SqlString y)

Performs a logical comparison of the two SqlString operands to determine whether the first is greater than or equal to the second.

public static SqlString op_Implicit(string x)

Converts the String parameter to a SqlString.

public static SqlBoolean op_Inequality(SqlString x, SqlString y)

Performs a logical comparison of the two SqlString operands to determine whether they are not equal.

public static SqlBoolean op_LessThan(SqlString x, SqlString y)

Performs a logical comparison of the two SqlString operands to determine whether the first is less than the second.

public static SqlBoolean op_LessThanOrEqual(SqlString x, SqlString y)

Performs a logical comparison of the two SqlString operands to determine whether the first is less than or equal to the second.

public SqlString Clone()

Creates a copy of this SqlString object.

public int CompareTo(SqlString value)

Compares this SqlString instance to the supplied SqlString and returns an indication of their relative values.

public int CompareTo(object value)

Compares this SqlString object to the supplied Object and returns an indication of their relative values.

public byte[] GetNonUnicodeBytes()

Gets an array of bytes, that contains the contents of the SqlString in ANSI format.

public byte[] GetUnicodeBytes()

Gets an array of bytes, that contains the contents of the SqlString in Unicode format.

public SqlBoolean ToSqlBoolean()

Converts this SqlString structure to SqlBoolean.

public SqlByte ToSqlByte()

Converts this SqlString structure to SqlByte.

public SqlDateTime ToSqlDateTime()

Converts this SqlString structure to SqlDateTime.

public SqlDecimal ToSqlDecimal()

Converts this SqlString structure to SqlDecimal.

public SqlDouble ToSqlDouble()

Converts this SqlString structure to SqlDouble.

public SqlGuid ToSqlGuid()

Converts this SqlString structure to SqlGuid.

public SqlInt16 ToSqlInt16()

Converts this SqlString structure to SqlInt16.

public SqlInt32 ToSqlInt32()

Converts this SqlString structure to SqlInt32.

public SqlInt64 ToSqlInt64()

Converts this SqlString structure to SqlInt64.

public SqlMoney ToSqlMoney()

Converts this SqlString structure to SqlMoney.

public SqlSingle ToSqlSingle()

Converts this SqlString structure to SqlSingle.