public DatabaseConfigurationBuilder(Func <string, ConfigurationSection> configurationAccessor)
{
Guard.ArgumentNotNull(configurationAccessor, "configurationAccessor");
this.settings = new DatabaseSyntheticConfigSettings(configurationAccessor);
this.databases = new ConcurrentDictionary <string, DatabaseData>();
}
public void Setup()
{
var configSource = new DictionaryConfigurationSource();
configSource.Add(DatabaseSettings.SectionName, new DatabaseSettings());
configSettings = new DatabaseSyntheticConfigSettings(configSource.GetSection);
}
public void Context()
{
configurationSource = new DictionaryConfigurationSource();
connectionStringsSection = new ConnectionStringsSection();
connectionStringsSection.ConnectionStrings.Add(
new ConnectionStringSettings
{
Name = "sql connection",
ConnectionString = "connection string",
ProviderName = "System.Data.SqlClient"
});
connectionStringsSection.ConnectionStrings.Add(
new ConnectionStringSettings
{
Name = "odbc connection",
ConnectionString = "odbc connection string",
ProviderName = "System.Data.Odbc"
});
connectionStringsSection.ConnectionStrings.Add(
new ConnectionStringSettings
{
Name = "oracle connection",
ConnectionString = "oracle connection string",
ProviderName = "System.Data.OracleClient"
});
configurationSource.Add("connectionStrings", connectionStringsSection);
settings = new DatabaseSyntheticConfigSettings();
}
public void Given()
{
// Setup connection strings
configurationSource = new DictionaryConfigurationSource();
var connectionStringsSection = new ConnectionStringsSection();
connectionStringsSection.ConnectionStrings.Add(
new ConnectionStringSettings
{
Name = "myConnectionName",
ConnectionString = "myConnectionString",
ProviderName = "System.Data.OracleClient"
}
);
configurationSource.Add("connectionStrings", connectionStringsSection);
// Setup oracle configuration sections
var oracleConnectionData = new OracleConnectionData {
Name = "myConnectionName"
};
oracleConnectionData.Packages.Add(new OraclePackageData("foo", "bar"));
var oracleSettings = new OracleConnectionSettings();
oracleSettings.OracleConnectionsData.Add(oracleConnectionData);
configurationSource.Add(OracleConnectionSettings.SectionName, oracleSettings);
settings = new DatabaseSyntheticConfigSettings(configurationSource.GetSection);
}
public void CanGetConnectionWithoutCredentials()
{
DatabaseSyntheticConfigSettings settings = new DatabaseSyntheticConfigSettings(TestConfigurationSource.CreateConfigurationSource());
ConnectionStringSettings data = settings.GetConnectionStringSettings("DbWithSqlServerAuthn");
SqlDatabase sqlDatabase = new SqlDatabase(data.ConnectionString);
Assert.AreEqual(@"server=(localdb)\v11.0;database=northwind;", sqlDatabase.ConnectionStringWithoutCredentials);
}
public void CanGetConnectionForStringWithNoCredentials()
{
DatabaseSyntheticConfigSettings settings = new DatabaseSyntheticConfigSettings(TestConfigurationSource.CreateConfigurationSource());
ConnectionStringSettings data = settings.GetConnectionStringSettings("NewDatabase");
SqlDatabase sqlDatabase = new SqlDatabase(data.ConnectionString);
Assert.AreEqual(@"server=(localdb)\v11.0;database=northwind;integrated security=true;", sqlDatabase.ConnectionStringWithoutCredentials);
}
public void CanGetConnectionForStringWithNoCredentials()
{
DatabaseSyntheticConfigSettings settings = new DatabaseSyntheticConfigSettings(TestConfigurationSource.CreateConfigurationSource());
ConnectionStringSettings data = settings.GetConnectionStringSettings("NewDatabase");
SqlDatabase sqlDatabase = new SqlDatabase(data.ConnectionString);
Assert.AreEqual(String.Format(@"server={0};database=northwind;integrated security=true;", ConfigurationManager.AppSettings["SqlServerDatabaseInstance"]), sqlDatabase.ConnectionStringWithoutCredentials);
}
public void Setup()
{
var configSource = new DictionaryConfigurationSource();
configSource.Add(DatabaseSettings.SectionName, new DatabaseSettings {
DefaultDatabase = "default"
});
configSettings = new DatabaseSyntheticConfigSettings(configSource);
}
public void WillGetGenericMappingIfDatabaseSettingsSectionDoesNotExist()
{
DictionaryConfigurationSource source = new DictionaryConfigurationSource();
DatabaseSyntheticConfigSettings settings = new DatabaseSyntheticConfigSettings(source);
DbProviderMapping mapping = settings.GetProviderMapping(OdbcProviderName);
Assert.IsNotNull(mapping);
Assert.AreEqual(typeof(GenericDatabase), mapping.DatabaseType);
}
public void WillGetDefaultMappingIfDatabaseSettingsSectionDoesNotExistForSql()
{
DictionaryConfigurationSource source = new DictionaryConfigurationSource();
DatabaseSyntheticConfigSettings settings = new DatabaseSyntheticConfigSettings(source);
DbProviderMapping mapping = settings.GetProviderMapping(DbProviderMapping.DefaultSqlProviderName);
Assert.IsNotNull(mapping);
Assert.AreEqual(DbProviderMapping.DefaultSqlProviderName, mapping.DbProviderName);
Assert.AreEqual(typeof(SqlDatabase), mapping.DatabaseType);
}
public void CanConnectToDb2AndExecuteAReader()
{
var Db2Database = new DatabaseSyntheticConfigSettings(this.configurationSource).GetDatabase("Db2Test").BuildDatabase();
DbConnection connection = Db2Database.CreateConnection();
Assert.IsNotNull(connection);
Assert.IsTrue(connection is iDB2Connection);
connection.Open();
DbCommand cmd = Db2Database.GetSqlStringCommand("Select * from Region");
Db2Database.ExecuteReader(cmd);
}
public void Setup()
{
var configSource = new DictionaryConfigurationSource();
var connectionStrings = new ConnectionStringsSection();
connectionStrings.ConnectionStrings.Add(new ConnectionStringSettings("someSetting", "someConnectionString"));
configSource.Add("connectionStrings", connectionStrings);
configSettings = new DatabaseSyntheticConfigSettings(configSource.GetSection);
}
public void CanConnectToOracleAndExecuteAReader()
{
var oracleDatabase = new DatabaseSyntheticConfigSettings(this.configurationSource).GetDatabase("OracleTest").BuildDatabase();
DbConnection connection = oracleDatabase.CreateConnection();
Assert.IsNotNull(connection);
Assert.IsTrue(connection is OracleConnection);
connection.Open();
DbCommand cmd = oracleDatabase.GetSqlStringCommand("Select * from Region");
cmd.CommandTimeout = 0;
}
public void WillGetGenericMappingIfProviderTypeIsNotMappedAndDefaultDoesNotExist()
{
DatabaseSettings databaseSettings = new DatabaseSettings();
DictionaryConfigurationSource source = new DictionaryConfigurationSource();
source.Add(DatabaseSettings.SectionName, databaseSettings);
DatabaseSyntheticConfigSettings settings = new DatabaseSyntheticConfigSettings(source);
DbProviderMapping mapping = settings.GetProviderMapping(OdbcProviderName);
Assert.IsNotNull(mapping);
Assert.AreEqual(typeof(GenericDatabase), mapping.DatabaseType);
}
public void Setup()
{
var configSource = new DictionaryConfigurationSource();
var connectionStrings = new ConnectionStringsSection();
connectionStrings.ConnectionStrings.Add(
new ConnectionStringSettings("someSetting", "someConnectionString", "System.Data.OracleClient"));
configSource.Add("connectionStrings", connectionStrings);
var oracleSettings = new OracleConnectionSettings();
configSource.Add(OracleConnectionSettings.SectionName, oracleSettings);
configSettings = new DatabaseSyntheticConfigSettings(configSource.GetSection);
}
public void Given()
{
configurationSource = new DictionaryConfigurationSource();
var connectionStringsSection = new ConnectionStringsSection();
connectionStringsSection.ConnectionStrings.Add(
new ConnectionStringSettings
{
Name = "sql connection",
ConnectionString = "connection string",
ProviderName = "System.Data.SqlClient"
});
configurationSource.Add("connectionStrings", connectionStringsSection);
configurationSource.Add(DatabaseSettings.SectionName, new DatabaseSettings());
settings = new DatabaseSyntheticConfigSettings();
}
public void Given()
{
configurationSource = new DictionaryConfigurationSource();
var connectionStringsSection = new ConnectionStringsSection();
connectionStringsSection.ConnectionStrings.Add(
new ConnectionStringSettings
{
Name = "odbc connection",
ConnectionString = "connection string",
ProviderName = "System.Data.Odbc"
});
configurationSource.Add("connectionStrings", connectionStringsSection);
settings = new DatabaseSyntheticConfigSettings(configurationSource.GetSection);
}
public void ConnectionTest()
{
DatabaseSyntheticConfigSettings settings = new DatabaseSyntheticConfigSettings(TestConfigurationSource.CreateConfigurationSource());
ConnectionStringSettings data = settings.GetConnectionStringSettings("NewDatabase");
SqlDatabase sqlDatabase = new SqlDatabase(data.ConnectionString);
DbConnection connection = sqlDatabase.CreateConnection();
Assert.IsNotNull(connection);
Assert.IsTrue(connection is SqlConnection);
connection.Open();
DbCommand cmd = sqlDatabase.GetSqlStringCommand("Select * from Region");
cmd.CommandTimeout = 60;
Assert.AreEqual(cmd.CommandTimeout, 60);
}
public void Setup()
{
var configSource = new DictionaryConfigurationSource();
var connectionStrings = new ConnectionStringsSection();
connectionStrings.ConnectionStrings.Add(new ConnectionStringSettings
{
Name = "someSetting",
ConnectionString = "someConnectionString",
ProviderName = "non registered"
});
configSource.Add("connectionStrings", connectionStrings);
configSettings = new DatabaseSyntheticConfigSettings(configSource.GetSection);
}
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.GetSection);
}
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);
DatabaseSyntheticConfigSettings settings = new DatabaseSyntheticConfigSettings(source);
DbProviderMapping mapping = settings.GetProviderMapping(DbProviderMapping.DefaultSqlProviderName);
Assert.IsNotNull(mapping);
Assert.AreEqual(DbProviderMapping.DefaultSqlProviderName, mapping.DbProviderName);
Assert.AreEqual(typeof(GenericDatabase), mapping.DatabaseType);
}
public void CheckNoPasswordInConnectionStringWithPersistInfoEqualsFalse()
{
try
{
CreateUser();
DatabaseSyntheticConfigSettings settings = new DatabaseSyntheticConfigSettings(TestConfigurationSource.CreateConfigurationSource());
ConnectionStringSettings data = settings.GetConnectionStringSettings("NorthwindPersistFalse");
SqlDatabase sqlDatabase = new SqlDatabase(data.ConnectionString);
DbConnection dbConnection = sqlDatabase.CreateConnection();
dbConnection.Open();
dbConnection.Close();
string connectionString = dbConnection.ConnectionString;
if (connectionString.ToLower().Contains("pwd") || connectionString.ToLower().Contains("password"))
{
Assert.Fail();
}
}
finally
{
DeleteUser();
}
}
public void Setup()
{
var configSource = new DictionaryConfigurationSource();
var connectionStrings = new ConnectionStringsSection();
connectionStrings.ConnectionStrings.Add(
new ConnectionStringSettings("someSetting", "someConnectionString", "System.Data.OracleClient"));
configSource.Add("connectionStrings", connectionStrings);
var oracleConnectionData = new OracleConnectionData {
Name = "someSetting"
};
oracleConnectionData.Packages.Add(new OraclePackageData("foo", "bar"));
var oracleSettings = new OracleConnectionSettings();
oracleSettings.OracleConnectionsData.Add(oracleConnectionData);
configSource.Add(OracleConnectionSettings.SectionName, oracleSettings);
configSettings = new DatabaseSyntheticConfigSettings(configSource.GetSection);
}
/// <summary>
/// Initializes a new instance of the <see cref="DatabaseConfigurationSettings"/> class.
/// </summary>
/// <param name="configSource">The configuration source used to retrieve the database configuration.</param>
internal DatabaseConfigurationSettings(IConfigurationSource configSource)
{
this.databaseSettings = new DatabaseSyntheticConfigSettings(configSource);
}
public void Setup()
{
NetCoreHelpers.RegisterDbProviderFactories();
configSource = new DictionaryConfigurationSource();
configSettings = new DatabaseSyntheticConfigSettings(configSource.GetSection);
}
protected override void Arrange()
{
configurationSource = new DictionaryConfigurationSource();
configurationSource.Add("connectionStrings", new ConnectionStringsSection());
settings = new DatabaseSyntheticConfigSettings();
}
public void Setup()
{
configSource = new DictionaryConfigurationSource();
configSource.Add("connectionStrings", new ConnectionStringsSection());
configSettings = new DatabaseSyntheticConfigSettings(configSource.GetSection);
}
public void Setup()
{
configSource = new DictionaryConfigurationSource();
configSettings = new DatabaseSyntheticConfigSettings(configSource.GetSection);
}
/// <summary>
/// Initializes a new instance of a <see cref="ConnectionStringView"/> object initialized with the specified <see cref="Microsoft.Practices.EnterpriseLibrary.Data.Configuration.DatabaseSyntheticConfigSettings"/> instance.
/// </summary>
/// <param name="databaseSettings">An instance of the <see cref="Microsoft.Practices.EnterpriseLibrary.Data.Configuration.DatabaseSyntheticConfigSettings"/> object providing the collection of connection strings.</param>
public ConnectionStringView(DatabaseSyntheticConfigSettings databaseSettings) : this()
{
Guard.ArgumentNotNull(databaseSettings, "databaseSettings");
this.databaseSettings = databaseSettings;
}
