private void ExecuteRetried(SqlCommand cmd, LoadFromReader loader, object loadFromReaderParam) { SqlDataReader reader = null; short num = 0; Label_0004 :; try { using (SqlConnection connection = new SqlConnection(this._connectionString)) { cmd.Connection = connection; cmd.Connection.Open(); reader = cmd.ExecuteReader(CommandBehavior.CloseConnection); loader(reader, loadFromReaderParam); } } catch (SqlException exception) { if ((_deadlock != exception.Number) || ((num = (short)(num + 1)) >= _retries)) { throw; } goto Label_0004; } finally { if ((reader != null) && !reader.IsClosed) { reader.Close(); } } }
private void ExecuteRetried(SqlCommand cmd, LoadFromReader loader, object loadFromReaderParam) { SqlDataReader reader = null; short count = 0; while (true) { try { using (SqlConnection conn = new SqlConnection(_connectionString)) { cmd.Connection = conn; cmd.Connection.Open(); reader = cmd.ExecuteReader(CommandBehavior.CloseConnection); loader(reader, loadFromReaderParam); break; } } catch (SqlException se) { // // Retry if we deadlocked. // All other exceptions bubble if ((_deadlock == se.Number) && (++count < _retries)) { continue; } throw; } finally { if ((null != reader) && (!reader.IsClosed)) { reader.Close(); } } } }
private void ExecuteRetried(SqlCommand cmd, LoadFromReader loader, object loadFromReaderParam) { SqlDataReader reader = null; short count = 0; while (true) { try { using (SqlConnection conn = new SqlConnection(_connectionString)) { cmd.Connection = conn; cmd.Connection.Open(); reader = cmd.ExecuteReader(CommandBehavior.CloseConnection); loader(reader, loadFromReaderParam); break; } } catch (SqlException se) { // // Retry if we deadlocked. // All other exceptions bubble if ((_deadlock == se.Number) && (++count < _retries)) continue; throw; } finally { if ((null != reader) && (!reader.IsClosed)) reader.Close(); } } }
private void ExecuteRetried(SqlCommand cmd, LoadFromReader loader) { ExecuteRetried(cmd, loader, null); }
private void ExecuteRetried(SqlCommand cmd, LoadFromReader loader, object loadFromReaderParam) { SqlDataReader reader = null; short num = 0; Label_0004:; try { using (SqlConnection connection = new SqlConnection(this._connectionString)) { cmd.Connection = connection; cmd.Connection.Open(); reader = cmd.ExecuteReader(CommandBehavior.CloseConnection); loader(reader, loadFromReaderParam); } } catch (SqlException exception) { if ((_deadlock != exception.Number) || ((num = (short) (num + 1)) >= _retries)) { throw; } goto Label_0004; } finally { if ((reader != null) && !reader.IsClosed) { reader.Close(); } } }