public TSqlBuilder SetTransactionIsolationLevel(TransactionIsolationLevel transactionIsolationLevel)
{
var clause = new TransactionIsolationLevelClause(transactionIsolationLevel);
_clauses.Add(clause);
return(this);
}
protected override String GetSQLForSettingTransactionIsolationLevel(TransactionIsolationLevel level)
{
this.ThrowIfInTransaction("default transaction isolation level");
String levelString;
switch (level)
{
case TransactionIsolationLevel.ReadUncommitted:
levelString = READ_UNCOMMITTED;
break;
case TransactionIsolationLevel.ReadCommitted:
levelString = READ_COMMITTED;
break;
case TransactionIsolationLevel.RepeatableRead:
levelString = REPEATABLE_READ;
break;
case TransactionIsolationLevel.Serializable:
levelString = SERIALIZABLE;
break;
default:
throw new ArgumentException("Unsupported isolation level: " + level + ".");
}
return(levelString);
}
/// <summary>
/// Marks a method to run within the specified
/// type of transactional context.
/// </summary>
/// <param name="transactionType">
/// Specifies the transactional context within which the
/// method should run.</param>
/// <param name="transactionIsolationLevel">
/// Specifies override for transaction isolation level.
/// Default can be specified in .config file via CslaTransactionIsolationLevel setting
/// If none specified, Serializable level is used
/// </param>
/// <param name="timeoutInSeconds">
/// Timeout for transaction, in seconds
/// </param>
public TransactionalAttribute(
TransactionalTypes transactionType,
TransactionIsolationLevel transactionIsolationLevel,
int timeoutInSeconds)
{
TransactionType = transactionType;
TransactionIsolationLevel = transactionIsolationLevel;
TimeoutInSeconds = timeoutInSeconds;
}
/// <summary>Creates a new UnitOfWork instance with enabled transaction, specified isolation level and transactions support.</summary>
/// <param name="isolationLevel">The isolation level.</param>
/// <returns>The UnitOfWork instance.</returns>
public IUnitOfWork Create(TransactionIsolationLevel isolationLevel)
{
var transactionOptions = new TransactionOptions()
{
IsolationLevel = (IsolationLevel)isolationLevel
};
return(new EFUnitOfWork <TDbContext>(this._dependencyResolver, transactionOptions));
}
/// <summary>
/// Marks a method to run within the specified
/// type of transactional context.
/// </summary>
/// <param name="transactionType">
/// Specifies the transactional context within which the
/// method should run.</param>
/// <param name="transactionIsolationLevel">
/// Specifies override for transaction isolation level.
/// Default can be specified in .config file via CslaTransactionIsolationLevel setting
/// If none specified, Serializable level is used
/// </param>
/// <param name="timeoutInSeconds">
/// Timeout for transaction, in seconds
/// </param>
public TransactionalAttribute(
TransactionalTypes transactionType,
TransactionIsolationLevel transactionIsolationLevel,
int timeoutInSeconds)
{
TransactionType = transactionType;
TransactionIsolationLevel = transactionIsolationLevel;
TimeoutInSeconds = timeoutInSeconds;
}
/// <summary>
/// Marks a method to run within the specified
/// type of transactional context.
/// </summary>
/// <param name="transactionType">
/// Specifies the transactional context within which the
/// method should run.</param>
/// <param name="transactionIsolationLevel">
/// Specifies override for transaction isolation level.
/// Default can be specified in .config file via CslaTransactionIsolationLevel setting
/// If none specified, Serializable level is used
/// </param>
public TransactionalAttribute(
TransactionalTypes transactionType,
TransactionIsolationLevel transactionIsolationLevel)
{
TransactionType = transactionType;
TransactionIsolationLevel = transactionIsolationLevel;
if (transactionType == TransactionalTypes.TransactionScope ||
transactionType == TransactionalTypes.EnterpriseServices)
{
TimeoutInSeconds = ApplicationContext.DefaultTransactionTimeoutInSeconds;
}
}
public override IUnitOfWork BeginTransaction(TransactionIsolationLevel isolationLevel)
{
if (this._transactionScope == null)
{
throw new InvalidOperationException("Transaction not initialized.");
}
var transactionOptions = new TransactionOptions()
{
IsolationLevel = (IsolationLevel)isolationLevel
};
return(new EFUnitOfWork <TDbContext>(this._dependencyResolver, transactionOptions, useCurrentTransaction: true));
}
private IsolationLevel GetIsolaionLevel(TransactionIsolationLevel transactionIsolationLevel)
{
switch (transactionIsolationLevel)
{
case TransactionIsolationLevel.Serializable:
return IsolationLevel.Serializable;
case TransactionIsolationLevel.RepeatableRead:
return IsolationLevel.RepeatableRead;
case TransactionIsolationLevel.ReadCommitted:
return IsolationLevel.ReadCommitted;
case TransactionIsolationLevel.ReadUncommitted:
return IsolationLevel.ReadUncommitted;
default:
return IsolationLevel.Serializable;
}
}
/// <summary>
/// Marks a method to run within the specified
/// type of transactional context.
/// </summary>
/// <param name="transactionType">
/// Specifies the transactional context within which the
/// method should run.</param>
/// <param name="transactionIsolationLevel">
/// Specifies override for transaction isolation level.
/// Default can be specified in .config file via CslaTransactionIsolationLevel setting
/// If none specified, Serializable level is used
/// </param>
public TransactionalAttribute(
TransactionalTypes transactionType,
TransactionIsolationLevel transactionIsolationLevel)
{
TransactionType = transactionType;
TransactionIsolationLevel = transactionIsolationLevel;
#if NETSTANDARD2_0 || NET5_0 || NET6_0
if (transactionType == TransactionalTypes.TransactionScope)
#else
if (transactionType == TransactionalTypes.TransactionScope ||
transactionType == TransactionalTypes.EnterpriseServices)
#endif
{
TimeoutInSeconds = ApplicationContext.DefaultTransactionTimeoutInSeconds;
}
}
private IsolationLevel GetIsolaionLevel(TransactionIsolationLevel transactionIsolationLevel)
{
switch (transactionIsolationLevel)
{
case TransactionIsolationLevel.Serializable:
return(IsolationLevel.Serializable);
case TransactionIsolationLevel.RepeatableRead:
return(IsolationLevel.RepeatableRead);
case TransactionIsolationLevel.ReadCommitted:
return(IsolationLevel.ReadCommitted);
case TransactionIsolationLevel.ReadUncommitted:
return(IsolationLevel.ReadUncommitted);
default:
return(IsolationLevel.Serializable);
}
}
public TransactionIsolationLevelClause(TransactionIsolationLevel transactionIsolationLevel)
{
_transactionIsolationLevel = transactionIsolationLevel;
}
public IUnitOfWork Create(TransactionIsolationLevel isolationLevel, TimeSpan timeout)
{
Contract.Ensures(Contract.Result<IUnitOfWork>() != null);
return default(IUnitOfWork);
}
public ITransaction CreateProcessingTransaction(TransactionIsolationLevel jobTransactionIsolationLevel, TimeSpan jobTimeout)
{
var isolationLevel = (IsolationLevel) jobTransactionIsolationLevel;
return new FatQueueTransaction(isolationLevel, jobTimeout, _connectionFactory, TransactionScopeOption.RequiresNew);
}
public abstract IUnitOfWork BeginTransaction(TransactionIsolationLevel isolationLevel, TimeSpan timeout);
/// <summary>
/// Marks a method to run within the specified
/// type of transactional context.
/// </summary>
/// <param name="transactionType">
/// Specifies the transactional context within which the
/// method should run.</param>
/// <param name="transactionIsolationLevel">
/// Specifies override for transaction isolation level.
/// Default can be specified in .config file via CslaTransactionIsolationLevel setting
/// If none specified, Serializable level is used
/// </param>
public TransactionalAttribute(
TransactionalTypes transactionType,
TransactionIsolationLevel transactionIsolationLevel)
{
TransactionType = transactionType;
TransactionIsolationLevel = transactionIsolationLevel;
if (transactionType == TransactionalTypes.TransactionScope ||
transactionType == TransactionalTypes.EnterpriseServices)
{
TimeoutInSeconds = ApplicationContext.DefaultTransactionTimeoutInSeconds;
}
}
public IUnitOfWork Create(TransactionIsolationLevel isolationLevel, TimeSpan timeout)
{
Contract.Ensures(Contract.Result <IUnitOfWork>() != null);
return(default(IUnitOfWork));
}
public IUnitOfWork BeginTransaction(TransactionIsolationLevel isolationLevel)
{
Contract.Ensures(Contract.Result <IUnitOfWork>() != null);
return(default(IUnitOfWork));
}
public async Task SetDefaultTransactionIsolationLevelAsync(TransactionIsolationLevel level)
{
await this.ExecuteNonQueryAsync(this.GetSQLForSettingTransactionIsolationLevel( level ), () => this.TransactionIsolationLevelProperty = level);
}
protected abstract String GetSQLForSettingTransactionIsolationLevel(TransactionIsolationLevel level);
public TransactionAttribute(TransactionOption val)
{
this.val = val;
this.isolation = TransactionIsolationLevel.Serializable;
this.timeout = -1;
}
/// <summary>
/// Sets the default transaction isolation level.
/// </summary>
/// <param name="level">The default transaction isolation level</param>
public ICslaConfiguration DefaultTransactionIsolationLevel(TransactionIsolationLevel level)
{
ConfigurationManager.AppSettings["CslaDefaultTransactionIsolationLevel"] = level.ToString();
return(RootConfiguration);
}
public TransactionAttribute(TransactionOption val)
{
this.isolation = TransactionIsolationLevel.Serializable;
this.timeout = -1;
this.val = val;
}
/// <summary>
/// Sets the default transaction isolation level.
/// </summary>
/// <param name="level">The default transaction isolation level</param>
public DataOptions DefaultTransactionIsolationLevel(TransactionIsolationLevel level)
{
ApplicationContext.DefaultTransactionIsolationLevel = level;
return(this);
}
public TransactionAttribute(TransactionOption val)
{
this._value = val;
this._isolation = TransactionIsolationLevel.Serializable;
this._timeout = -1;
}
/// <summary>
/// Sets the default transaction isolation level.
/// </summary>
/// <param name="level">The default transaction isolation level</param>
public ICslaConfiguration DefaultTransactionIsolationLevel(TransactionIsolationLevel level)
{
ApplicationContext.DefaultTransactionIsolationLevel = level;
return(RootConfiguration);
}
public abstract IUnitOfWork BeginTransaction(TransactionIsolationLevel isolationLevel);
