private DataTable RunQueryInSQLAndGetResult(string sqlQueryText)
{
var dataTable = new DataTable();
using (var con = _conn())
{
con.Open();
Stopwatch sw = new Stopwatch();
sw.Start();
using (var command = new SqlCommand(sqlQueryText, con))
{
var dataReader = command.ExecuteReader();
dataTable.Load(dataReader);
}
sw.Stop();
_logger?.Log("SQL Query elapsed={0}", sw.Elapsed);
if (sw.Elapsed.TotalSeconds > 5)
{
_logger?.LogCritical("Following generated query took a long time to run:");
_logger?.LogCritical(sqlQueryText);
}
con.Close();
}
return(dataTable);
}
