public GetStatsInfoResult GetStatsInfo() { var result = new GetStatsInfoResult(); _connectionProvider.GetConnection((connection) => { result.LastQueryInHistory = connection.ExecuteScalar <DateTime>("SELECT TOP 1 end_time_utc FROM QueryHistory ORDER BY end_time_utc DESC"); result.TotalRecords = connection.ExecuteScalar <long>("SELECT Count(*) FROM QueryHistory"); }); result.ImportSettings = _dataLoader.GetSettings(); result.ImportJobActive = GetIsJobExists(); return(result); }