private static DatabaseSettings GenerateDatabaseSettings()
{
DatabaseSettings settings = new DatabaseSettings();
settings.DefaultDatabase = "Service_Dflt";
settings.ProviderMappings.Add(new DbProviderMapping("Oracle.DataAccess.Client", "MedicalInsuranceService.Data.OracleDatabase, MedicalInsuranceService.Data, Version=1.0.0.0, Culture=neutral, PublicKeyToken=null"));
return settings;
}
public void SetUp()
{
settings = new CacheManagerSettings();
dbSettings = new DatabaseSettings();
configurationSource = new DictionaryConfigurationSource();
configurationSource.Add(CacheManagerSettings.SectionName, settings);
configurationSource.Add(DatabaseSettings.SectionName, dbSettings);
}
private static DatabaseSettings GenerateDataSettings()
{
DatabaseSettings settings = new DatabaseSettings();
settings.DefaultInstance = "Service_Dflt";
settings.DatabaseTypes.Add( new DatabaseTypeData("SqlServer", typeof(SqlDatabase).AssemblyQualifiedName));
settings.DatabaseTypes.Add( new DatabaseTypeData("Oracle", typeof(OracleDatabase).AssemblyQualifiedName));
ConnectionStringData data = new ConnectionStringData("OracleTest");
data.Parameters.Add(new ParameterData("server","entlib"));
data.Parameters.Add(new ParameterData("user id","testuser"));
data.Parameters.Add(new ParameterData("password","testuser"));
settings.ConnectionStrings.Add(data);
data = new ConnectionStringData("NewDatabase");
data.Parameters.Add(new ParameterData("server","localhost"));
data.Parameters.Add(new ParameterData("database","Northwind"));
data.Parameters.Add(new ParameterData("Integrated Security","true"));
settings.ConnectionStrings.Add(data);
data = new ConnectionStringData("DbWithSqlServerAuthn");
data.Parameters.Add(new ParameterData("server","localhost"));
data.Parameters.Add(new ParameterData("database","Northwind"));
data.Parameters.Add(new ParameterData("uid","sa"));
data.Parameters.Add(new ParameterData("pwd","mypassword"));
settings.ConnectionStrings.Add(data);
data = new ConnectionStringData("Northwind");
data.Parameters.Add(new ParameterData("server","localhost"));
data.Parameters.Add(new ParameterData("database","Northwind"));
data.Parameters.Add(new ParameterData("Integrated Security","true"));
settings.ConnectionStrings.Add(data);
data = new ConnectionStringData("EntLibQuickStarts");
data.Parameters.Add(new ParameterData("server","localhost"));
data.Parameters.Add(new ParameterData("database","EntLibQuickStarts"));
data.Parameters.Add(new ParameterData("Integrated Security","true"));
settings.ConnectionStrings.Add(data);
data = new ConnectionStringData("NorthwindPersistFalse");
data.Parameters.Add(new ParameterData("server","localhost"));
data.Parameters.Add(new ParameterData("database","Northwind"));
data.Parameters.Add(new ParameterData("uid","entlib"));
data.Parameters.Add(new ParameterData("pwd","sunrain"));
data.Parameters.Add(new ParameterData("Persist Security Info", "false"));
settings.ConnectionStrings.Add(data);
settings.Instances.Add( new InstanceData("NewDatabase", "SqlServer", "NewDatabase"));
settings.Instances.Add( new InstanceData("Service_Dflt", "SqlServer", "Northwind"));
settings.Instances.Add( new InstanceData("EntLibQS", "SqlServer", "EntLibQuickStarts"));
settings.Instances.Add( new InstanceData("DbWithSqlServerAuthn", "SqlServer", "DbWithSqlServerAuthn"));
settings.Instances.Add( new InstanceData("NorthwindPersistFalse", "SqlServer", "NorthwindPersistFalse"));
settings.Instances.Add( new InstanceData("OracleTest", "Oracle", "OracleTest"));
return settings;
}
private void InitializeSubordinateSectionViewModels(DatabaseSettings databaseSettings, OracleConnectionSettings oracleSettings)
{
if (databaseSettings == null) databaseSettings = new DatabaseSettings();
dataSettingsViewModel = CreateSubordinateModel(DatabaseSettings.SectionName, databaseSettings);
elementLookup.AddSection(dataSettingsViewModel);
if (oracleSettings == null) oracleSettings = new OracleConnectionSettings();
oracleSettingsViewModel = CreateSubordinateModel(OracleConnectionSettings.SectionName, oracleSettings);
elementLookup.AddSection(oracleSettingsViewModel);
}
public void CreateNamedDatabaseInstanceWithDictSource()
{
DictionaryConfigurationSource source = new DictionaryConfigurationSource();
DatabaseSettings settings = new DatabaseSettings();
ConnectionStringsSection connSection = GetConnectionStringsSection();
source.Add("dataConfiguration", settings);
source.Add("connectionStrings", connSection);
DatabaseProviderFactory factory = new DatabaseProviderFactory(source);
Database dbIns = factory.Create(instanceName);
Assert.IsNotNull(dbIns);
}
void IAddTo.AddTo(IConfigurationSource configurationSource)
{
var section = new ConnectionStringsSection();
foreach(var builder in builders)
{
builder.AddTo(section);
}
configurationSource.Add("connectionStrings", section);
var databaseSettings = new DatabaseSettings {DefaultDatabase = defaultDatabase};
configurationSource.Add(DatabaseSettings.SectionName, databaseSettings);
}
public void WillGetDefaultMappingIfProviderTypeIsNotMappedAndDefaultExistsForSql()
{
DatabaseSettings databaseSettings = new DatabaseSettings();
DictionaryConfigurationSource source = new DictionaryConfigurationSource();
source.Add(DatabaseSettings.SectionName, databaseSettings);
DatabaseConfigurationView view = new DatabaseConfigurationView(source);
DbProviderMapping mapping = view.GetProviderMapping("ignore", DbProviderMapping.DefaultSqlProviderName);
Assert.IsNotNull(mapping);
Assert.AreEqual(DbProviderMapping.DefaultSqlProviderName, mapping.DbProviderName);
Assert.AreEqual(typeof(SqlDatabase), mapping.DatabaseType);
}
public void WillGetDefaultMappingIfProviderTypeIsNotMappedAndDefaultExistsForOracle()
{
DatabaseSettings databaseSettings = new DatabaseSettings();
DictionaryConfigurationSource source = new DictionaryConfigurationSource();
source.Add(DatabaseSettings.SectionName, databaseSettings);
DatabaseSyntheticConfigSettings settings = new DatabaseSyntheticConfigSettings(source);
DbProviderMapping mapping = settings.GetProviderMapping(DbProviderMapping.DefaultOracleProviderName);
Assert.IsNotNull(mapping);
Assert.AreEqual(DbProviderMapping.DefaultOracleProviderName, mapping.DbProviderName);
Assert.AreEqual(typeof(OracleDatabase), mapping.DatabaseType);
}
public void DatabaseCreatedByProviderFactoryIsGenericIfNoProviderMapping()
{
DictionaryConfigurationSource source = new DictionaryConfigurationSource();
DatabaseSettings settings = new DatabaseSettings();
ConnectionStringsSection connSection = GetConnectionStringsSection();
source.Add("dataConfiguration", settings);
source.Add("connectionStrings", connSection);
DatabaseProviderFactory factory = new DatabaseProviderFactory(source);
Database db = factory.Create(instanceName);
Assert.IsNotNull(db);
Assert.AreSame(typeof(GenericDatabase), db.GetType());
}
public void WillGetMappedProviderTypeEvenIfDefaultExists()
{
DatabaseSettings databaseSettings = new DatabaseSettings();
databaseSettings.ProviderMappings.Add(new DbProviderMapping(DbProviderMapping.DefaultSqlProviderName, typeof(GenericDatabase)));
DictionaryConfigurationSource source = new DictionaryConfigurationSource();
source.Add(DatabaseSettings.SectionName, databaseSettings);
DatabaseConfigurationView view = new DatabaseConfigurationView(source);
DbProviderMapping mapping = view.GetProviderMapping("ignore", DbProviderMapping.DefaultSqlProviderName);
Assert.IsNotNull(mapping);
Assert.AreEqual(DbProviderMapping.DefaultSqlProviderName, mapping.DbProviderName);
Assert.AreEqual(typeof(GenericDatabase), mapping.DatabaseType);
}
public static DictionaryConfigurationSource CreateConfigurationSource()
{
DictionaryConfigurationSource source = new DictionaryConfigurationSource();
DatabaseSettings settings = new DatabaseSettings();
settings.DefaultDatabase = "SqlCeTestConnection";
ConnectionStringsSection section = new ConnectionStringsSection();
section.ConnectionStrings.Add(new ConnectionStringSettings("SqlCeTestConnection", "Data Source='testdb.sdf'", "System.Data.SqlServerCe.3.5"));
source.Add(DatabaseSettings.SectionName, settings);
source.Add("connectionStrings", section);
return source;
}
private static DatabaseSettings GenerateDataSettings()
{
DatabaseSettings settings = new DatabaseSettings();
settings.DatabaseTypes.Add( new DatabaseTypeData("DB2", typeof(DB2Database).AssemblyQualifiedName));
ConnectionStringData data = new ConnectionStringData("DB2Test");
data.Parameters.Add(new ParameterData("server","entlib01"));
data.Parameters.Add(new ParameterData("database","sample"));
data.Parameters.Add(new ParameterData("user id","administrator"));
data.Parameters.Add(new ParameterData("password","Pag$1Lab"));
settings.ConnectionStrings.Add(data);
settings.Instances.Add( new InstanceData("DB2Test", "DB2", "DB2Test"));
return settings;
}
public void WillGetMappedProviderType()
{
DatabaseSettings databaseSettings = new DatabaseSettings();
databaseSettings.ProviderMappings.Add(new DbProviderMapping(OdbcProviderName, typeof(GenericDatabase)));
DictionaryConfigurationSource source = new DictionaryConfigurationSource();
source.Add(DatabaseSettings.SectionName, databaseSettings);
DatabaseSyntheticConfigSettings settings = new DatabaseSyntheticConfigSettings(source);
DbProviderMapping mapping = settings.GetProviderMapping(OdbcProviderName);
Assert.IsNotNull(mapping);
Assert.AreEqual(OdbcProviderName, mapping.DbProviderName);
Assert.AreEqual(typeof(GenericDatabase), mapping.DatabaseType);
}
protected override void Arrange()
{
base.Arrange();
var builder = new ConfigurationSourceBuilder();
builder.ConfigureData()
.ForDatabaseNamed("someDatabase")
.AsDefault();
var source = new DictionaryConfigurationSource();
builder.UpdateConfigurationWithReplace(source);
ElementLookup = Container.Resolve<ElementLookup>();
DatabaseSection = (DatabaseSettings)source.GetSection(DatabaseSettings.SectionName);
}
public static DictionaryConfigurationSource CreateConfigurationSource()
{
DictionaryConfigurationSource source = new DictionaryConfigurationSource();
DatabaseSettings settings = new DatabaseSettings();
settings.DefaultDatabase = "Service_Dflt";
OracleConnectionSettings oracleConnectionSettings = new OracleConnectionSettings();
OracleConnectionData data = new OracleConnectionData();
data.Name = "OracleTest";
data.Packages.Add(new OraclePackageData("TESTPACKAGE", "TESTPACKAGETOTRANSLATE"));
oracleConnectionSettings.OracleConnectionsData.Add(data);
source.Add(DatabaseSettings.SectionName, settings);
source.Add(OracleConnectionSettings.SectionName, oracleConnectionSettings);
return source;
}
public static DictionaryConfigurationSource CreateConfigurationSource()
{
DictionaryConfigurationSource source = new DictionaryConfigurationSource();
DatabaseSettings settings = new DatabaseSettings();
settings.DefaultDatabase = "Service_Dflt";
settings.ProviderMappings.Add(new DbProviderMapping("Oracle.ManagedDataAccess.Client", "EntLibContrib.Data.Oracle.ManagedDataAccess.OracleDatabase, EntLibContrib.Data.Oracle.ManagedDataAccess, Version=1.0.0.0, Culture=neutral, PublicKeyToken=null"));
OracleConnectionSettings oracleConnectionSettings = new OracleConnectionSettings();
OracleConnectionData data = new OracleConnectionData();
data.Name = "OracleTest";
data.Packages.Add(new OraclePackageData("TESTPACKAGE", "TESTPACKAGETOTRANSLATE"));
data.Packages.Add(new OraclePackageData("PKGNORTHWIND", "NWND_"));
data.Packages.Add(new OraclePackageData("PKGENTLIB", "RegionSelect"));
oracleConnectionSettings.OracleConnectionsData.Add(data);
source.Add(DatabaseSettings.SectionName, settings);
source.Add(OracleConnectionSettings.SectionName, oracleConnectionSettings);
return source;
}
public void CanDeserializeSerializedSettings()
{
ExeConfigurationFileMap fileMap = new ExeConfigurationFileMap();
fileMap.ExeConfigFilename = "test.exe.config";
SysConf.Configuration rwConfiguration = ConfigurationManager.OpenMappedExeConfiguration(fileMap, ConfigurationUserLevel.None);
rwConfiguration.Sections.Remove(DatabaseSettings.SectionName);
DatabaseSettings rwSettings = new DatabaseSettings();
rwConfiguration.Sections.Add(DatabaseSettings.SectionName, rwSettings);
rwSettings.ProviderMappings.Add(new DbProviderMapping(DbProviderMapping.DefaultSqlProviderName, typeof(SqlDatabase)));
rwSettings.ProviderMappings.Add(new DbProviderMapping(OdbcProviderName, typeof(GenericDatabase)));
File.SetAttributes(fileMap.ExeConfigFilename, FileAttributes.Normal);
rwConfiguration.Save();
SysConf.Configuration roConfiguration = ConfigurationManager.OpenMappedExeConfiguration(fileMap, ConfigurationUserLevel.None);
DatabaseSettings roSettings = (DatabaseSettings)roConfiguration.Sections[DatabaseSettings.SectionName];
Assert.AreEqual(2, roSettings.ProviderMappings.Count);
Assert.AreEqual(DbProviderMapping.DefaultSqlProviderName, roSettings.ProviderMappings.Get(0).DbProviderName);
Assert.AreEqual(typeof(SqlDatabase), roSettings.ProviderMappings.Get(0).DatabaseType);
Assert.AreEqual(OdbcProviderName, roSettings.ProviderMappings.Get(1).DbProviderName);
Assert.AreEqual(typeof(GenericDatabase), roSettings.ProviderMappings.Get(1).DatabaseType);
}
private DatabaseData GetDatabaseData(ConnectionStringSettings connectionString, DatabaseSettings databaseSettings)
{
var mapping = GetProviderMapping(connectionString.ProviderName, databaseSettings);
var configurationElementTypeAttribute = GetAttribute(mapping.DatabaseType);
var databaseData =
CreateDatabaseData(configurationElementTypeAttribute.ConfigurationType, connectionString, configurationSource);
return databaseData;
}
private static DatabaseSettings GenerateDatabaseSettings()
{
DatabaseSettings settings = new DatabaseSettings();
return settings;
}
private static bool DaabSettingsAreEmpty(DatabaseSettings databaseSettings)
{
if (!String.IsNullOrEmpty(databaseSettings.DefaultDatabase)) return false;
if (databaseSettings.ProviderMappings.Count > 0) return false;
return true;
}
private static DbProviderMapping GetProviderMapping(string dbProviderName, DatabaseSettings databaseSettings)
{
if (databaseSettings != null)
{
var existingMapping = databaseSettings.ProviderMappings.Get(dbProviderName);
if (existingMapping != null)
{
return existingMapping;
}
}
var defaultMapping = GetDefaultMapping(dbProviderName);
return defaultMapping ?? GetGenericMapping();
}
private DatabaseData GetDatabaseData(ConnectionStringSettings connectionString, DatabaseSettings databaseSettings)
{
var mapping = GetProviderMapping(connectionString.ProviderName, databaseSettings);
var configurationElementTypeAttribute = GetAttribute(mapping.DatabaseType);
var databaseData =
CreateDatabaseData(configurationElementTypeAttribute.ConfigurationType, connectionString, configurationSource);
return(databaseData);
}
/// <summary>
/// This method is made public for unit testing purposes.
/// </summary>
/// <param name="dbProviderName"></param>
/// <returns></returns>
public DbProviderMapping GetProviderMapping(string dbProviderName)
{
DatabaseSettings settings = (DatabaseSettings)configurationSource.GetSection(DatabaseSettings.SectionName);
return(GetProviderMapping(dbProviderName, settings));
}
private static DbProviderMapping GetProviderMapping(string dbProviderName, DatabaseSettings databaseSettings)
{
if (databaseSettings != null)
{
var dbProviderMapping = databaseSettings.ProviderMappings.Get(dbProviderName);
if (dbProviderMapping != null)
{
return dbProviderMapping;
}
}
return GetDefaultMapping(dbProviderName);
}
private DatabaseData GetDatabaseData(ConnectionStringSettings connectionString,
DatabaseSettings databaseSettings)
{
return
CreateDatabaseData(
GetAttribute(GetProviderMapping(connectionString.ProviderName, databaseSettings).DatabaseType)
.ConfigurationType, connectionString);
}
public void Setup()
{
var configSource = new DictionaryConfigurationSource();
var connectionStrings = new ConnectionStringsSection();
connectionStrings.ConnectionStrings.Add(
new ConnectionStringSettings("someSetting", "someConnectionString", "System.Data.Odbc"));
configSource.Add("connectionStrings", connectionStrings);
var databaseSettings = new DatabaseSettings();
databaseSettings.ProviderMappings.Add(new DbProviderMapping("System.Data.Odbc", typeof(TestDatabase)));
configSource.Add(DatabaseSettings.SectionName, databaseSettings);
configSettings = new DatabaseSyntheticConfigSettings(configSource);
}
