Entity Framework Core Cookbook - Second Edition

Using GUIDs as keys

We know that Entity Framework can generates keys using either the IDENTITY or SEQUENCE (SQL Server 2012) features. It is also possible, however, to leverage GUIDs to generate keys on either the client or the server side.

Client-side generated GUID keys should work equally well in any database that supports GUIDs: SQL Server has the UNIQUEIDENTIFIER type, Oracle has RAW(16), MySQL and PostgreSQL have UUID, and so on.

Getting ready

We will be using the NuGet Package Manager to install the Entity Framework Core 1 package, Microsoft.EntityFrameworkCore. We will also be using a SQL Server database to store the data, so we will also need Microsoft.EntityFrameworkCore.SqlServer.

Finally, xunit is the package we will be using for the unit ...