Blog entity script

We will create a Blog table, then alter it to add a primary key constraint, and finally, insert some dummy data into the table. The complete script is available in the GitHub repository at https://github.com/PacktPublishing/Mastering-Entity-Framework-Core/blob/master/Chapter%202/Final/MasteringEFCore.DatabaseFirst.Final/dbo.Blog.sql.

The script required for creating the Blog table and inserting the data is displayed as follows:

    // Code removed for brevity
    CREATE TABLE [dbo].[Blog] (
       [Id]  INT            IDENTITY (1, 1) NOT NULL,
       [Url] NVARCHAR (MAX) NULL
    );
    GO
    // Code removed for brevity
    INSERT INTO [Blog] (Url) VALUES
    ('http://blogs.packtpub.com/dotnet'),
    ('http://blogs.packtpub.com/dotnetcore'),
    ('http://blogs.packtpub.com/signalr')
    GO

We have looked at the Blog table SQL script, now let's look at the Post table script that will introduce a non-clustered index and foreign key.