// HOWTO: Get query statistics public void QueryStatistics() { try { _query.SQL = SqlBox.Text; } catch (Exception e) { MessageBox.Show(e.Message, "Parsing error"); return; } QueryStatistics qs = _query.QueryStatistics; var stats = "Used Objects (" + qs.UsedDatabaseObjects.Count + "):\r\n"; foreach (StatisticsDatabaseObject statisticsDatabaseObject in qs.UsedDatabaseObjects) { stats += "\r\n" + statisticsDatabaseObject.ObjectName.QualifiedName; } stats += "\r\n\r\n" + "Used Columns (" + qs.UsedDatabaseObjectFields.Count + "):\r\n"; foreach (StatisticsField statisticsField in qs.UsedDatabaseObjectFields) { stats += "\r\n" + statisticsField.FullName.QualifiedName; } stats += "\r\n\r\n" + "Output Expressions (" + qs.OutputColumns.Count + "):\r\n"; foreach (StatisticsOutputColumn statisticsOutputColumn in qs.OutputColumns) { stats += "\r\n" + statisticsOutputColumn.Expression; } var f = new QueryStatisticsWindow(stats) { Owner = this }; f.ShowDialog(); }
public void ShowQueryStatistics() { var qs = QueryView.Query.QueryStatistics; var stats = "Used Objects (" + qs.UsedDatabaseObjects.Count + "):\r\n"; stats = qs.UsedDatabaseObjects.Aggregate(stats, (current, t) => current + ("\r\n" + t.ObjectName.QualifiedName)); stats += "\r\n\r\n" + "Used Columns (" + qs.UsedDatabaseObjectFields.Count + "):\r\n"; stats = qs.UsedDatabaseObjectFields.Aggregate(stats, (current, t) => current + ("\r\n" + t.ObjectName.QualifiedName)); stats += "\r\n\r\n" + "Output Expressions (" + qs.OutputColumns.Count + "):\r\n"; stats = qs.OutputColumns.Aggregate(stats, (current, t) => current + ("\r\n" + t.Expression)); var f = new QueryStatisticsWindow(stats); f.ShowDialog(); }
private void QueryStatistic_OnClick(object sender, RoutedEventArgs e) { QueryStatistics queryStatistics = queryBuilder.QueryStatistics; StringBuilder builder = new StringBuilder(); builder.Append("Used Objects (").Append(queryStatistics.UsedDatabaseObjects.Count).AppendLine("):"); builder.AppendLine(); for (int i = 0; i < queryStatistics.UsedDatabaseObjects.Count; i++) { builder.AppendLine(queryStatistics.UsedDatabaseObjects[i].ObjectName.QualifiedName); } builder.AppendLine().AppendLine(); builder.Append("Used Columns (").Append(queryStatistics.UsedDatabaseObjectFields.Count).AppendLine("):"); builder.AppendLine(); for (int i = 0; i < queryStatistics.UsedDatabaseObjectFields.Count; i++) { builder.AppendLine(queryStatistics.UsedDatabaseObjectFields[i].FullName.QualifiedName); } builder.AppendLine().AppendLine(); builder.Append("Output Expressions (").Append(queryStatistics.OutputColumns.Count).AppendLine("):"); builder.AppendLine(); for (int i = 0; i < queryStatistics.OutputColumns.Count; i++) { builder.AppendLine(queryStatistics.OutputColumns[i].Expression); } var f = new QueryStatisticsWindow(builder.ToString()) { Owner = this }; f.ShowDialog(); }