/// <summary>
 /// Gets the row values for a row of the result set in the form of an object
 /// array.
 /// </summary>
 /// <param name="row">The row to get the values for.</param>
 /// <returns>The object array of the row values.</returns>
 public static object[] GetRowValues(Row row)
 {
     List<object> rowValues = new List<object>();
       foreach (Value value in row.values) {
     rowValues.Add(GetValue(value));
       }
       return rowValues.ToArray();
 }
 /// <summary>
 /// Gets the row values for a row of the result set in a the form of a string
 /// array. <code>null</code> values are interperted as empty strings.
 /// </summary>
 /// <param name="row">The row to get the values for.</param>
 /// <returns>The string array of the row values.</returns>
 public static String[] GetRowStringValues(Row row)
 {
     object[] rowValues = GetRowValues(row);
       List<string> rowStringValues = new List<string>();
       foreach (object obj in rowValues) {
     rowStringValues.Add(getTextValue(obj));
       }
       return rowStringValues.ToArray();
 }
    public void TestGetTextValueNumberSetValue() {
      NumberValue numberValue1 = new NumberValue();
      NumberValue numberValue2 = new NumberValue();
      numberValue1.value = "1";
      numberValue2.value = "2";

      SetValue setValue = new SetValue();
      setValue.values = new Value[] { numberValue1, numberValue2 };
      Row row = new Row();
      row.values = new Value[] { setValue };
      string[] stringValues = PqlUtilities.GetRowStringValues(row);
      Assert.AreEqual(1, stringValues.Length);
      Assert.AreEqual("1,2", stringValues[0]);
    }
    public void TestGetTextValueCommaTextSetValue() {
      TextValue textValue1 = new TextValue();
      TextValue textValue2 = new TextValue();
      textValue1.value = "value1";
      textValue2.value = "comma \",\" separated";

      SetValue setValue = new SetValue();
      setValue.values = new Value[] { textValue1, textValue2 };
      Row row = new Row();
      row.values = new Value[] { setValue };
      string[] stringValues = PqlUtilities.GetRowStringValues(row);
      Assert.AreEqual(1, stringValues.Length);
      Assert.AreEqual("value1,\"comma \"\",\"\" separated\"", stringValues[0]);
    }