Here are my answers to your questions:
1) You can simply do that with the config editor. Go to Blocks > Add Configuration Settings. Then on Sources, click the "+" then Add Sources > Add Sql Server Configuration Source. Then add the redirected sections like shown below:
2) Create an instance of SqlConfigurationSource then call the Add method. Here is an example snippet:
SqlConfigurationSource source = new SqlConfigurationSource(new SqlConfigurationDb([connection string to the database]));
source.Add([section name], [the actual configuration section]);
3) Yes, it should pick up the config settings given that you've set up your sql config source properly.
4) Of course you need to have a reference to Microsoft.Practices.EnterpriseLibrary.SqlConfigurationSource.dll and also have a connection with your database.
5) Its not encrypted by default. You must do the encryption yourself.
6) Im not sure with this one but according to the ReadMe file:
"The <connectionStrings> section is treated specially. The contents of <connectionStrings> will be stored both in the configuration file AND in the database. If the two sections differ, Enterprise Library Data Access Block usage will use
the settings from the database, while other data access will be pulling connection strings from the file."
7) Pretty much the same with #1 and #2 :)
8) Try to put the Microsoft.Practices.EnterpriseLibrary.SqlConfigurationSource.dll to C:\Program Files\Microsoft Enterprise Library 5.0\Bin
Hope I answered all your questions :)
Noel Angelo Bolasoc
Global Technologies and Solutions