/// <summary>
/// Creates a connection to database
/// </summary>
private static SqlConnection CreateConnectionToPublisherDB(Parameters parameters)
{
    SqlConnectionStringBuilder connectionString = new SqlConnectionStringBuilder();
    connectionString.DataSource = parameters.DatabaseServerName;
    connectionString.InitialCatalog = parameters.DatabaseName;
    SqlCredential credential = new SqlCredential(
         parameters.DatabaseUserName,
         parameters.DatabasePassword);

    SqlConnection connection = new SqlConnection(connectionString.ConnectionString, credential);

    connection.Open();
    parameters.DatabasePassword.Dispose();
    return connection;
}