/// <summary>
/// Maps return data to the query data
/// </summary>
/// <param name="command">The command.</param>
/// <param name="toReturn">To return.</param>
/// <param name="reader">The reader.</param>
protected void MapReturnData(IDbCommand command, SqlCompactQueryData toReturn, IDataReader reader)
{
if (reader.Read())
{
if (!_mappings.ContainsKey(command.CommandText))
{
_mappings[command.CommandText] = new Dictionary <string, int>();
DataTable schema = reader.GetSchemaTable();
if (schema != null)
{
for (int i = 0; i < schema.Rows.Count; i++)
{
toReturn.AddFieldMapping(schema.Rows[i]["ColumnName"].ToString(), i);
}
}
_mappings[command.CommandText] = toReturn.GetMappings();
}
toReturn.SetFieldMappings(_mappings[command.CommandText]);
AddRecord(toReturn, reader);
while (reader.Read())
{
AddRecord(toReturn, reader);
}
}
}
public IQueryData ExecuteCommandQueryAction(IDbCommand command, IDataConnection connection, IDbConnection r)
{
SqlCompactQueryData toReturn = new SqlCompactQueryData();
using (IDataReader reader = command.ExecuteReader())
MapReturnData(command, toReturn, reader);
toReturn.QuerySuccessful = true;
return(toReturn);
}
/// <summary>
/// Adds a record to the result set
/// </summary>
protected static void AddRecord(SqlCompactQueryData toReturn, IDataReader reader)
{
object[] values = new object[reader.FieldCount];
reader.GetValues(values);
toReturn.AddRowData(values);
}