public string GetConnectionString(string dataSource, string databaseName, DBAuthMode authMode, Credential credential = null) { return(_dbConnection.GenerateConnectionString(dataSource, databaseName, authMode, credential)); }
public string GenerateConnectionString(string dataSource, string databaseName, DBAuthMode authMode, Credential credential = null) { var sqlConnectionStringBuilder = new SqlConnectionStringBuilder { DataSource = dataSource, InitialCatalog = databaseName, ConnectTimeout = 30, IntegratedSecurity = true, TrustServerCertificate = false, Encrypt = false, }; if (authMode == DBAuthMode.DBServer) { if (credential == null) { throw new InvalidOperationException("Credentials cannot be null if Authentication mode is DBServer!"); } sqlConnectionStringBuilder.UserID = credential.UserName; sqlConnectionStringBuilder.Password = credential.Password; } return(sqlConnectionStringBuilder.ToString()); }