/// <summary> /// Tracks when 'command' is started. /// </summary> public void ExecuteStartImpl(DbCommand command, ExecuteType type) { var id = Tuple.Create((object)command, type); var sqlTiming = new SqlTiming(command, type, Profiler); _inProgress[id] = sqlTiming; }
/// <summary> /// Tracks when 'command' is started. /// </summary> public void ExecuteStartImpl(DbCommand command, ExecuteType type) { var id = Tuple.Create((object)command, type); var sqlTiming = new SqlTiming(command, type, Profiler); _inProgress[id] = sqlTiming; }
/// <summary> /// Adds the parameter 'sqlTiming' to this Timing's SqlTimings collection. /// </summary> /// <param name="sqlTiming">A sql statement profiling that was executed in this Timing step.</param> /// <remarks> /// Used outside this assembly for custom deserialization when creating an <see cref="Storage.IStorage"/> implementation. /// </remarks> public void AddSqlTiming(SqlTiming sqlTiming) { if (SqlTimings == null) { SqlTimings = new List <SqlTiming>(); } SqlTimings.Add(sqlTiming); sqlTiming.ParentTiming = this; }
/// <summary> /// Formats the SQL in a Oracle-Server friendly way, with DECLARE statements for the parameters up top. /// </summary> /// <param name="timing">The SqlTiming to format</param> /// <returns>A formatted SQL string</returns> public string FormatSql(SqlTiming timing) { if (timing.Parameters == null || timing.Parameters.Count == 0) { return timing.CommandString; } var buffer = new StringBuilder(); buffer.Append("DECLARE "); var first = true; foreach (var p in timing.Parameters) { if (first) { first = false; } else { buffer.AppendLine(",").Append(new string(' ', 8)); } DbType parsed; string resolvedType = null; if (!Enum.TryParse(p.DbType, out parsed)) { resolvedType = p.DbType; } if (resolvedType.IsNull()) { Func<SqlTimingParameter, string> translator; if (paramTranslator.TryGetValue(parsed, out translator)) { resolvedType = translator(p); } resolvedType = resolvedType ?? p.DbType; } var niceName = p.Name; //variable/paramter prefix //if (!niceName.StartsWith("v_")) //{ // niceName = "v_" + niceName; //} buffer.Append(niceName).Append(" ").Append(resolvedType).Append(" = ").Append(PrepareValue(p)); } return buffer .AppendLine() .AppendLine() .Append(timing.CommandString) .ToString(); }
/// <summary> /// Adds <paramref name="stats"/> to the current <see cref="Timing"/>. /// </summary> internal void AddSqlTiming(SqlTiming stats) { if (Head == null) { return; } int count; stats.IsDuplicate = _sqlExecutionCounts.TryGetValue(stats.CommandString, out count); _sqlExecutionCounts[stats.CommandString] = count + 1; HasSqlTimings = true; if (stats.IsDuplicate) { HasDuplicateSqlTimings = true; } Head.AddSqlTiming(stats); }
/// <summary> /// Adds the parameter 'sqlTiming' to this Timing's SqlTimings collection. /// </summary> /// <param name="sqlTiming">A sql statement profiling that was executed in this Timing step.</param> /// <remarks> /// Used outside this assembly for custom deserialization when creating an <see cref="Storage.IStorage"/> implementation. /// </remarks> public void AddSqlTiming(SqlTiming sqlTiming) { if (SqlTimings == null) SqlTimings = new List<SqlTiming>(); SqlTimings.Add(sqlTiming); sqlTiming.ParentTiming = this; }
/// <summary> /// Adds <paramref name="stats"/> to the current <see cref="Timing"/>. /// </summary> internal void AddSqlTiming(SqlTiming stats) { if (Head == null) return; int count; stats.IsDuplicate = _sqlExecutionCounts.TryGetValue(stats.CommandString, out count); _sqlExecutionCounts[stats.CommandString] = count + 1; HasSqlTimings = true; if (stats.IsDuplicate) { HasDuplicateSqlTimings = true; } Head.AddSqlTiming(stats); }