How to use performant Guid as primary keys in databases. UUID Version 7 to the rescue!

• UUIDNext

  6 152 6.7 C#

  A fast and modern .NET library to generate UUID/GUID that are either sequential and database friendly (versions 7), name based (versions 5) or random (version 4).

Not my library: UUIDNext

• NHibernate

  4 2,102 8.4 C#

  NHibernate Object Relational Mapper

  

• InfluxDB

  www.influxdata.com sponsored

  Power Real-Time Data Analytics at Scale. Get real-time insights from all types of time series data with InfluxDB. Ingest, query, and analyze billions of data points in real-time with unbounded cardinality.

  

• Ulid

  2 821 5.9 C#

  Fast .NET C# Implementation of ULID for .NET and Unity. (by Cysharp)

  

Side note, an interesting thing to add to your benchmarks would be ULID https://github.com/Cysharp/Ulid

• RT.Comb

  2 189 3.3 C#

  Creating sequential GUIDs in C# for MSSQL or PostgreSql

There's a reason why, for example, this library - https://github.com/richardtallent/RT.Comb/ - uses different algorithms for PostgreSQL and for MSSQL.

• Entity Framework

  87 13,325 9.9 C#

  EF Core is a modern object-database mapper for .NET. It supports LINQ queries, change tracking, updates, and schema migrations.

  

EntityFramework also includes an algorithm optimized for MSSQL: SequentialGuidValueGenerator @ github.com/dotnet/efcore.

• WorkOS

  workos.com sponsored

  The modern identity platform for B2B SaaS. The APIs are flexible and easy-to-use, supporting authentication, user identity, and complex enterprise features like SSO and SCIM provisioning.

  

Suggest a related project