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 5-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 headings 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 5-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 5-1

1. Always returns null.

2. Implicit database connection always returns an empty string.

3. Implicit database connection always returns 0.