public AddTraceFilterErrorCode AddTraceFilter <T>(TraceField traceField, LogicalOperator logicalOp, ComparisonOperator compOp, T value) { if (traceId == 0) { throw new NotInitializedProfilerException(); } SqlCommand cmd = MsSqlUtil.NewStoredProcedure("sp_trace_setfilter"); MsSqlUtil.AddInParam(cmd, "@traceid", traceId); MsSqlUtil.AddInParam(cmd, "@columnid", (int)traceField); MsSqlUtil.AddInParam(cmd, "@logical_operator", (int)logicalOp); MsSqlUtil.AddInParam(cmd, "@comparison_operator", (int)compOp); MsSqlUtil.AddInParam(cmd, "@value", value); return((AddTraceFilterErrorCode)MsSqlUtil.ExecuteStoredProcedure(cmd, connInfo.CreateConnectionObject())); }
public static int ExecuteStoredProcedure(SqlCommand cmd, IDbConnection conn) { SqlParameter ret = MsSqlUtil.AddReturnParam(cmd); cmd.Connection = (SqlConnection)conn; conn.Open(); try { cmd.ExecuteNonQuery(); return(Convert.ToInt32(ret.Value)); } finally { conn.Close(); } }
public AddTraceEventErrorCode AddTraceEvent(TraceEvent traceEvent, params TraceField[] traceFields) { if (traceId == 0) { throw new NotInitializedProfilerException(); } foreach (TraceField field in traceFields) { SqlCommand cmd = MsSqlUtil.NewStoredProcedure("sp_trace_setevent"); MsSqlUtil.AddInParam(cmd, "@traceid", traceId); MsSqlUtil.AddInParam(cmd, "@eventid", (int)traceEvent); MsSqlUtil.AddInParam(cmd, "@columnid", (int)field); MsSqlUtil.AddInParam(cmd, "@on", true); MsSqlUtil.ExecuteStoredProcedure(cmd, connInfo.CreateConnectionObject()); if (!this.traceFields.Contains(field.ToString())) { this.traceFields.Add(field.ToString()); } } return(AddTraceEventErrorCode.NoError); }