/// <summary>
/// Returns the query data as a DataTable
/// </summary>
/// <param name="qd">The data</param>
/// <returns></returns>
public static DataTable ToDataTable(this QueryData qd)
{
DataTable toReturn = new DataTable();
qd.GetFields().ForEach(r => toReturn.Columns.Add(r));
foreach (QueryRow o in qd)
{
DataRow dr = toReturn.NewRow();
foreach (string s in qd.GetFields())
{
dr[s] = o.GetDataForRowField(s);
}
toReturn.Rows.Add(dr);
}
return(toReturn);
}
/// <summary>
/// Returns a list of dynamic objects that represent the data
/// </summary>
/// <param name="qd">The data</param>
/// <returns></returns>
public static List <dynamic> ToDynamicList(this QueryData qd)
{
List <dynamic> toReturn = new List <dynamic>();
if (qd.QuerySuccessful)
{
foreach (QueryRow o in qd)
{
dynamic newRecord = new ExpandoObject();
var d = newRecord as IDictionary <string, object>;
foreach (string s in qd.GetFields())
{
d.Add(s, o.GetDataForRowField(s));
}
toReturn.Add(newRecord);
}
}
return(toReturn);
}
