Hello Srinivas Chitta,
Yes, you can use the same generated DLL and forward map your classes to an Oracle db.
Here's how you can do it
- Create a copy of the connection node in the app.config and specify the setting for the oracle backend
- Add a 'backendconfiguration' node under the 'backendconfigurations' node. Both the connections should resolve to the same mapping node.
Here is an example of how the <openaccess> node should look like
<openaccess xmlns="http://www.telerik.com/OpenAccess">
<references />
<connections>
<connection id="DatabaseConnectionMssql">
<databasename>Northwind</databasename>
<servername>(local)\SQLEXPRESS</servername>
<integratedSecurity>True</integratedSecurity>
<backendconfigurationname>mssqlConfiguration</backendconfigurationname>
</connection>
<connection id="DatabaseConnectionOracle">
<databasename>databasename</databasename>
<servername>servername</servername>
<user>user</user>
<password>password</password>
<backendconfigurationname>oracleConfiguration</backendconfigurationname>
</connection>
</connections>
<backendconfigurations>
<backendconfiguration id="mssqlConfiguration" backend="mssql">
<mappingname>commonMapping</mappingname>
</backendconfiguration>
<backendconfiguration id="oracleConfiguration" backend="oracle">
<mappingname>commonMapping</mappingname>
</backendconfiguration>
</backendconfigurations>
<mappings current="commonMapping">
<mapping id="commonMapping" />
</mappings>
</openaccess>
Here we have 2 connection nodes - 1 for each backend. Both point to their own 'backendconfiguration nodes - mssqlConfiguration and oracleConfiguration. These configurations point to a common mapping node - 'commonMapping.
You can switch between the 2 backends using the connection id. You will need to remove/comment out the <extension key="db-do-not-create-table" value="true" /> node for each table so that the table gets created for oracle.
Do get back to us in case you need further assitance.
Best wishes,
Ady
the Telerik team
Do you want to have your say when we set our development plans?
Do you want to know when a feature you care about is added or when a bug fixed?
Explore the
Telerik Public Issue Tracking
system and vote to affect the priority of the items.