/**
* Compares two instances of SqlString to determine if the first is less than the second.
* @param x A SqlString instance
* @param y A SqlString instance
* @return A SqlBoolean that is True if the first instance is less than the second instance, otherwise False.
* If either instance of SqlString is null, the Value of the SqlBoolean will be Null.
*/
public static SqlBoolean LessThanOrEqual(SqlString x, SqlString y)
{
if (x.IsNull || y.IsNull)
{
return(SqlBoolean.Null);
}
if (x.CompareTo(y) <= 0)
{
return(SqlBoolean.True);
}
return(SqlBoolean.False);
}
/**
* Compares two instances of SqlString to determine if the first is greater than the second.
* @param x A SqlString instance
* @param y A SqlString instance
* @return A SqlBoolean that is True if the first instance is greater than the second instance, otherwise False.
* If either instance of SqlString is null, the Value of the SqlBoolean will be Null.
*/
public static SqlBoolean GreaterThan(SqlString x, SqlString y)
{
if (x.IsNull || y.IsNull)
{
return(SqlBoolean.Null);
}
if (x.CompareTo(y) > 0)
{
return(SqlBoolean.True);
}
return(SqlBoolean.False);
}
public static void SqlStringNullComparisonTest()
{
SqlString nullSqlString = new SqlString(null);
SqlString nonNullSqlString = new SqlString("abc ");
Assert.True(
(bool)(nullSqlString < nonNullSqlString
|| nonNullSqlString >= nullSqlString
|| nullSqlString.CompareTo(nonNullSqlString) < 0
|| nonNullSqlString.CompareTo(nullSqlString) >= 0),
"FAILED: (SqlString Null Comparison): Null SqlString not equal to null");
Assert.True((nullSqlString == null && nullSqlString.CompareTo(null) == 0).IsNull, "FAILED: (SqlString Null Comparison): Null SqlString not equal to null");
}
// Special characters matching test for default option (SqlCompareOptions.IgnoreCase | SqlCompareOptions.IgnoreKanaType | SqlCompareOptions.IgnoreWidth)
private static void SqlStringDefaultCompareOptionTest(int localeID)
{
SqlString str1;
SqlString str2;
for (int i = 0; i < s_specialMatchingString.GetLength(0); ++i)
{
// SqlString(string) creates instance with the default comparison options
str1 = new SqlString(s_specialMatchingString[i, 0], localeID);
str2 = new SqlString(s_specialMatchingString[i, 1], localeID);
// Per default option, each set contains two string which should be matched as equal per default option
Assert.True((bool)(str1 == str2), string.Format("Error (Default Comparison Option with Operator): {0} and {1} should be equal", s_specialMatchingString[i, 0], s_specialMatchingString[i, 1]));
Assert.True(str1.CompareTo(str2) == 0, string.Format("FAILED: (Default Comparison Option with CompareTo): {0} and {1} should be equal", s_specialMatchingString[i, 0], s_specialMatchingString[i, 1]));
}
}
public void CompareTo()
{
SqlByte Test = new SqlByte (1);
Assert.IsTrue (Test1.CompareTo (Test3) < 0, "#D01");
Assert.IsTrue (Test2.CompareTo (Test1) > 0, "#D02");
Assert.IsTrue (Test2.CompareTo (Test3) == 0, "#D03");
Assert.IsTrue (Test3.CompareTo (SqlString.Null) > 0, "#D04");
SqlString T1 = new SqlString ("test", 2057, SqlCompareOptions.IgnoreCase);
SqlString T2 = new SqlString ("TEST", 2057, SqlCompareOptions.None);
// IgnoreCase
T1 = new SqlString ("test", 2057, SqlCompareOptions.IgnoreCase);
T2 = new SqlString ("TEST", 2057, SqlCompareOptions.IgnoreCase);
Assert.IsTrue (T2.CompareTo (T1) == 0, "#D09");
T1 = new SqlString ("test", 2057);
T2 = new SqlString ("TEST", 2057);
Assert.IsTrue (T2.CompareTo (T1) == 0, "#D10");
T1 = new SqlString ("test", 2057, SqlCompareOptions.None);
T2 = new SqlString ("TEST", 2057, SqlCompareOptions.None);
Assert.IsTrue (T2.CompareTo (T1) != 0, "#D11");
// IgnoreNonSpace
T1 = new SqlString ("TEST\xF1", 2057, SqlCompareOptions.IgnoreNonSpace);
T2 = new SqlString ("TESTn", 2057, SqlCompareOptions.IgnoreNonSpace);
Assert.IsTrue (T2.CompareTo (T1) == 0, "#D12");
T1 = new SqlString ("TESTñ", 2057, SqlCompareOptions.None);
T2 = new SqlString ("TESTn", 2057, SqlCompareOptions.None);
Assert.IsTrue (T2.CompareTo (T1) != 0, "#D13");
// BinarySort
T1 = new SqlString ("01_", 2057, SqlCompareOptions.BinarySort);
T2 = new SqlString ("_01", 2057, SqlCompareOptions.BinarySort);
Assert.IsTrue (T1.CompareTo (T2) < 0, "#D14");
T1 = new SqlString ("01_", 2057, SqlCompareOptions.None);
T2 = new SqlString ("_01", 2057, SqlCompareOptions.None);
Assert.IsTrue (T1.CompareTo (T2) > 0, "#D15");
}
public void CompareToSqlTypeException ()
{
SqlString T1 = new SqlString ("test", 2057, SqlCompareOptions.IgnoreCase);
SqlString T2 = new SqlString ("TEST", 2057, SqlCompareOptions.None);
T1.CompareTo (T2);
}
/**
* Compares two instances of SqlString to determine if the first is less than the second.
* @param x A SqlString instance
* @param y A SqlString instance
* @return A SqlBoolean that is True if the first instance is less than the second instance, otherwise False.
* If either instance of SqlString is null, the Value of the SqlBoolean will be Null.
*/
public static SqlBoolean LessThanOrEqual(SqlString x, SqlString y)
{
if (x.IsNull || y.IsNull)
return SqlBoolean.Null;
if (x.CompareTo(y) <= 0)
return SqlBoolean.True;
return SqlBoolean.False;
}
/**
* Compares two instances of SqlString to determine if the first is greater than the second.
* @param x A SqlString instance
* @param y A SqlString instance
* @return A SqlBoolean that is True if the first instance is greater than the second instance, otherwise False.
* If either instance of SqlString is null, the Value of the SqlBoolean will be Null.
*/
public static SqlBoolean GreaterThan(SqlString x, SqlString y)
{
if (x.IsNull || y.IsNull)
return SqlBoolean.Null;
if (x.CompareTo(y) > 0)
return SqlBoolean.True;
return SqlBoolean.False;
}
public void CompareTo()
{
SqlByte Test = new SqlByte(1);
Assert.True(_test1.CompareTo(_test3) < 0);
Assert.True(_test2.CompareTo(_test1) > 0);
Assert.True(_test2.CompareTo(_test3) == 0);
Assert.True(_test3.CompareTo(SqlString.Null) > 0);
SqlString T1 = new SqlString("test", 2057, SqlCompareOptions.IgnoreCase);
SqlString T2 = new SqlString("TEST", 2057, SqlCompareOptions.None);
// IgnoreCase
T1 = new SqlString("test", 2057, SqlCompareOptions.IgnoreCase);
T2 = new SqlString("TEST", 2057, SqlCompareOptions.IgnoreCase);
Assert.True(T2.CompareTo(T1) == 0);
T1 = new SqlString("test", 2057);
T2 = new SqlString("TEST", 2057);
Assert.True(T2.CompareTo(T1) == 0);
T1 = new SqlString("test", 2057, SqlCompareOptions.None);
T2 = new SqlString("TEST", 2057, SqlCompareOptions.None);
Assert.True(T2.CompareTo(T1) != 0);
// IgnoreNonSpace
T1 = new SqlString("TEST\xF1", 2057, SqlCompareOptions.IgnoreNonSpace);
T2 = new SqlString("TESTn", 2057, SqlCompareOptions.IgnoreNonSpace);
Assert.True(T2.CompareTo(T1) == 0);
T1 = new SqlString("TEST\u00F1", 2057, SqlCompareOptions.None);
T2 = new SqlString("TESTn", 2057, SqlCompareOptions.None);
Assert.True(T2.CompareTo(T1) != 0);
// BinarySort
T1 = new SqlString("01_", 2057, SqlCompareOptions.BinarySort);
T2 = new SqlString("_01", 2057, SqlCompareOptions.BinarySort);
Assert.True(T1.CompareTo(T2) < 0);
T1 = new SqlString("01_", 2057, SqlCompareOptions.None);
T2 = new SqlString("_01", 2057, SqlCompareOptions.None);
Assert.True(T1.CompareTo(T2) > 0);
}
public void CompareToSqlTypeException()
{
SqlString T1 = new SqlString("test", 2057, SqlCompareOptions.IgnoreCase);
SqlString T2 = new SqlString("TEST", 2057, SqlCompareOptions.None);
Assert.Throws<SqlTypeException>(() => T1.CompareTo(T2));
}
public void CompareToSqlTypeException ()
{
ExceptionAssert.Throws<SqlTypeException>(
delegate
{
SqlString T1 = new SqlString("test", "en-GB", SqlCompareOptions.IgnoreCase);
SqlString T2 = new SqlString("TEST", "en-GB", SqlCompareOptions.None);
T1.CompareTo(T2);
});
}
