Home > News, Oracle Database > Business Object Model Now Supports Oracle Databases

Business Object Model Now Supports Oracle Databases


Support of Oracle Databases at Business Object Model (BOM) level was now added using Microsoft’s (System.Data.OracleClient) and Oracle’s (Oracle.DataAccess.Client) providers.
To enable this support, neither extra attributes nor any modifications in the BOM are required: all one needs to do is to update its connection string declaration.

Example:

  1. .NET Oracle Provider:
    <[DefaultNamespace] persistenceTypeName="System.Data.OracleClient.OracleConnection, System.Data.OracleClient"
    connectionString="Data Source=(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=MYORACLESERVER)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=XE)));user id=HR;password=hr" />
  2. ODP.NET Oracle Provider:
    <[DefaultNamespace] persistenceTypeName="Oracle.DataAccess.Client.OracleConnection, Oracle.DataAccess.Client"
    connectionString="Data Source=(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=MYORACLESERVER)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=XE)));user id=HR;password=hr" />

The CodeFluent Entities Runtime will automatically add the cursor parameter which is required to read Oracle Server procedures.

Even though the Oracle Server Producer is still on its way, this provides a way to map a generated BOM onto an Oracle persistence layer.

CodeFluent Entities R&D Team

Categories: News, Oracle Database
  1. No comments yet.
  1. No trackbacks yet.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s