public IEnumerable <Tout> ExecuteQueryProcedure <Tout>(
MySqlProcedure procedure,
object parameters,
CancellationToken cancellationToken)
{
var connectionString = this.ConnectionString(this.configuration);
using (var dbConnection = new MySqlConnection(connectionString))
{
dbConnection.Open();
using (var dbCommand = new MySqlCommand())
{
dbCommand.CommandText = procedure.Name;
dbCommand.CommandType = System.Data.CommandType.StoredProcedure;
dbCommand.Connection = dbConnection;
if (parameters != null)
{
MapObjectToParameters(procedure.Name, parameters, dbCommand.Parameters);
}
using (var dataReader = dbCommand.ExecuteReader())
{
var result = dataReader.CastAll <Tout>(cancellationToken);
return(result);
}
}
}
}
public void ExecuteQueryProcedure(
MySqlProcedure procedure,
object parameters,
CancellationToken cancellationToken)
{
this.ExecuteQueryProcedure <object>(procedure, parameters, cancellationToken);
}
public IEnumerable <Tout> ExecuteQueryProcedure <Tout>(
MySqlProcedure procedure,
CancellationToken cancellationToken)
{
return(this.ExecuteQueryProcedure <Tout>(procedure, null, cancellationToken));
}