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.
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 tests, and dotnet-text-xunit
adds tooling support for Visual Studio. Note that the UnitTests
project is a .NET Core App 1.0 (netcoreapp1.0), that Microsoft.EntityFrameworkCore.Design
is configured as a build dependency, and Microsoft.EntityFrameworkCore...