准备
若没有供实验的数据,可以使用Microsoft SQL Server Management Studio通过先创建一个本地数据库,如命名为ef-demo。再使用以下SQL创建一些数据表。
USE [ef-demo]
GO
CREATE TABLE [dbo].[Identities] (
[Id] BIGINT NOT NULL,
[NickName] NVARCHAR (200) NOT NULL,
[PhoneNumber] NVARCHAR (200) NOT NULL,
CONSTRAINT [PK_dbo.Identities] PRIMARY KEY CLUSTERED ([Id] ASC)
);
GO
CREATE TABLE [dbo].[People] (
[Id] BIGINT NOT NULL,
[FirstName] NVARCHAR (200) NOT NULL,
[MiddleName] NVARCHAR (200),
[LastName] NVARCHAR (200) NOT NULL,
[Email] NVARCHAR (200),
CONSTRAINT [PK_dbo.People] PRIMARY KEY CLUSTERED ([Id] ASC)
);
GO
ALTER TABLE [dbo].[People] WITH CHECK ADD CONSTRAINT [FK_dbo.Identities] FOREIGN KEY ([Id]) REFERENCES [dbo].[Identities] ([Id])
GO
ALTER TABLE [dbo].[People] CHECK CONSTRAINT [FK_dbo.Identities]
GO