oracle database connection in web.config asp.net

Question

I know I can create a connection string in the c# class itself, but I am trying to avoid doing that. I want to create the connection in the web.config, which I read is more secure. Nevertheless I couldn't find any example that has the following attributes specified:

• Host name
• Port
• SID
• Username
• Password
• Connection Name

Could anyone help please with creating this in webconfig? I am connecting to oracle DB.

Solution 1

Here is the template:

     <connectionStrings>
        <add name="{ConnectionName}" 
        connectionString="Data Source=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=MyHost)(PORT=MyPort)))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=MyOracleSID)));User Id=myUsername;Password=myPassword;" 
        providerName="Oracle.DataAccess.Client"/>
     </connectionStrings>

Here is one of mine - minus a real TNS name and username and password:

    <add name="MSOL" connectionString="Data Source={TNS_NAME};User ID={username};Password={password};pooling=true;min pool size=5;Max Pool Size=60" providerName="Oracle.DataAccess.Client"/>

Solution 2

After adding the connection string to the web.config you can use the following:

System.Configuration.ConfigurationManager.ConnectionStrings["connectionStringName"].ConnectionString;

to retrieve the connection string.

Comments

[sys_debug]

How may I use this in webconfig?

[Mark Longmire]

Thank you. The providerName was the piece missing for me.