private static SharedConnectionInfo GetConnectionInfo(WorkflowCommitWorkBatchService txSvc, Transaction transaction)
{
SharedConnectionInfo connectionInfo = null;
SharedConnectionWorkflowCommitWorkBatchService service = txSvc as SharedConnectionWorkflowCommitWorkBatchService;
if (service != null)
{
connectionInfo = service.GetConnectionInfo(transaction);
if (connectionInfo == null)
{
throw new ArgumentException(string.Format(CultureInfo.CurrentCulture, ExecutionStringManager.InvalidTransaction, new object[0]));
}
}
return(connectionInfo);
}
/*
* private void SetLocalProvider(string connectionString)
* {
* // Assume caller already validated the connection string
* MatchCollection providers = Regex.Matches(connectionString, @"(^|;)\s*provider\s*=[^;$]*(;|$)", RegexOptions.IgnoreCase);
*
* // Cannot use DbConnectionStringBuilder because it selects the last provider, not the first one, by itself.
* // A legal Sql connection string allows for multiple provider specification and
* // selects the first provider
* if (providers.Count > 0)
* {
* // Check if the first one matches "sqloledb" or "sqloledb.<digit>"
* if (Regex.IsMatch(providers[0].Value, @"provider\s*=\s*sqloledb(\.\d+)?\s*(;|$)", RegexOptions.IgnoreCase))
* {
* this.localProvider = Provider.OleDB;
* }
* else
* {
* // We don't support other providers
* throw new ArgumentException(String.Format(CultureInfo.CurrentCulture,ExecutionStringManager.UnsupportedSqlProvider, providers[0].Value));
* }
* }
* else
* {
* // SqlClient provider requires no provider keyword specified in connection string
* this.localProvider = Provider.SqlClient;
* }
* }
*/
private static SharedConnectionInfo GetConnectionInfo(WorkflowCommitWorkBatchService txSvc, Transaction transaction)
{
SharedConnectionInfo connectionInfo = null;
SharedConnectionWorkflowCommitWorkBatchService scTxSvc = txSvc as SharedConnectionWorkflowCommitWorkBatchService;
if (scTxSvc != null)
{
connectionInfo = scTxSvc.GetConnectionInfo(transaction);
// The transaction service can't find entry if the transaction has been completed.
// be sure to propate the error so durable services can cast to appropriate exception
if (connectionInfo == null)
{
throw new ArgumentException(
String.Format(CultureInfo.CurrentCulture, ExecutionStringManager.InvalidTransaction));
}
}
return(connectionInfo);
}