C#? ??? ????? ??? SQL Server ?????? ??

??? ???? ?????? ???? ?????? ?????? ?? ??. ??? SQL Server? ?? ??? ??????? ????? ????? ??????? ????? ?? ?? ?? ?? ??? ??? ?? ??? ??? ?????.

????? ??? ?? ?????? ??

?? ??? ??????? ?? ??? ????? ???? ?? ??? ??? ? ????. ??:

1. ???? ??? ??: ??? ??? ??? ?? ??? ??? ??? ? ??? ??? ?????.
2. ThreadPool? ???? ?? ?? : System.Threading.ThreadPool? ???? ?? ??? ?? ??? ??? ? ?? ??.
3. ?? ??: ??? ???? ?? ??? ?? ??? ???? ????.
4. ??? ??: ?? ? ??? ????? ???? ??????? ?? ?? ???? ???? ? ?? ??? ?????.

?? ?? ??

?? ??? ?? ??? ?????? ???????? ?? ?????. ? ??? ????? ????? ?? ??? ??????.

• ??? ? ???: ??? ?? ???? ?????? ???? ?? ??? ??? ?????.
• ??? ???: ?? ???? ???? ??? ??? ?? ??? ???? ??? ?????. ??.
• ?? ?? ??: ???? ?? ??? ??? ?? ??? ??? ?? ?? ?? ???? ?????.
• ?? ?? ??? ??: ??? ??? ?? ?? ????? ???? ??? ?? ?????? ??? ?? ?????.

??? ?? ??

??? ???? ??? ?? ??? ????? ? ?? ?? ??? ?? ?? ??? ?? ??? ?????.

// Main application thread
using (var dc = new TestDataContext())
{
    var problematicIds = new List<ErrorType>();

    // Utilize Parallel.ForEach for task parallel execution
    ParallelOptions parallelOptions = new ParallelOptions() {MaxDegreeOfParallelism = 8};
    Parallel.ForEach(ids, parallelOptions, id =>
    {
        try
        {
            DeadlockRetryHelper.Execute(() => CalculateDetails(id));
        }
        catch (Exception e)
        {
            // Handle exception and record failed ID
            problematicIds.Add(new ErrorType(id, e));
        }
    });
}

// Subroutine with deadlock retry mechanism
public static class DeadlockRetryHelper
{
    private const int MaxRetries = 4;
    private const int SqlDeadlock = 1205;

    public static void Execute(Action action, int maxRetries = MaxRetries)
    {
        int retries = 0;

        while (retries < maxRetries)
        {
            try
            {
                action();
                return;
            }
            catch (Exception e)
            {
                if (IsSqlDeadlock(e))
                {
                    retries++;
                    Thread.Sleep(100 * retries);
                }
                else
                {
                    throw;
                }
            }
        }

        action();
    }

    private static bool IsSqlDeadlock(Exception exception)
    {
        ... // Implementation omitted for brevity
    }
}

?? ?? ??

???? ????? ??? ?? ???? ?? ? ?? ?? ??? ???? ??? ?????. ? ??? ?? ???? ?? ?? ????? ??? ????? ???? ?? ??? ????? ??? ? ????.

?????, ????? ?????? ?? ??? ??? ?? ??? ??? ? ??? ???? ?? ??? ???? ???? ???. ??? ??? ???? ??? ???? ?????? ??? ???? ?????? ??? ???? ? ????.

? ??? ?? ??? ???? C#?? ?????? ???? ??? SQL Server ?????? ??? ????? ??? ?? ????? ?? ?????. ??? ??? PHP ??? ????? ?? ?? ??? ?????!