internal SqlDataReader ExecuteReader(VivendiSource source, string commandText, params SqlParameter[] parameters) => // return a reader that closes the connection once it's disposed BuildCommand(OpenConnection(source), commandText, parameters).ExecuteReader(CommandBehavior.CloseConnection);
internal object ExecuteScalar(VivendiSource source, string commandText, params SqlParameter[] parameters)
{
// run a simple query
using var connection = OpenConnection(source);
return(BuildCommand(connection, commandText, parameters).ExecuteScalar());
}
internal int ExecuteNonQuery(VivendiSource source, string commandText, params SqlParameter[] parameters)
{
// run a INSERT, UPDATE or DELETE command and return the affected rows
using var connection = OpenConnection(source);
return(BuildCommand(connection, commandText, parameters).ExecuteNonQuery());
}