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;
}
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);
}
