Developing ASP.NET 2.0 Applications with the Microsoft Data Access Application Block - Configuring a connection string
(Page 4 of 5 )
In general, we must embed a database connection string within the "web.config" file belonging to the solution. We will do that here as well, but we do it using the Enterprise Library Configuration.
Once you have completed all the steps in the previous section, work through the following steps to configure the database connection string using the Enterprise Library Configuration:
- Within the solution explorer, right click on "web.config" and go to the "open with" option. You will be presented with the "Open With" dialog box.
- Within the same dialog box, click on "Add" and provide the "Program Name" of "D:Program FilesMicrosoft Enterprise Library January 2006binEntLibConfig.exe" (please modify it according to your installation).
- Provide a Friendly name of "Enterprise Library Configuration Editor." (Fig 04)
- Click "OK" twice. It will automatically open the Enterprise Library Configuration window.
- If you can already see the Data Access Application Block, you need not create another one. However, if you don’t see it, you need to create it by simply right clicking on the path and selecting New -> Data Access Application Block.
- Now, right click on "Connection Strings" and go to New -> Connection String. (Fig 05)
- Provide the name of the connection string, "AdventureWorks." (Fig 06)
- Provide the name of the database, "AdventureWorks." (Fig 07)
- Similarly, provide the name of server and integrated security. If you want to use SQL Server security, you can right click on the connection string AdventureWorks, go to new -> connection string parameter and provide any number of other connection string parameters as required.
- Once the connection string is configured, click on save and close the Enterprise Library Configuration window.
Once the above steps are completed, you should see something like the following in your web.config file.
<configSections>
<section name="dataConfiguration" type="Microsoft.Practices.
EnterpriseLibrary.Data.Configuration.DatabaseSettings, Microsoft.Practices.EnterpriseLibrary.Data, Version=2.0.0.0, Culture=neutral, PublicKeyToken=null"/>
</configSections>
<connectionStrings>
<add name="AdventureWorks" connectionString=
"AdventureWorks=Database;Server=(local)SQL2k5;Integrated Security=SSPI;"
providerName="System.Data.SqlClient"/>
</connectionStrings>
<appSettings/>
Next: Developing the code >>
More ASP.NET Articles
More By Jagadish Chaterjee
