databooster / dataaccess Goto Github PK

Looking into this package to upgrade a system using an old oracle version. Would like to know if this still supports Oracle 9i and is .NET standard/.net core compatible?

We are using the DBWebAPI and calling the DynExecuteDbApi. Unfortunately, this does not have a parameter for the CommandTimeout. We have a stored procedure that runs for 1 minute, but the query times out before complete. We tried calling the DbAccess.ExecuteReader and pass in the Command Timeout, but that is too low level. We had to loop through the datareader and populate the StoredProcedureResponse class.
Is there a way to set the command timeout when calling the DynExecuteDBApi?

Hi,

Is there any option to directly fill a DataSet object with the results of the query or simply produce a DataTable result from the execution of a Stored Procedure using Oracle? Thanks in advance for the help.

I assume that when adding named parameters using DbParameterBuilder the order of parameters should not matter. But i have a problem using the following procedure:

PROCEDURE ConsultarProcesos(pCanal IN varchar2, pRegistros OUT SYS_REFCURSOR, pUsuarioId in varchar2 := '-')

if i consume the procedure adding the parameters in the same order as the procedure it works, like this way:

parameters => { parameters.Add("pCanal", pCanal); parameters.AddRefCursor("pRegistros"); parameters.Add("pUsuarioId", pUsuarioId); }

But, if i change the order procedure throws the following error:

ORA-06550: line 1, column 7:
PLS-00306: wrong number or types of arguments in call to 'CONSULTARPROCESOS'
ORA-06550: line 1, column 7

I think that when working with named parameters the addition order should not matter as they are added using their parameterName property.

How do i execute a function that returns a scalar value using the library? Thanks in advance for your help.

Is there any recommended way to deal with 1000+ simultaneous users? I use the library in the Data Access and it gets so slow when multiple users are interacting with the database. Any help is appreciated. Here's a snippet of the way i'm interacting with my Oracle Database:

using (DbAccess db = DbPackage.CreateConnection()) { db.ExecuteReader(DbPackage.GetProcedure("trk_pkg_tracking.ConsultarMisCasosConFiltro"), parameters => { ((OracleCommand)parameters.Command).BindByName = true; parameters.Add("pUsuario", pUsuario); parameters.Add("pCasoID", pCasoID); parameters.Add("pCasoTitulo", pCasoTitulo); parameters.Add("pProcesoID", pProcesoId); parameters.Add("pActividadDescripcion", pActividadDescripcion); parameters.Add("pEnviadoPor", pEnviadoPor); parameters.Add("pUsuarioAsignado", pUsuarioAsignado); parameters.Add("pIdentificacionCaso", pIdentificacionCaso); if (pFechaDesde.HasValue) { parameters.Add("pFechaDesde", pFechaDesde.Value); } if (pFechaHasta.HasValue) { parameters.Add("pFechaHasta", pFechaHasta.Value); } parameters.AddRefCursor("pRegistros"); }, resultReader => { dtCasos.Load(resultReader); }, bulkRead: true); }