Sunday, October 12, 2008

Config another better example


<?xml version="1.0" encoding="utf-8" ?>

<configuration>
<!--<configSections>
--><!--<sectionGroup name="MyFirstSection"
type="DBConnectionStringDemo.MyFirstSectionHandler,
DBConnectionStringDemo"/>--><!--
<sectionGroup name="MyFirstSection"/>
</configSections>
<MyFirstSection>
<DemoValues>
<Value>
<Identifier>111</Identifier>
<SettingValue>System.Data.SqlClient</SettingValue>
</Value>
<Value>
<Identifier>112</Identifier>
<SettingValue>System.Data.OleDb</SettingValue>
</Value>
<Value>
<Identifier>113</Identifier>
<SettingValue>System.Data.Odbc</SettingValue>
</Value>
</DemoValues>
</MyFirstSection>-->
<appSettings>
<add key="Foo" value="Hello World!"/>
</appSettings>
<connectionStrings>
<clear/>
<add name="AdventureWorksString"
providerName="System.Data.SqlClient"
connectionString="Data Source=localhost;Initial Catalog=AdventureWorks;
Integrated Security=true"/>
<add name="MarsEnabledSqlServer2005String"
providerName="System.Data.SqlClient"
connectionString="Server=Aron1;Database=pubs;
Trusted_Connection=True;MultipleActiveResultSets=true" />
<add name="NorthWindConnectionString"
providerName="System.Data.SqlClient"
connectionString="Data Source=.\SQLEXPRESS;AttachDbFilename=C:\Users\Noel\SQLExpressDataFiles\NORTHWIND.MDF;Integrated Security=True;Connect Timeout=30;User Instance=True"/>
</connectionStrings>
<system.diagnostics>
<assert assertuienabled="false" logfilename="C:\\Users\\Noel\\Documents\\myAssertFile.txt" />
</system.diagnostics>


</configuration>
using System;
using System.Collections.Generic;
using System.Text;
using System.Configuration;
using System.Diagnostics;
using System.IO;
using System.Collections.Specialized;

namespace ConfigApplication
{
class Program
{
static void Main(string[] args)
{
ExeConfigurationFileMap ecfm = new ExeConfigurationFileMap ();
ecfm.ExeConfigFilename = @".\ConfigApplication.exe.config";
System.Diagnostics.Debug.Assert(File.Exists(ecfm.ExeConfigFilename),
"The mapped file or path is missing or incorrect!");
Configuration c = ConfigurationManager.OpenMappedExeConfiguration(ecfm,
ConfigurationUserLevel.None);
NameValueCollection AllAppSettings = ConfigurationManager.AppSettings;
Console.WriteLine(AllAppSettings["Foo"]);
Console.WriteLine(AllAppSettings[0]);

ConnectionStringSettingsCollection MySettings = ConfigurationManager.ConnectionStrings;
if (MySettings != null)
{
StringBuilder sb = new StringBuilder();
foreach (ConnectionStringSettings individualSettings in MySettings)
{
sb.Append("Full Connection String: " +
individualSettings.ConnectionString + "\r\n");
sb.Append("Provider Name: " + individualSettings.ProviderName + "\r\n");
sb.Append("Section Name: " + individualSettings.Name + "\r\n");
}
Console.WriteLine(sb.ToString());

}

No comments: