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());
}
