private void _SQLServerConfiguration(SqlInstances sqlInstances) { SQLServerConfiguration sSC = new SQLServerConfiguration(credentials); sSC.SetComputerName(sqlInstances.Server); sSC.SetInstance(sqlInstances.ServerInstance); sSC.Query(); _PrintOutput(sSC.GetResults()); }
private bool TryConnectoToDatabase(SQLServerConfiguration sqlServerConfiguration) { if (sqlServerConfiguration.DatabaseConnectionType == DatabaseConnectionType.Advanced) { if (String.IsNullOrWhiteSpace(sqlServerConfiguration.ConnectionString)) { return(false); } } else if (sqlServerConfiguration.DatabaseConnectionType == DatabaseConnectionType.SQLServerAuthentication) { if (String.IsNullOrWhiteSpace(sqlServerConfiguration.DatabaseAddress)) { return(false); } if (String.IsNullOrWhiteSpace(sqlServerConfiguration.DatabaseName)) { return(false); } if (String.IsNullOrWhiteSpace(sqlServerConfiguration.DatabaseUsername)) { return(false); } if (String.IsNullOrWhiteSpace(sqlServerConfiguration.DatabasePassword)) { return(false); } sqlServerConfiguration.ConnectionString = $"Server={sqlServerConfiguration.DatabaseAddress};" + $"Database={sqlServerConfiguration.DatabaseName};" + $"User Id={sqlServerConfiguration.DatabaseUsername};" + $"Password={sqlServerConfiguration.DatabasePassword};"; } else if (sqlServerConfiguration.DatabaseConnectionType == DatabaseConnectionType.WindowsAuthentication) { if (String.IsNullOrWhiteSpace(sqlServerConfiguration.DatabaseAddress)) { return(false); } if (String.IsNullOrWhiteSpace(sqlServerConfiguration.DatabaseName)) { return(false); } sqlServerConfiguration.ConnectionString = $"Server={sqlServerConfiguration.DatabaseAddress};" + $"Database={sqlServerConfiguration.DatabaseName};" + $"Trusted_Connection=True;"; } if (!DataAccess.Helper.TestConnection(sqlServerConfiguration.ConnectionString)) { return(false); } _customSettings.ConnectionString = sqlServerConfiguration.ConnectionString; DataAccess.Helper.ChangeConnectionString(sqlServerConfiguration.ConnectionString); return(true); }
public async Task CreateSqlServerConfiguration(CreateSQLServerConfigModel configModel) { var config = new SQLServerConfiguration { Application = configModel.Application, AsynchronousProcessing = configModel.AsynchronousProcessing, ConfigId = configModel.ConfigId, DataSource = configModel.DataSource, IsSecurityIntegrated = configModel.IsSecurityIntegrated, ProtectedPassword = configModel.ProtectedPassword, Provider = configModel.Provider, UserId = configModel.UserId }; await _ctx.SqlserverConfigurations.AddAsync(config); await _ctx.SaveChangesAsync(CancellationToken.None); }
private async Task <bool> ClearDatabase(SQLServerConfiguration sqlServerConfiguration) { return(await DataAccess.Helper.ClearDatabaseDataAsync(sqlServerConfiguration.ConnectionString)); }
private async Task <bool> GenerateDatabase(SQLServerConfiguration sqlServerConfiguration) { return(await DataAccess.Helper.CreateDatabaseModelAsync(sqlServerConfiguration.ConnectionString)); }