/// <summary>
///
/// </summary>
/// <param name="removeParameter"></param>
/// <param name="sectionName"></param>
public void Remove(IConfigurationParameter removeParameter, string sectionName)
{
if (null == removeParameter)
{
throw new ArgumentException(string.Format(Resources.Culture, Resources.ExceptionUnexpectedType, typeof(SqlConfigurationParameter).Name), "removeParameter");
}
SqlConfigurationParameter parameter = removeParameter as SqlConfigurationParameter;
Remove(parameter.ConnectionString, parameter.RemoveStoredProcedure, sectionName);
}
private SqlConfigurationParameter CreateParameter()
{
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";
SqlConfigurationParameter parameter = new SqlConfigurationParameter(connectString, getStoredProc, setStoredProc, refreshStoredProc, removeStoredProc);
return(parameter);
}
/// <summary>
///
/// </summary>
/// <param name="saveParameter"></param>
/// <param name="sectionName"></param>
/// <param name="configurationSection"></param>
public void Add(IConfigurationParameter saveParameter, string sectionName, ConfigurationSection configurationSection)
{
if (null == saveParameter)
{
throw new ArgumentException(string.Format(Resources.Culture, Resources.ExceptionUnexpectedType, typeof(SqlConfigurationParameter).Name), "saveParameter");
}
if (!(configurationSection is SerializableConfigurationSection))
{
throw new ArgumentException(string.Format(Resources.Culture, Resources.ExceptionUnexpectedType, typeof(SerializableConfigurationSection).Name), "configurationSection");
}
SqlConfigurationParameter parameter = saveParameter as SqlConfigurationParameter;
SerializableConfigurationSection serializableSection =
configurationSection as SerializableConfigurationSection;
Save(parameter.ConnectionString, parameter.SetStoredProcedure, sectionName, serializableSection);
}
public void DifferentSqlConfigurationSourcesDoNotShareEvents()
{
ConfigurationChangeWatcher.SetDefaultPollDelayInMilliseconds(50);
SqlConfigurationSource.ResetImplementation(data1, true);
SystemConfigurationSource.ResetImplementation(true);
bool sysSourceChanged = false;
bool otherSourceChanged = false;
SystemConfigurationSource systemSource = new SystemConfigurationSource();
DummySection sysDummySerializableSection = systemSource.GetSection(localSection) as DummySection;
SqlConfigurationSource otherSource = new SqlConfigurationSource(
data1.ConnectionString,
data1.GetStoredProcedure,
data1.SetStoredProcedure,
data1.RefreshStoredProcedure,
data1.RemoveStoredProcedure);
SqlConfigurationParameter parameter = new SqlConfigurationParameter(
data1.ConnectionString,
data1.GetStoredProcedure,
data1.SetStoredProcedure,
data1.RefreshStoredProcedure,
data1.RemoveStoredProcedure);
otherSource.Add(parameter, localSection, sysDummySerializableSection);
DummySection otherDummySerializableSection = otherSource.GetSection(localSection) as DummySection;
Assert.IsTrue(sysDummySerializableSection != null);
Assert.IsTrue(otherDummySerializableSection != null);
systemSource.AddSectionChangeHandler(localSection, delegate(object o, ConfigurationChangedEventArgs args)
{
sysSourceChanged = true;
});
otherSource.AddSectionChangeHandler(localSection, delegate(object o, ConfigurationChangedEventArgs args)
{
Assert.AreEqual(12, ((DummySection)otherSource.GetSection(localSection)).Value);
otherSourceChanged = true;
});
DummySection rwSection = new DummySection();
System.Configuration.Configuration rwConfiguration = ConfigurationManager.OpenMachineConfiguration();
rwConfiguration.Sections.Remove(localSection);
rwConfiguration.Sections.Add(localSection, rwSection = new DummySection());
rwSection.Name = localSection;
rwSection.Value = 12;
rwSection.SectionInformation.ConfigSource = data1.ConnectionString;
SqlConfigurationManager.SaveSection(rwSection.Name, rwSection, data1);
Thread.Sleep(200);
Assert.AreEqual(false, sysSourceChanged);
Assert.AreEqual(true, otherSourceChanged);
}
