public void Setup() { var configSource = new DictionaryConfigurationSource(); configSource.Add(DatabaseSettings.SectionName, new DatabaseSettings { DefaultDatabase = "default" }); configSettings = new DatabaseSyntheticConfigSettings(configSource); }
public void Setup() { var configSource = new DictionaryConfigurationSource(); configSource.Add(DatabaseSettings.SectionName, new DatabaseSettings()); configSettings = new DatabaseSyntheticConfigSettings(configSource.GetSection); }
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 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 ConnectionStringSettings GetConnectionStringSettings(string name) { if (string.IsNullOrEmpty(name)) { throw new ArgumentException(Resources.ExceptionNullOrEmptyString); } ConnectionStringSettings connectionString = this.GetConnectionStrings()[name]; DatabaseSyntheticConfigSettings.ValidateConnectionStringSettings(name, connectionString); return(connectionString); }
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 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); }
private static DbProviderMapping GetProviderMapping( string dbProviderName, DatabaseSettings databaseSettings) { if (databaseSettings != null) { DbProviderMapping dbProviderMapping = databaseSettings.ProviderMappings.Get(dbProviderName); if (dbProviderMapping != null) { return(dbProviderMapping); } } return(DatabaseSyntheticConfigSettings.GetDefaultMapping(dbProviderName) ?? DatabaseSyntheticConfigSettings.GetGenericMapping()); }
public void WillGetDefaultMappingIfProviderTypeIsNotMappedAndDefaultExistsForSql() { DatabaseSettings databaseSettings = new DatabaseSettings(); 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(SqlDatabase), mapping.DatabaseType); }
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 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); }
private IEnumerable <TypeRegistration> DoGetRegistrations() { string defaultDatabase = this.DefaultDatabase; foreach (DatabaseData databaseData in this.Databases.ToList <DatabaseData>()) { foreach (TypeRegistration typeRegistration in databaseData.GetRegistrations().ToList <TypeRegistration>()) { if (typeRegistration.ServiceType == typeof(Database) && string.Equals(typeRegistration.Name, defaultDatabase)) { typeRegistration.IsDefault = true; } yield return(typeRegistration); yield return(DatabaseSyntheticConfigSettings.GetInstrumentationProviderRegistration(typeRegistration.Name, this.configurationSource)); } } yield return(this.GetDefaultDataEventLoggerRegistration()); }
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 DbProviderMapping GetProviderMapping(string dbProviderName) { DatabaseSettings section = (DatabaseSettings)this.configurationSource.GetSection("dataConfiguration"); return(DatabaseSyntheticConfigSettings.GetProviderMapping(dbProviderName, section)); }
private DatabaseData GetDatabaseData( ConnectionStringSettings connectionString, DatabaseSettings databaseSettings) { return(DatabaseSyntheticConfigSettings.CreateDatabaseData(DatabaseSyntheticConfigSettings.GetAttribute(DatabaseSyntheticConfigSettings.GetProviderMapping(connectionString.ProviderName, databaseSettings).DatabaseType).ConfigurationType, connectionString, this.configurationSource)); }
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); }
public void Setup() { configSource = new DictionaryConfigurationSource(); configSettings = new DatabaseSyntheticConfigSettings(configSource); }
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); }
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); }
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 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(); }
protected override void Arrange() { configurationSource = new DictionaryConfigurationSource(); configurationSource.Add("connectionStrings", new 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 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 { DefaultDatabase = "sql connection" }); settings = new DatabaseSyntheticConfigSettings(); }
public IEnumerable <TypeRegistration> GetRegistrations( IConfigurationSource configurationSource) { if (configurationSource == null) { throw new ArgumentNullException(nameof(configurationSource)); } this.configurationSource = configurationSource; return((IEnumerable <TypeRegistration>) this.DoGetRegistrations().Select <TypeRegistration, TypeRegistration>((Func <TypeRegistration, TypeRegistration>)(r => DatabaseSyntheticConfigSettings.MarkAsPublicName <Database>(r))).ToList <TypeRegistration>()); }
public void Setup() { configSource = new DictionaryConfigurationSource(); configSource.Add("connectionStrings", new ConnectionStringsSection()); configSettings = new DatabaseSyntheticConfigSettings(configSource); }
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); }
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 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(); var connectionStrings = new ConnectionStringsSection(); connectionStrings.ConnectionStrings.Add(new ConnectionStringSettings { Name = "someSetting", ConnectionString = "someConnectionString", ProviderName = "non registered" }); configSource.Add("connectionStrings", connectionStrings); configSettings = new DatabaseSyntheticConfigSettings(configSource); }