static bool SetTransactionLevel(ISqlConnectionTransactionController controller, IsolationLevel isolationLevel)
{
using (var cmd = new SqlCommand($"SET TRANSACTION ISOLATION LEVEL {isolationLevel.ToSqlString()};"))
{
cmd.Transaction = controller.Transaction;
cmd.Connection = controller.Connection;
try
{
cmd.ExecuteNonQuery();
return(true);
}
catch (Exception ex)
{
controller.SqlCallContext.Monitor.Error($"Failed to set isolation level {isolationLevel}.", ex);
return(false);
}
}
}