Esempio n. 1
0
 public void CompareOptionsFromSqlCompareOptions()
 {
     Assert.Equal(CompareOptions.IgnoreCase,
                  SqlString.CompareOptionsFromSqlCompareOptions(
                      SqlCompareOptions.IgnoreCase));
     Assert.Equal(CompareOptions.IgnoreCase,
                  SqlString.CompareOptionsFromSqlCompareOptions(
                      SqlCompareOptions.IgnoreCase));
     Assert.Throws <ArgumentOutOfRangeException>(() => SqlString.CompareOptionsFromSqlCompareOptions(SqlCompareOptions.BinarySort));
 }
Esempio n. 2
0
 public void CompareOptionsFromSqlCompareOptions()
 {
     Assert.AreEqual(CompareOptions.IgnoreCase,
                     SqlString.CompareOptionsFromSqlCompareOptions(
                         SqlCompareOptions.IgnoreCase), "#M01");
     Assert.AreEqual(CompareOptions.IgnoreCase,
                     SqlString.CompareOptionsFromSqlCompareOptions(
                         SqlCompareOptions.IgnoreCase), "#M02");
     try {
         CompareOptions test = SqlString.CompareOptionsFromSqlCompareOptions(
             SqlCompareOptions.BinarySort);
         Assert.Fail("#M03");
     } catch (ArgumentOutOfRangeException e) {
         Assert.AreEqual(typeof(ArgumentOutOfRangeException), e.GetType(), "#M04");
     }
 }
        private static void VerifySortedSqlStringList(SortedList <SqlString, SqlString> items, SqlCompareOptions compareOption, CultureInfo cInfo)
        {
            //
            // Verify the list is in order
            //

            IList <SqlString> keyList = items.Keys;

            for (int i = 0; i < items.Count - 1; ++i)
            {
                SqlString currentString = keyList[i];
                SqlString nextString    = keyList[i + 1];

                Assert.True((bool)((currentString < nextString) && (nextString >= currentString)), "FAILED: (SqlString Operator Comparison): SqlStrings are out of order");
                Assert.True((currentString.CompareTo(nextString) < 0) && (nextString.CompareTo(currentString) > 0), "FAILED: (SqlString.CompareTo): SqlStrings are out of order");

                switch (compareOption)
                {
                case SqlCompareOptions.BinarySort:
                    Assert.True(CompareBinary(currentString.Value, nextString.Value) < 0, "FAILED: (SqlString BinarySort Comparison): SqlStrings are out of order");
                    break;

                case SqlCompareOptions.BinarySort2:
                    Assert.True(string.CompareOrdinal(currentString.Value.TrimEnd(), nextString.Value.TrimEnd()) < 0, "FAILED: (SqlString BinarySort2 Comparison): SqlStrings are out of order");

                    break;

                default:
                    CompareInfo    cmpInfo    = cInfo.CompareInfo;
                    CompareOptions cmpOptions = SqlString.CompareOptionsFromSqlCompareOptions(nextString.SqlCompareOptions);

                    Assert.True(cmpInfo.Compare(currentString.Value.TrimEnd(), nextString.Value.TrimEnd(), cmpOptions) < 0, "FAILED: (SqlString Comparison): SqlStrings are out of order");
                    break;
                }
            }
        }