public ISqlResultSet TransformSqlResultSet(ISqlResultSet resultSet)
{
List <int> colIndices = new List <int>();
List <string> colIds = new List <string>();
List <string> colNames = new List <string>();
int i = 0;
var e = _data.Columns.GetEnumerator();
while (e.MoveNext())
{
string colId = e.Current.Key;
int colIndex = resultSet.ColumnIndexOf(colId);
if (colIndex != -1)
{
colIndices.Add(colIndex);
colIds.Add(colId);
colNames.Add(e.Current.Value);
i++;
}
}
SqlResult transformedResults = new SqlResult(colIndices.Count, resultSet.GetRowCount());
transformedResults.SetColumnNames(colNames.ToArray());
for (int j = 0; j < resultSet.GetRowCount(); j++)
{
ISqlValue[] row = new ISqlValue[colIndices.Count];
i = 0;
foreach (int index in colIndices)
{
row[i] = resultSet.GetValue(index, j);
i++;
}
transformedResults.AddRow(j, row);
}
return(transformedResults);
}