The Weird and The Wonderful

Jon McKee wrote:

If you deal with a file or files which frequently don't exist, you can use that check instead of exceptions.

Bastard Programmer from Hell
If you can't read my code, try converting it here[^]
"If you just follow the bacon Eddy, wherever it leads you, then you won't have to think about politics." -- Some Bell.

Eddy Vluggen wrote:

Best practice means not to discourage the use of exceptions, simply because someone thinks that they slow the system. As you can see, it doesn't take much time to invoke the entire exception stack, as it can be done several thousand times in a second.

Eddy Vluggen wrote:

Too many idiots avoiding exceptions altogether and using booleans instead If it is an error, throw an exception, it is that simple.

private IDbDataParameter ExistsStuff(IDbCommand CMD, string Name) =>
    (System.Data.IDbDataParameter) CMD.Parameters[Name];

private IDbDataParameter DoesntExistStuff(IDbCommand CMD, string Name)
{
    IDbParameter result = CMD.CreateParameter() { ParameterName = Name };
    CMD.Parameters.Add(result);
    return result;
}
//--------------------------------------
if (CMD.Parameters.Contains(Name))
    result = ExistsStuff(CMD, Name);
else
    result = DoesntExistStuff(CMD, Name);
//Versus
try
{
    result = ExistsStuff(CMD, Name);
}
catch ( System.IndexOutOfRangeException err )
{
    result = DoesntExistStuff(CMD, Name);
}

if/else: (1x + 1y)
try/catch: (0x + 15y)
Balance point: x + y = 15y => x = 14y => 1:14

// Get the item with the specified key if it exists; 
// otherwise, pass the key to the lambda method to create a new item, and add it to the dictionary:
T value = items.GetOrAdd(key, GetNewValueLogic);

@@NESTLEVEL (Transact-SQL) | Microsoft Docs[^]

Each time a stored procedure calls another stored procedure or executes managed code by referencing a common language runtime (CLR) routine, type, or aggregate, the nesting level is incremented. When the maximum of 32 is exceeded, the transaction is terminated.

LoopStart:
IF (@Count - @RowCountTotal) > @BatchSize 
 Begin
  Begin Transaction
   Delete Top (@BatchSize) From Comment Where CommentTime < @StartDate
   Set @RowCountTotal = @RowCountTotal + @@RowCount
  Commit Transaction
  Goto LoopStart
    End
Else
 If (@Count - @RowCountTotal) > 0
  Begin<br />
   Begin Transaction
    Delete Top (@Count - @RowCountTotal) From Comment Where CommentTime < @StartDate
    Set @RowCountTotal = @RowCountTotal + @@RowCount<br />
   Commit Transaction
  End