public static DataTable GetMagicTable(DbConnection conn, IDataClient client, string sql)
{
DataTable dt = new DataTable();
try
{
var cmd = client.GetCommand(sql, conn);
var dba = client.GetDataAdapter(cmd);
dba.Fill(dt);
return dt;
}
catch (Exception ex)
{
_log.Error("error during select", ex);
}
return null;
}