Article information
Article relates to	OpenAccess Classic
Created by	Semo Kiskinov
Last modified	October 20, 2009
Last modified by	Semo Kiskinov

This article discuses a common scenario regarding deployment of a web site project, which accesses a database using Telerik OpenAccess ORM.

Scenario:

We are considering a scenario involving a web site that is being developed using the standard procedures for enabling a web site to use Telerik OpenAcess ORM.

By default, all the database connection details are part of the "App.config" file that belongs to the class library where the persistent classes are placed. Having in mind that the class library is deployed as a compiled assembly and it contains the App.config as an embedded resource,  we are  unable to change the database connection details after deployment on a server machine. To be able to do that, we have to let OpenAccess read the connection from the "Web.config" file, which is explained in more details in the section below:

Solution:

To be able to change the database connection settings from "Web.config" after deployment, you need to follow these steps:

1.    Open the “App.config” file from your Class library project that contains the model

2.    Locate the <connections> section


3.    Cut the whole section

4.    Locate the <openaccess> tag in your “Web.config” file


NOTE: If the <openAccess> section is not available in your "Web.config" file, run the Enable Project To Use ORM wizzard on your web site project.

5.    Replace the <connections /> section with the section from the “App.config” file

After this step, your <openaccess> section should have the following form in the "Web.config" file:

6.    Select the Class library project containing the “App.config” file from the Solution explorer

 

7.    In the properties window remove the value of the “ConnectionId” property

At this point, a web application is ready for deployment as an administrator is able to change the database connection settings from the “Web.config” file  and adjust it for usage on any server machine.