private EntityConnectionStringBuilder UpdateConnectionParameters( DatabaseAccessConfiguration accessConfigurations) { var connection = new EntityConnectionStringBuilder( ConfigurationManager.ConnectionStrings[nameof(DragonflyEntities)].ConnectionString); var builder = new SqlConnectionStringBuilder(connection.ProviderConnectionString) { ApplicationName = "Dragonfly server" }; if (!string.IsNullOrWhiteSpace(accessConfigurations.ServerName)) { builder.DataSource = accessConfigurations.ServerName; } if (!string.IsNullOrWhiteSpace(accessConfigurations.DbName)) { builder.InitialCatalog = accessConfigurations.DbName; } if (!string.IsNullOrWhiteSpace(accessConfigurations.UserName)) { builder.UserID = accessConfigurations.UserName; } if (!string.IsNullOrWhiteSpace(accessConfigurations.Password)) { builder.Password = accessConfigurations.Password; } connection.ProviderConnectionString = builder.ToString(); return(connection); }
public void ReadDbConfigurationTest() { Assert.IsNotNull(_LibManager, "Library settings manager can't be null, but it is."); DragonflyConfig currentConfig = null; currentConfig = ReadCurrentConfiguration(); Assert.IsNotNull( currentConfig, "Return empty configuration after reading."); Assert.IsNotNull( currentConfig.DbConfiguration, "Return empty DB configuration after reading."); try { DatabaseAccessConfiguration accessConfig = _Raader.GetDbAccessSettings(); Assert.IsNotNull(accessConfig, "Reader was returned an empty db config."); Assert.AreEqual(currentConfig.DbConfiguration.DbAddress, accessConfig.ServerName); Assert.AreEqual(currentConfig.DbConfiguration.DbName, accessConfig.DbName); Assert.AreEqual(currentConfig.DbConfiguration.DefaultUserName, accessConfig.UserName); Assert.AreEqual(currentConfig.DbConfiguration.DefaultUserPassword, accessConfig.Password); } finally { } }
public DBContextGenerator(DatabaseAccessConfiguration accessConfigurations) { if (accessConfigurations == null) { throw new ArgumentNullException(nameof(accessConfigurations)); } _DbConfig = Clone(accessConfigurations); }
/// <summary> /// Base constructor of the MS MQL factory. /// </summary> public MsSqlFactory(DatabaseAccessConfiguration dbConfig) { if (dbConfig == null) { throw new ArgumentNullException(nameof(dbConfig)); } _ContextGenerator = new DBContextGenerator(dbConfig); _UserDBDataManager = new UserDBDataManager(); }
static Common() { Connectionconfig = new SettingsLibReader().GetDbAccessSettings(_DefaultPath); }