public static object ExecuteScalar(SqlTransaction transaction, CommandType commandType, string commandText, params SqlParameter[] commandParameters) { SqlCommand cmd = new SqlCommand(); PrepareCommand(cmd, transaction.Connection, transaction, commandType, commandText, commandParameters); cmd.Parameters.Clear(); return(PerformanceWatcher.Watch <object>(commandText, () => cmd.ExecuteScalar())); }
public static int ExecuteNonQuery(SqlConnection connection, CommandType commandType, string commandText, params SqlParameter[] commandParameters) { SqlCommand cmd = new SqlCommand(); PrepareCommand(cmd, connection, null, commandType, commandText, commandParameters); cmd.Parameters.Clear(); return(PerformanceWatcher.Watch <int>(commandText, () => cmd.ExecuteNonQuery())); }
public static DataTable ExecuteDataTable(SqlConnection connection, CommandType commandType, string commandText, params SqlParameter[] parameters) { SqlCommand cmd = new SqlCommand(); PrepareCommand(cmd, connection, null, commandType, commandText, parameters); return(PerformanceWatcher.Watch <DataTable>(commandText, delegate { DataTable dataTable = new DataTable(); new SqlDataAdapter(cmd).Fill(dataTable); cmd.Parameters.Clear(); return dataTable; })); }
private static SqlDataReader ExecuteReader(SqlConnection connection, SqlTransaction transaction, CommandType commandType, string commandText, SqlParameter[] commandParameters, SqlConnectionOwnership connectionOwnership) { SqlDataReader reader; SqlCommand cmd = new SqlCommand(); PrepareCommand(cmd, connection, transaction, commandType, commandText, commandParameters); if (connectionOwnership == SqlConnectionOwnership.External) { reader = PerformanceWatcher.Watch <SqlDataReader>(commandText, () => cmd.ExecuteReader()); } else { reader = PerformanceWatcher.Watch <SqlDataReader>(commandText, () => cmd.ExecuteReader(CommandBehavior.CloseConnection)); } cmd.Parameters.Clear(); return(reader); }
public static DataTable ExecuteDataTable2(SqlTransaction transaction, CommandType commandType, string commandText, params SqlParameter[] commandParameters) { SqlCommand cmd = new SqlCommand(); PrepareCommand(cmd, transaction.Connection, transaction, commandType, commandText, commandParameters); cmd.CommandTimeout = 0; return(PerformanceWatcher.Watch <DataTable>(commandText, delegate { SqlDataAdapter adapter1 = new SqlDataAdapter(cmd) { SelectCommand = { CommandTimeout = 0 } }; DataTable dataTable = new DataTable(); adapter1.Fill(dataTable); cmd.Parameters.Clear(); return dataTable; })); }