Connect to Oracle Database in Visual Studio

How to use the Consume Adapter Service Add-in, the Add Adapter Metadata Wizard, and the Add Adapter Service Reference Plug-in.

Connection options in Visual Studio

When using Visual Studio, there are several options available to connect to Oracle Database. These options include:

• The Consume Adapter Service BizTalk Project Add-in is available in BizTalk Server projects. You use the Consume Adapter Service Add-in to generate message schemas (XSDs) for operations that you want to target in your BizTalk solution. For more information about developing solutions with BizTalk Server, see Develop BizTalk applications using the Oracle Database adapter.

• The Add Adapter Metadata Wizard is available in BizTalk Server projects. You use the Add Adapter Metadata Wizard to generate message schemas (XSDs) for operations that you want to target in your BizTalk solution. For more information about developing solutions with BizTalk Server, see Develop BizTalk applications using the Oracle Database adapter.

  Note

  Because the Oracle Database adapter is exposed both as a WCF-Custom binding and as BizTalk adapter, you can use either the Consume Adapter Service Add-in or the Add Adapter Metadata Wizard from a BizTalk project to connect to SQL Server.

• The Add Adapter Service Reference Visual Studio Plug-in is available in non-BizTalk programming projects. You use the Add Adapter Service Reference Plug-in to generate a WCF client class or a WCF service callback interface when you develop solutions using the WCF service model. For more information about developing solutions with the WCF service model, see Develop Oracle Database applications using the WCF Service Model.

  To use the Consume Adapter Service Add-in, the Add Adapter Metadata Wizard, or the Add Adapter Service Reference Plug-in, you must first connect to the Oracle database. All three methods present a dialog box through which you configure a connection by setting the following:

• Connection parameters. These are the parameters that are used to build the connection URI. You must specify a data source (Oracle net service name).

• User name password credentials for the Oracle database. These are used to authenticate you on the Oracle database when the connection is established. You must specify a user name and password.

• Binding properties. Binding properties are optional at design-time, that is, while generating metadata for operations. For more information about binding properties, see Read about the Oracle Database adapter binding properties.

  At a minimum, when you configure the connection to the Oracle database, you only have to specify binding properties and connection parameters that are needed to establish the connection and that affect the metadata returned by the Oracle Database adapter for the operations you want to target. However, you might also want to specify values for any additional binding properties and connection parameters that will be used at run time. This is because:

• The Consume Adapter Service Add-in creates a BizTalk port binding file from the binding properties and connection parameters that you specify when you configure the connection, and adds this file to your project. Later, you can use this binding file to create a port in the BizTalk Server Administration console. For more information about the binding file, see Configure a physical port binding using a port binding file to Oracle Database.

• The Add Adapter Service Reference Plug-in creates an app.config file from the binding properties and connection properties that you specify when you configure the connection, and adds this file in your project directory.

See also

Get metadata for Oracle Database operations in Visual Studio