public SqlServerDataComponentFactory(SqlServerTransientRetryPolicy retryPolicy, IConnectionStringFactory connectionStringFactory) : base()
{
_connectionFactory =
connectionStringFactory == null ?
new SqlServerConnectionFactoryWithRetry(retryPolicy) :
new SqlServerConnectionFactoryWithRetry(retryPolicy, connectionStringFactory);
_transactionFactory = new SqlServerTransactionFactoryWithRetry(retryPolicy);
_dataAdapterFactory = new SqlServerDataAdapterFactory();
_parameterFactory = new SqlServerParameterFactory();
}
public SqlServerConnectionFactoryWithRetry(SqlServerTransientRetryPolicy retryPolicy, IConnectionStringFactory connectionStringFactory)
{
if (retryPolicy == null)
{
throw new ArgumentNullException(nameof(retryPolicy));
}
_proxy = RetryProxy.Create <IConnectionFactory>(
connectionStringFactory == null ? new SqlServerConnectionFactory() : new SqlServerConnectionFactory(connectionStringFactory),
retryPolicy);
}
public SqlServerTransactionFactoryWithRetry(SqlServerTransientRetryPolicy retryPolicy)
{
if (retryPolicy == null)
{
throw new ArgumentNullException(nameof(retryPolicy));
}
_proxy = RetryProxy.Create <ITransactionFactory>(
new TransactionFactory(),
retryPolicy);
}
public SqlServerDataComponentFactory(SqlServerTransientRetryPolicy retryPolicy, string connectionString) : base()
{
_connectionFactory =
string.IsNullOrEmpty(connectionString) ?
new SqlServerConnectionFactoryWithRetry(retryPolicy) :
new SqlServerConnectionFactoryWithRetry(retryPolicy, connectionString);
_transactionFactory = new SqlServerTransactionFactoryWithRetry(retryPolicy);
_dataAdapterFactory = new SqlServerDataAdapterFactory();
_parameterFactory = new SqlServerParameterFactory();
}
public void BeginTransaction_WithIsolationLevel_WithRetry()
{
var retryPolicy = new SqlServerTransientRetryPolicy(10, TimeSpan.FromSeconds(60));
ITransactionFactory transactionFactory = new SqlServerTransactionFactoryWithRetry(retryPolicy);
IConnectionFactory connectionFactory = new SqlServerConnectionFactoryWithRetry(retryPolicy);
using (var connection = connectionFactory.Open(AppState.ConnectionString))
using (var transaction = transactionFactory.BeginTransaction(connection, IsolationLevel.Snapshot))
{
Assert.IsNotNull(transaction);
Assert.AreEqual(connection, transaction.Connection);
Assert.AreEqual(IsolationLevel.Snapshot, transaction.IsolationLevel);
transaction.Rollback();
}
}
public SqlServerExpressionReaderWithRetry(DbConnection dbConnection, SqlServerTransientRetryPolicy retryPolicy)
{
var instance = new ExpressionReader(dbConnection, new SqlServerParameterFactory(), new SqlServerDataAdapterFactory());
_proxy = RetryProxy.Create <IExpressionReader>(instance, retryPolicy);
}
public SqlServerConnectionFactoryWithRetry(SqlServerTransientRetryPolicy retryPolicy) : this(retryPolicy, string.Empty)
{
}
public SqlServerCommandProcedureWithRetry(IDataComponentFactory factory, SqlServerTransientRetryPolicy retryPolicy)
{
var instance = new CommandProcedure(factory);
_proxy = RetryProxy.Create <ICommandProcedure>(instance, retryPolicy);
}
public SqlServerCommandProcedureWithRetry(DbConnection dbConnection, SqlServerTransientRetryPolicy retryPolicy)
{
var instance = new CommandProcedure(dbConnection, new SqlServerParameterFactory());
_proxy = RetryProxy.Create <ICommandProcedure>(instance, retryPolicy);
}
public SqlServerDataComponentFactory(SqlServerTransientRetryPolicy retryPolicy) : this(retryPolicy, string.Empty)
{
}
