About ADO.NET Database Connections

Database ADO.NET connections between WPF applications and third-party .NET assemblies are shared through a PowerBuilder connection proxy.

The connection proxy is defined in the Sybase.PowerBuilder.DataSource.Sharing.dll assembly, which implements the .NET Framework System.Data.IDbConnection interface. Both the PowerBuilder application and the third-party assembly manage connections and transactions by referencing the proxy.

In the WPF application, the PowerBuilder Transaction object is the standard PowerBuilder nonvisual object used in database connections. To manage the shared connection, the Transaction object references the AdoConnectionProxy object using these methods:

• bool SetAdoConnection (object connectionProxy) – accepts an imported ADO.NET connection.
• object GetAdoConnection() – accepts an ADO.NET connection exported from the Transaction object.