DbDataReader with DbTransactions
- by Gustavo Paulillo
Its the wrong way or lack of performance, using DbDataReader combinated with DbTransactions? An example of code:
public DbDataReader ExecuteReader()
{
try
{
if (this._baseConnection.State == ConnectionState.Closed)
this._baseConnection.Open();
if (this._baseCommand.Transaction != null)
return this._baseCommand.ExecuteReader();
return this._baseCommand.ExecuteReader(CommandBehavior.CloseConnection);
}
catch (Exception excp)
{
if (this._baseCommand.Transaction != null)
this._baseCommand.Transaction.Rollback();
this._baseCommand.CommandText = string.Empty;
this._baseConnection.Close();
throw new Exception(excp.Message);
}
}
Some methods call this operation. Sometimes openning a DbTransaction. Its using DbConnection and DbCommand.
The real problem, is in production enviroment (like 5,000 access/day) the ADO operations start throwing exceptions
