/// <summary>
///
/// </summary>
/// <param name="connectString"></param>
/// <param name="getStoredProcedure"></param>
/// <param name="setStoredProcedure"></param>
/// <param name="refreshStoredProcedure"></param>
/// <param name="removeStoredProcedure"></param>
public SqlConfigurationSystem(
string connectString,
string getStoredProcedure,
string setStoredProcedure,
string refreshStoredProcedure,
string removeStoredProcedure)
{
this.data = new SqlConfigurationData(connectString, getStoredProcedure, setStoredProcedure, refreshStoredProcedure, removeStoredProcedure);
}
/// <summary>
///
/// </summary>
/// <param name="data"></param>
/// <param name="refresh"></param>
public SqlConfigurationSourceImplementation(SqlConfigurationData data, bool refresh)
{
this.data = new SqlConfigurationData(data);
this.refresh = refresh;
this.watchedConfigSourceMapping = new Dictionary<string, ConfigurationSourceWatcher>();
this.watchedSectionMapping = new Dictionary<string, ConfigurationSourceWatcher>();
}
/// <summary>
///
/// </summary>
/// <param name="connectionString"></param>
/// <param name="getStoredProc"></param>
/// <param name="saveStoredProc"></param>
/// <param name="refreshStoredProc"></param>
/// <param name="removeStoredProc"></param>
public SqlConfigurationParameter(
string connectionString,
string getStoredProc,
string saveStoredProc,
string refreshStoredProc,
string removeStoredProc)
{
this.data = new SqlConfigurationData(connectionString, getStoredProc, saveStoredProc, refreshStoredProc, removeStoredProc);
}
/// <summary>
///
/// </summary>
/// <param name="connectString"></param>
/// <param name="getStoredProcedure"></param>
/// <param name="setStoredProcedure"></param>
/// <param name="refreshStoredProcedure"></param>
/// <param name="removeStoredProcedure"></param>
public SqlConfigurationSystem(
string connectString,
string getStoredProcedure,
string setStoredProcedure,
string refreshStoredProcedure,
string removeStoredProcedure)
{
this.data = new SqlConfigurationData(connectString, getStoredProcedure, setStoredProcedure, refreshStoredProcedure, removeStoredProcedure);
}
/// <summary>
///
/// </summary>
/// <param name="connectionString"></param>
/// <param name="getStoredProc"></param>
/// <param name="saveStoredProc"></param>
/// <param name="refreshStoredProc"></param>
/// <param name="removeStoredProc"></param>
public SqlConfigurationParameter(
string connectionString,
string getStoredProc,
string saveStoredProc,
string refreshStoredProc,
string removeStoredProc)
{
this.data = new SqlConfigurationData(connectionString, getStoredProc, saveStoredProc, refreshStoredProc, removeStoredProc);
}
/// <summary>
/// Retrieves a specified configuration section for the current application's configuration
/// </summary>
/// <param name="sectionName">The configuration section name.</param>
/// <param name="data">The configuration data for this connection.</param>
/// <returns>The specified System.Configuration.ConfigurationSection object, or null if the section does not exist.</returns>
public static object GetSection(string sectionName, SqlConfigurationData data)
{
if (string.IsNullOrEmpty(sectionName))
{
return null;
}
SqlConfigurationManager.PrepareConfigSystem(data);
return SqlConfigurationManager.configSystem.GetSection(sectionName);
}
public void Initialize()
{
string connectString1 = @"server=(local)\SQLExpress;database=Northwind;Integrated Security=true";
string connectString2 = @"server=(local)\SQLExpress;database=Northwind;";
string getSproc = @"EntLib_GetConfig";
string setStoredProc = @"EntLib_SetConfig";
string refreshStoredProc = @"UpdateSectionDate";
string removeStoredProc = @"EntLib_RemoveSection";
data1 = new SqlConfigurationData(connectString1, getSproc, setStoredProc, refreshStoredProc, removeStoredProc);
data2 = new SqlConfigurationData(connectString2, getSproc, setStoredProc, refreshStoredProc, removeStoredProc);
}
///// <summary>
/////
///// </summary>
///// <param name="connectString"></param>
///// <param name="getStoredProc"></param>
///// <param name="setStoredProc"></param>
///// <param name="refreshStoredProc"></param>
///// <param name="removeStoredProc"></param>
//[TargetConstructor]
//public SqlConfigurationSource(
// [Value("ConnectionString")]string connectString,
// [Value("GetStoredProcedure")]string getStoredProc,
// [Value("SetStoredProcedure")]string setStoredProc,
// [Value("RefreshStoredProcedure")]string refreshStoredProc,
// [Value("RemoveStoredProcedure")]string removeStoredProc
// )
//{
// if (string.IsNullOrEmpty(connectString)) throw new ArgumentException(Resources.ExceptionStringNullOrEmpty, "connectString");
// if (string.IsNullOrEmpty(getStoredProc)) throw new ArgumentException(Resources.ExceptionStringNullOrEmpty, "getStoredProc");
// if (string.IsNullOrEmpty(setStoredProc)) throw new ArgumentException(Resources.ExceptionStringNullOrEmpty, "setStoredProc");
// if (string.IsNullOrEmpty(refreshStoredProc)) throw new ArgumentException(Resources.ExceptionStringNullOrEmpty, "refreshStoredProc");
// if (string.IsNullOrEmpty(removeStoredProc)) throw new ArgumentException(Resources.ExceptionStringNullOrEmpty, "removeStoredProc");
// this.data = new SqlConfigurationData(connectString, getStoredProc, setStoredProc, refreshStoredProc, removeStoredProc);
// EnsureImplementation(data);
//}
/// <summary>
///
/// </summary>
/// <param name="connectString"></param>
/// <param name="getStoredProc"></param>
/// <param name="setStoredProc"></param>
/// <param name="refreshStoredProc"></param>
/// <param name="removeStoredProc"></param>
public SqlConfigurationSource(
string connectString,
string getStoredProc,
string setStoredProc,
string refreshStoredProc,
string removeStoredProc
)
{
if (string.IsNullOrEmpty(connectString)) throw new ArgumentException(Resources.ExceptionStringNullOrEmpty, "connectString");
if (string.IsNullOrEmpty(getStoredProc)) throw new ArgumentException(Resources.ExceptionStringNullOrEmpty, "getStoredProc");
if (string.IsNullOrEmpty(setStoredProc)) throw new ArgumentException(Resources.ExceptionStringNullOrEmpty, "setStoredProc");
if (string.IsNullOrEmpty(refreshStoredProc)) throw new ArgumentException(Resources.ExceptionStringNullOrEmpty, "refreshStoredProc");
if (string.IsNullOrEmpty(removeStoredProc)) throw new ArgumentException(Resources.ExceptionStringNullOrEmpty, "removeStoredProc");
this.data = new SqlConfigurationData(connectString, getStoredProc, setStoredProc, refreshStoredProc, removeStoredProc);
EnsureImplementation(data);
}
public void Setup()
{
string connectString = @"server=(local)\SQLExpress;database=Northwind;Integrated Security=true";
string getStoredProc = @"EntLib_GetConfig";
string setStoredProc = @"EntLib_SetConfig";
string refreshStoredProc = @"UpdateSectionDate";
string removeStoredProc = @"EntLib_RemoveSection";
this.data = new SqlConfigurationData(connectString, getStoredProc, setStoredProc, refreshStoredProc, removeStoredProc);
SqlConfigurationSource.ResetImplementation(data, false);
System.Configuration.Configuration rwConfiguration = ConfigurationManager.OpenExeConfiguration(ConfigurationUserLevel.None);
DummySection rwSection;
rwConfiguration.Sections.Remove(localSection);
rwConfiguration.Sections.Add(localSection, rwSection = new DummySection());
rwSection.Name = localSection;
rwSection.Value = 10;
SqlConfigurationSourceImplementation configSourceImpl = new SqlConfigurationSourceImplementation(this.data, false);
configSourceImpl.SaveSection(rwSection.Name,rwSection);
rwConfiguration.Sections.Remove(externalSection);
rwConfiguration.Sections.Add(externalSection, rwSection = new DummySection());
rwSection.Name = externalSection;
rwSection.Value = 20;
configSourceImpl.SaveSection(rwSection.Name, rwSection);
rwConfiguration.Sections.Remove(localSection2);
rwConfiguration.Sections.Add(localSection2, rwSection = new DummySection());
rwSection.Name = localSection2;
rwSection.Value = 30;
configSourceImpl.SaveSection(rwSection.Name, rwSection);
rwConfiguration.Save();
SqlConfigurationManager.RefreshSection(localSection, this.data);
SqlConfigurationManager.RefreshSection(localSection2, this.data);
SqlConfigurationManager.RefreshSection(externalSection, this.data);
ConfigurationChangeSqlWatcher.ResetDefaultPollDelay();
updatedSectionsTally = new Dictionary<string, int>(0);
}
private static void EnsureImplementation(SqlConfigurationData data)
{
if (!implementationByConnectionString.ContainsKey(data.ConnectionString))
{
lock (lockObject)
{
SqlConfigurationSourceImplementation implementation = new SqlConfigurationSourceImplementation(data);
implementationByConnectionString.Add(data.ConnectionString, implementation);
}
}
}
/// <summary>
/// <exclude>For unit testing purposes.</exclude>
/// </summary>
/// <param name="data"></param>
/// <returns></returns>
public static SqlConfigurationSourceImplementation GetImplementation(SqlConfigurationData data)
{
EnsureImplementation(data);
string connectString = data.ConnectionString;
return (implementationByConnectionString.ContainsKey(connectString)) ? implementationByConnectionString[connectString] : null;
}
/// <summary>
/// <exclude>For unit testing purposes.</exclude>
/// </summary>
public static void ResetImplementation(SqlConfigurationData data, bool refreshing)
{
SqlConfigurationSourceImplementation currentImplementation = null;
implementationByConnectionString.TryGetValue(data.ConnectionString, out currentImplementation);
implementationByConnectionString[data.ConnectionString] =
new SqlConfigurationSourceImplementation(data.ConnectionString, data.GetStoredProcedure, data.SetStoredProcedure, data.RefreshStoredProcedure, data.RemoveStoredProcedure, refreshing);
if (currentImplementation != null)
{
currentImplementation.Dispose();
}
}
public void SharedConfigurationFilesCanHaveDifferentCasing()
{
SqlConfigurationSourceImplementation configSourceImpl1 = SqlConfigurationSource.GetImplementation(data1);
SqlConfigurationData tempData = new SqlConfigurationData(
data1.ConnectionString.ToUpper(),
data1.GetStoredProcedure.ToUpper(),
data1.SetStoredProcedure.ToUpper(),
data1.RefreshStoredProcedure.ToUpper(),
data1.RemoveStoredProcedure.ToUpper());
SqlConfigurationSourceImplementation configSourceImpl2 = SqlConfigurationSource.GetImplementation(tempData);
Assert.AreSame(configSourceImpl1, configSourceImpl2);
}
/// <summary>
///
/// </summary>
/// <param name="sectionName"></param>
/// <param name="section"></param>
/// <param name="data"></param>
public static void SaveSection(string sectionName, SerializableConfigurationSection section, SqlConfigurationData data)
{
if (!string.IsNullOrEmpty(sectionName))
{
SqlConfigurationManager.PrepareConfigSystem(data);
SqlConfigurationManager.configSystem.SaveSection(sectionName, section);
}
}
/// <summary>
///
/// </summary>
/// <param name="data"></param>
public SqlConfigurationSourceImplementation(SqlConfigurationData data)
: this(data, true)
{
}
private static void EnsureConfigurationSystem(SqlConfigurationData data)
{
lock (SqlConfigurationManager.initLock)
{
if (SqlConfigurationManager.initState >= SqlConfigurationManager.InitState.Usable)
{
return;
}
SqlConfigurationManager.initState = SqlConfigurationManager.InitState.Started;
try
{
try
{
SqlConfigurationManager.configSystem = new SqlConfigurationSystem(data);
SqlConfigurationManager.initState = SqlConfigurationManager.InitState.Usable;
}
catch (Exception exception1)
{
throw new ConfigurationErrorsException(Properties.Resources.ExceptionConfigurationInitialization, exception1);
}
}
catch
{
SqlConfigurationManager.initState = SqlConfigurationManager.InitState.Completed;
throw;
}
}
}
/// <summary>
///
/// </summary>
/// <param name="sectionName"></param>
/// <param name="data"></param>
public static void RemoveSection(string sectionName, SqlConfigurationData data)
{
if (!string.IsNullOrEmpty(sectionName))
{
SqlConfigurationManager.PrepareConfigSystem(data);
SqlConfigurationManager.configSystem.RemoveSection(sectionName);
}
}
/// <summary>
///
/// </summary>
/// <param name="name"></param>
/// <param name="data"></param>
public SqlConfigurationData(string name, SqlConfigurationData data)
: this(name, data.ConnectionString, data.GetStoredProcedure, data.SetStoredProcedure, data.RefreshStoredProcedure, data.RemoveStoredProcedure)
{
}
private static void PrepareConfigSystem(SqlConfigurationData data)
{
if (SqlConfigurationManager.initState < SqlConfigurationManager.InitState.Usable)
{
SqlConfigurationManager.EnsureConfigurationSystem(data);
}
}
/// <summary>
///
/// </summary>
public SqlConfigurationSystem(SqlConfigurationData data)
{
this.data = new SqlConfigurationData(data);
}
/// <summary>
///
/// </summary>
public SqlConfigurationSystem(SqlConfigurationData data)
{
this.data = new SqlConfigurationData(data);
}
public void TestInitialize()
{
string connectString = @"server=(local)\SQLExpress;database=Northwind;Integrated Security=true";
string getStoredProc= @"EntLib_GetConfig";
string setStoredProc= @"EntLib_SetConfig";
string refreshStoredProc= @"UpdateSectionDate";
string removeStoredProc = @"EntLib_RemoveSection";
this.data = new SqlConfigurationData(connectString, getStoredProc, setStoredProc, refreshStoredProc, removeStoredProc);
ClearConfigs();
}
/// <summary>
///
/// </summary>
/// <param name="name"></param>
/// <param name="data"></param>
public SqlConfigurationData(string name, SqlConfigurationData data)
: this(name, data.ConnectionString, data.GetStoredProcedure, data.SetStoredProcedure, data.RefreshStoredProcedure, data.RemoveStoredProcedure)
{
}
