Pros and cons of Database identity
Nice to work with in URLs
Limiting, as they require a trip to the database, which precludes some patterns
Can be tricky to return IDs when inserting in some cases (EF Core etc solves this)
Can cause contention in high throughput scenarios. May make scaling out impossible

• Functional Defects
• Problems with the logic
• Missing Validation (e.g., edge cases)
• Usage of API
• Design Patterns
• Architectural Issues
• Testability
• Readability
• Security
• Naming conventions
• Team Coding Style
• Documentation
• Use of best practices
• Language-specific issues
• Use of deprecated methods
• Performance (e.g., complexity of the solution)
• Alternative solutions… 

The future of C#
Over the last year we shipped no less than three "point releases" of C# (7.1, 7.2 and 7.3), full of small but useful language features. Mads and Dustin will race you through a tour of these, before turning to some of the big things we have in store for the future: Nullable reference types, recursive patterns, asynchronous streams and more. 

This repo contains the samples that demonstrate the API usage patterns and popular features for the Windows Presenation Foundation in the .NET Framework for Desktop. These samples were initially hosted on MSDN, and we are gradually moving all the interesting WPF samples over to GitHub.All the samples have been retargeted to .NET 4.5.2.

public int Length { get; }
public int Count { get; }

public object this[int index] => throw null;
public object this[System.Index index] => throw null;

public object this[System.Range index] => throw null;
public object Slice(int start, int length) => throw null;

public class MyListPatternsCompatibleCollection
{
    private readonly List<int> _items = new();

    public int Length => _items.Count;

    public int this[Index index] => _items[index];

    public ReadOnlySpan<int> this[Range range]
        => CollectionsMarshal.AsSpan(_items)[range];

    public void Add(int item) => _items.Add(item);
}

 var collection = new MyListPatternsCompatibleCollection();
collection.Add(1);
collection.Add(2);
collection.Add(3);

_ = collection is [var head, .. var tail];

• Conditional INSERT/UPDATE Race Condition
• “UPSERT” Race Condition With MERGE
• آسیب‌پذیری Race Condition در آکادمی لیان
• Race Condition in Web Application
• Processing Data Queues in SQL Server with READPAST and UPDLOCK
• PostgreSQL anti-patterns: read-modify-write cycles
• PHP Race Condition Vulnerability Example
• Application Locks (or Mutexes) in SQL Server 2005
• Handle Race Conditions / Concurrency in Code First Entity Framework Applications

 public ApplicationDbContext(DbContextOptions options) : base(options)
        {
            
        }