Porting Client Application to .NET Stored Procedure

All classes and class members provide the same functionality for both client applications and .NET stored procedures, unless it is otherwise stated.

Table 4-1 lists those classes or class members that have different behavior depending on whether or not they are used in a client application or in a .NET stored procedure.

Column Headings

The column heading for this table are:

Client application: The client application.

Implicit connection: The implicit database connections in a .NET stored procedure.

Explicit connection: The explicit user connections in a .NET stored procedure.

Table 4-1 API Support Comparison Between Client Application and .NET Stored Procedure

Class or Class Members Client Application Implicit Connection/Explicit Connection

OnChangeEventHandler Delegate
-all members


Yes


No/No

OracleDependency Class
-all members


Yes


No/No

OracleNotificationEventArgs Class
-all members


Yes


No/No

OracleNotificationRequest Class
-all members


Yes


No/No

OracleFailoverEventArgs Class
-all members


Yes


No/No

OracleFailoverEventHandler Delegate
-all members


Yes


No/No

OracleTransaction Class
-all members


Yes


No/No

OracleCommand Class
-Transaction Property


Yes


No #1/No #1

OracleConnection Class
-ConnectionTimeout Property
-DataSource Property
-BeginTransaction Method
-ChangeDatabase Method
-Clone Method
-EnlistDistributedTransaction Method
-OpenWithNewPassword Method
-Failover Event
-OracleFailoverEventHandler Delegate


Yes
Yes
Yes
No
Yes
Yes
Yes
Yes
Yes


Yes #3/Yes
Yes #2/Yes
No/Yes
No/No
No/Yes
No/No
No/Yes
No/No
No/No

ODP.NET Enumerations
-FailoverEvent Enumeration
-FailoverReturnCode Enumeration
-FailoverType Enumeration
-OracleNotificationInfo Enumeration
-OracleNotificationSource Enumeration
-OracleNotificationType Enumeration


Yes
Yes
Yes
Yes
Yes
Yes


No/No
No/No
No/No
No/No
No/No
No/No

Comments on Items in Table 4-1

  1. Always returns null.

  2. Implicit database connection always returns an empty string.

  3. Implicit database connection always returns 0.