The Oracle9i Data Provider for .NET (ODP.NET) advanced samples contain C# and VB .NET samples demonstrating the use of advanced database features wth ODP.NET.

Row Update Event Handler Sample [13-May-2003]
This VB.NET sample application demonstrates how one can trap the OracleRowUpdatingEvent and OracleRowUpdatedEvent.
Download (ZIP, 78KB)
Readme
Source

Web Service using ODP.NET Sample [24-Apr-2003]
This sample application demonstrates how ODP.NET can be used in a .NET Web Service. This application also shows how ASP.NET DataGrid can be used in conjunction with .NET Web Services and ODP.NET.
Download Now (ZIP, 175KB)
Readme
Source

Distributed Transaction Sample [11-Dec-2002]
This sample application demonstrates Distributed Transactions using MTS through Oracle Data Provider for .NET(ODP.NET).
Download Now (ZIP, 46KB)
Readme
Source

Globalization Sample [11-Dec-2002]
This sample demonstrates Globalization support in Oracle Data Provider for .NET (ODP.NET) to manage culture sensitive data in the database using C# applications.  
Download Now (ZIP, 32KB)
Readme
Source

Safe Type Mapping Sample [11-Dec-2002]
This sample demonstrates Safe Type Mapping feature in Oracle Data Provider for .NET (ODP.NET) when it is required to store and retrieve the data without precision loss from the database.
Download Now (ZIP, 33KB)
Readme
Source

Savepoint Sample [11-Dec-2002]
This sample demonstrates how Nested Transactions can be achieved using Savepoint feature in ODP.NET.
Download Now (ZIP, 33KB)
Readme
Source

TAF(Transparent Application Failover) Sample [11-Dec-2002]
This sample demonstrates TAF (Transparent Application Failover) with a C# application, when the connection to a database is severed.
Download Now (ZIP, 33KB)
Readme
Source