public override object ExecuteScalar() { object result = null; var context = NHProfilerContextProvider.GetLoggedDbCommand(InternalCommand, null); _profiler.ScalarExecuting(InternalCommand, context); _stopwatch.Restart(); try { result = InternalCommand.ExecuteScalar(); } catch (Exception e) { context = NHProfilerContextProvider.GetLoggedDbCommand(InternalCommand, e); _profiler.ScalarExecuting(InternalCommand, context); throw; } finally { _stopwatch.Stop(); context = NHProfilerContextProvider.GetLoggedResult(InternalCommand, null, result, _stopwatch.ElapsedMilliseconds, null); _profiler.ScalarExecuted(InternalCommand, context); } return(result); }
public override int ExecuteNonQuery() { int result = 0; var context = NHProfilerContextProvider.GetLoggedDbCommand(InternalCommand, null); _profiler.NonQueryExecuting(InternalCommand, context); _stopwatch.Restart(); try { result = InternalCommand.ExecuteNonQuery(); AffectedRows = result; } catch (Exception e) { context = NHProfilerContextProvider.GetLoggedDbCommand(InternalCommand, e); _profiler.NonQueryExecuting(InternalCommand, context); throw; } finally { _stopwatch.Stop(); context = NHProfilerContextProvider.GetLoggedResult(InternalCommand, null, result, _stopwatch.ElapsedMilliseconds, null); _profiler.NonQueryExecuted(InternalCommand, context); } return(result); }
protected override DbDataReader ExecuteDbDataReader(CommandBehavior behavior) { DbDataReader originalResult = null; var context = NHProfilerContextProvider.GetLoggedDbCommand(InternalCommand, null); _profiler.ReaderExecuting(InternalCommand, context); _stopwatch.Restart(); try { originalResult = InternalCommand.ExecuteReader(behavior); var dataSet = new DataSet { EnforceConstraints = false }; DataRows = new DataTable(tableName: Guid.NewGuid().ToString()); dataSet.Tables.Add(DataRows); dataSet.Load(originalResult, LoadOption.OverwriteChanges, DataRows); originalResult = DataRows.CreateDataReader(); } catch (Exception e) { context = NHProfilerContextProvider.GetLoggedDbCommand(InternalCommand, e); _profiler.ReaderExecuting(InternalCommand, context); throw; } finally { _stopwatch.Stop(); context = NHProfilerContextProvider.GetLoggedResult(InternalCommand, null, originalResult, _stopwatch.ElapsedMilliseconds, DataRows); _profiler.ReaderExecuted(InternalCommand, context); } return(originalResult); }