Connection
The subscription persister can be configured to use a dedicated connection builder. For example, it may be used for creating subscription tables in a separate database.
var connection = @"Data Source=.\SqlExpress;Initial Catalog=subscriptions;Integrated Security=True";
var persistence = endpointConfiguration.UsePersistence<SqlPersistence>();
var subscriptions = persistence.SubscriptionSettings();
subscriptions.ConnectionBuilder(
connectionBuilder: () =>
{
return new SqlConnection(connection);
});