/// <summary>
/// Creates and runs a command to execute a query command text that returns a single row
/// </summary>
/// <typeparam name="T">Return type</typeparam>
/// <param name="connection">Database connection</param>
/// <param name="dataFiller">Function to convert the returned row into the return type object</param>
/// <param name="commandText">Command text</param>
/// <param name="isStoredProcedure">Indicates if the command text is a stored procedure name</param>
/// <param name="nullValue">Value to be returned if the query command text does not return any row</param>
/// <param name="parameters">Bind parameters</param>
/// <returns>Command text result, or nullValue if none</returns>
internal static T RetrieveDataItem <T>(DBOracleConnection connection, Func <DBOracleDataReader, T> dataFiller, string commandText, bool isStoredProcedure, T nullValue = default(T), params DBOracleParameter[] parameters)
{
try
{
using (var command = new DBOracleCommand(connection: connection, commandText: commandText, isStoredProcedure: isStoredProcedure, parameters: parameters))
{
var oracleDataReader = command.Command.ExecuteReader(behavior: CommandBehavior.SingleRow);
DBOracleDataReader dataReader = null;
try
{
dataReader = new DBOracleDataReader(oracleDataReader);
return((oracleDataReader.Read())
? dataFiller(dataReader)
: nullValue);
}
finally
{
dataReader?.Cleanup();
try
{
oracleDataReader?.Close();
}
catch (Exception ex)
{
try
{
Log.Error(DBOracleLocalizedText.DBOracleCommand_CloseDataReader, ex);
}
catch (Exception)
{
// Nothing to do
}
}
try
{
oracleDataReader?.Dispose();
}
catch (Exception ex)
{
try
{
Log.Error(DBOracleLocalizedText.DBOracleCommand_DisposeDataReader, ex);
}
catch (Exception)
{
// Nothing to do
}
}
}
}
}
catch (Exception ex)
{
ex.ConvertOracleException(isConnecting: false);
throw;
}
}
/// <summary>
/// Creates and runs a command to execute a command text that returns multiple rows
/// </summary>
/// <typeparam name="T">Return type</typeparam>
/// <param name="connection">Database connection</param>
/// <param name="dataFiller">Function to convert the returned rows into the return type object</param>
/// <param name="commandText">Command text</param>
/// <param name="isStoredProcedure">Indicates if the command text is a stored procedure name</param>
/// <param name="parameters">Bind parameters</param>
/// <returns>List of objects of the return type</returns>
internal static List <T> RetrieveDataList <T>(DBOracleConnection connection, Func <DBOracleDataReader, T> dataFiller, string commandText, bool isStoredProcedure, params DBOracleParameter[] parameters)
{
try
{
using (var command = new DBOracleCommand(connection: connection, commandText: commandText, isStoredProcedure: isStoredProcedure, parameters: parameters))
{
var oracleDataReader = command.Command.ExecuteReader();
DBOracleDataReader dataReader = null;
List <T> rowList = null;
try
{
dataReader = new DBOracleDataReader(oracleDataReader);
rowList = new List <T>();
while (oracleDataReader.Read())
{
rowList.Add(dataFiller(dataReader));
}
return(rowList);
}
catch (Exception)
{
rowList?.Clear(); // This method fills the internal array with zeros to help the gc
throw;
}
finally
{
dataReader?.Cleanup();
try
{
oracleDataReader?.Close();
}
catch (Exception ex)
{
try
{
Log.Error(DBOracleLocalizedText.DBOracleCommand_CloseDataReader, ex);
}
catch (Exception)
{
// Nothing to do
}
}
try
{
oracleDataReader?.Dispose();
}
catch (Exception ex)
{
try
{
Log.Error(DBOracleLocalizedText.DBOracleCommand_DisposeDataReader, ex);
}
catch (Exception)
{
// Nothing to do
}
}
}
}
}
catch (Exception ex)
{
ex.ConvertOracleException(isConnecting: false);
throw;
}
}
