Support different connection strings for SQL transport and SQL persistence

[weralabaj]

Raised as an issue on StackOverflow.

When using different connection strings for SQL transport and persistence in transport transaction mode higher than None, SQL persistence is attempting to reuse transport connection and fails.

The issue can be fixed by introducing either UseSqlTransportConnection and default assume people are not using the same connection string, or taking the opposite approach, i.e. introducing DoNotUseSqlTransportConnection and by default assume people are using the same connection string.

[ErikMuir]

@SimonCropp - Has this been released yet? Is it part of the 3.0.0-beta0001 version?

[SimonCropp]

@ErikMuir no this is not in the 3.0.0-beta0001. the current plan is a new beta within the next 24 hours. and it will be included in that package