/// <summary>
/// 将Queryable转换为DataTable
/// </summary>
/// <typeparam name="T"></typeparam>
/// <param name="queryable"></param>
/// <returns></returns>
public static DataTable ToDataTable <T>(this Queryable <T> queryable)
{
StringBuilder sbSql = SqlSugarTool.GetQueryableSql <T>(queryable);
var dataTable = queryable.DB.GetDataTable(sbSql.ToString(), queryable.Params.ToArray());
queryable = null;
sbSql = null;
return(dataTable);
}
/// <summary>
/// 将Queryable转换为List《T》集合
/// </summary>
/// <typeparam name="T"></typeparam>
/// <param name="queryable"></param>
/// <returns></returns>
public static List <T> ToList <T>(this Queryable <T> queryable)
{
StringBuilder sbSql = SqlSugarTool.GetQueryableSql <T>(queryable);
var reader = queryable.DB.GetReader(sbSql.ToString(), queryable.Params.ToArray());
var reval = SqlSugarTool.DataReaderToList <T>(typeof(T), reader, queryable.Select.GetSelectFiles());
queryable = null;
sbSql = null;
return(reval);
}