Using Begin (Async call) with ORACLE

  • Thread starter Thread starter Anibal David Acosta F.
  • Start date Start date
A

Anibal David Acosta F.

Is possible to execute Asynchroneus calls to Oracle DB from .net framework
2.0?

System.Data.OracleClient don't have this feature, but maybe the ODP.NET
9.2.0.4.01 from ORACLE has

Do you know a way to make async calls to ORACLE DB from .net 2.0?


Thanks
 
Anibal,
I am not sure of the scenario that you are trying to enable, but it is very
very likely that you will be better of using the BackgroundWorker class than
doing asynchronous calls.

http://bitarray.co.uk/ben/articles/208.aspx

--
Angel Saenz-Badillos [MS] Managed Providers
This posting is provided "AS IS", with no warranties, and confers no
rights.Please do not send email directly to this alias.
This alias is for newsgroup purposes only.
I am now blogging about ADO.NET: http://weblogs.asp.net/angelsb/
 
Worker thread are very expensive.
So, I want to execute an SQL Command to my Oracle DB and release the worker
thread for use a IO Thread.

The point is that I don't want to use one Worker thread for operations that
not need one.

ADO.NET 2.0 has functions called BeginExecuteNonQuery, BeginExecuteReader
etc but are only for MS SQL Server, so... How can I code something like that
for ORACLE DB?

Thanks


Angel Saenz-Badillos said:
Anibal,
I am not sure of the scenario that you are trying to enable, but it is very
very likely that you will be better of using the BackgroundWorker class than
doing asynchronous calls.

http://bitarray.co.uk/ben/articles/208.aspx

--
Angel Saenz-Badillos [MS] Managed Providers
This posting is provided "AS IS", with no warranties, and confers no
rights.Please do not send email directly to this alias.
This alias is for newsgroup purposes only.
I am now blogging about ADO.NET: http://weblogs.asp.net/angelsb/




Anibal David Acosta F. said:
Is possible to execute Asynchroneus calls to Oracle DB from .net framework
2.0?

System.Data.OracleClient don't have this feature, but maybe the ODP.NET
9.2.0.4.01 from ORACLE has

Do you know a way to make async calls to ORACLE DB from .net 2.0?


Thanks
Click to expand...
Click to expand...
 
Anibal,
That is a very good point, I will have to investigate just how expensive
this scenario is.

As far as your question, I am not aware of any async functionality being
added to Oracle, sorry.

--
Angel Saenz-Badillos [MS] Managed Providers
This posting is provided "AS IS", with no warranties, and confers no
rights.Please do not send email directly to this alias.
This alias is for newsgroup purposes only.
I am now blogging about ADO.NET: http://weblogs.asp.net/angelsb/




Anibal David Acosta F. said:
Worker thread are very expensive.
So, I want to execute an SQL Command to my Oracle DB and release the worker
thread for use a IO Thread.

The point is that I don't want to use one Worker thread for operations that
not need one.

ADO.NET 2.0 has functions called BeginExecuteNonQuery, BeginExecuteReader
etc but are only for MS SQL Server, so... How can I code something like that
for ORACLE DB?

Thanks


Angel Saenz-Badillos said:
Anibal,
I am not sure of the scenario that you are trying to enable, but it is very
very likely that you will be better of using the BackgroundWorker class than
doing asynchronous calls.

http://bitarray.co.uk/ben/articles/208.aspx

--
Angel Saenz-Badillos [MS] Managed Providers
This posting is provided "AS IS", with no warranties, and confers no
rights.Please do not send email directly to this alias.
This alias is for newsgroup purposes only.
I am now blogging about ADO.NET: http://weblogs.asp.net/angelsb/




Anibal David Acosta F. said:
Is possible to execute Asynchroneus calls to Oracle DB from .net framework
2.0?

System.Data.OracleClient don't have this feature, but maybe the ODP.NET
9.2.0.4.01 from ORACLE has

Do you know a way to make async calls to ORACLE DB from .net 2.0?


Thanks
Click to expand...
Click to expand...
Click to expand...
 
Back
Top