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;
}));
}
