ASP.NET – My Projects & Live

Create a Login App with ASP.NET on Ubuntu 22.04

Here’s a step-by-step guide to create a simple login form using ASP.NET Core (C#) and MS SQL Server with VS Code and Linux:

Install .NET SDK If you haven’t already, install the .NET SDK for your Linux distribution. You can find instructions on the official Microsoft website.check your dotnet version
[codesyntax lang=”bash”]

dotnet --version 8.0.405

1
2

dotnet --version
8.0.405

[/codesyntax]

Create a new ASP.NET Core project Open a terminal and run:

dotnet new mvc -n LoginApp

1	dotnet new mvc -n LoginApp

[codesyntax lang=”bash”]

satria@teddy:~/Documents/projects/aspnet$ dotnet new mvc -n LoginApp
The template "ASP.NET Core Web App (Model-View-Controller)" was created successfully.
This template contains technologies from parties other than Microsoft, see https://aka.ms/aspnetcore/8.0-third-party-notices for details.

Processing post-creation actions...
Restoring /home/satria/Documents/projects/aspnet/LoginApp/LoginApp.csproj:
  Determining projects to restore...
  Restored /home/satria/Documents/projects/aspnet/LoginApp/LoginApp.csproj (in 83 ms).
Restore succeeded.

satria@teddy:~/Documents/projects/aspnet$ dotnet new mvc -n LoginApp

The template "ASP.NET Core Web App (Model-View-Controller)" was created successfully.

This template contains technologies from parties other than Microsoft, see https://aka.ms/aspnetcore/8.0-third-party-notices for details.

Processing post-creation actions...

Restoring /home/satria/Documents/projects/aspnet/LoginApp/LoginApp.csproj:

Determining projects to restore...

Restored /home/satria/Documents/projects/aspnet/LoginApp/LoginApp.csproj (in 83 ms).

Restore succeeded.

[/codesyntax]

Go to the project directory ‘LoginApp’ with ‘cd LoginApp’

Install required NuGet packages Run the following commands:
[codesyntax lang=”bash”]

dotnet add package Microsoft.EntityFrameworkCore.SqlServer
dotnet add package Microsoft.EntityFrameworkCore.Design
dotnet add package Microsoft.AspNetCore.Identity.EntityFrameworkCore

dotnet add package Microsoft.EntityFrameworkCore.SqlServer

dotnet add package Microsoft.EntityFrameworkCore.Design

dotnet add package Microsoft.AspNetCore.Identity.EntityFrameworkCore

[/codesyntax]

Make sure the version is match in LoginApp.csproj
[codesyntax lang=”csharp”]

&lt;ItemGroup&gt;
    &lt;PackageReference Include="Microsoft.AspNetCore.Identity.EntityFrameworkCore" Version="8.0.0" /&gt;
    &lt;PackageReference Include="Microsoft.EntityFrameworkCore.SqlServer" Version="8.0.0" /&gt;
    &lt;PackageReference Include="Microsoft.EntityFrameworkCore.Design" Version="8.0.0"&gt;
      &lt;IncludeAssets&gt;runtime; build; native; contentfiles; analyzers; buildtransitive&lt;/IncludeAssets&gt;
      &lt;PrivateAssets&gt;all&lt;/PrivateAssets&gt;
    &lt;/PackageReference&gt;
  &lt;/ItemGroup&gt;

<IncludeAssets>runtime; build; native; contentfiles; analyzers; buildtransitive</IncludeAssets>

</PackageReference>

</ItemGroup>

[/codesyntax]

Set up the database connection Open appsettings.json and add the connection string:
[codesyntax lang=”text”]

"ConnectionStrings": {
    "DefaultConnection": "Server=localhost;Database=LoginApp;User Id=your_username;Password=your_password;TrustServerCertificate=True;"
  },

"ConnectionStrings": {

"DefaultConnection": "Server=localhost;Database=LoginApp;User Id=your_username;Password=your_password;TrustServerCertificate=True;"

[/codesyntax]
Note: I need to add ‘TrustServerCertificate=True;’

Create ApplicationDbContext Create a new file ApplicationDbContext.cs
[codesyntax lang=”csharp”]

using Microsoft.AspNetCore.Identity.EntityFrameworkCore;
using Microsoft.EntityFrameworkCore;

namespace LoginApp
{
    public class ApplicationDbContext : IdentityDbContext
    {
        public ApplicationDbContext(DbContextOptions&lt;ApplicationDbContext&gt; options)
            : base(options)
        {
        }
    }
}

using Microsoft.AspNetCore.Identity.EntityFrameworkCore;

using Microsoft.EntityFrameworkCore;

namespace LoginApp

{

public class ApplicationDbContext : IdentityDbContext

{

public ApplicationDbContext(DbContextOptions<ApplicationDbContext> options)

: base(options)

{

}

[/codesyntax]

Update Program.cs Replace the content of Program.cs:
[codesyntax lang=”csharp”]

using LoginApp;
using Microsoft.AspNetCore.Identity;
using Microsoft.EntityFrameworkCore;

var builder = WebApplication.CreateBuilder(args);

// Add services to the container.
builder.Services.AddControllersWithViews();

builder.Services.AddDbContext&lt;ApplicationDbContext&gt;(options =&gt;
    options.UseSqlServer(builder.Configuration.GetConnectionString("DefaultConnection")));

builder.Services.AddIdentity&lt;IdentityUser, IdentityRole&gt;()
    .AddEntityFrameworkStores&lt;ApplicationDbContext&gt;();

var app = builder.Build();

// Configure the HTTP request pipeline.
if (!app.Environment.IsDevelopment())
{
    app.UseExceptionHandler("/Home/Error");
    app.UseHsts();
}

app.UseHttpsRedirection();
app.UseStaticFiles();

app.UseRouting();

app.UseAuthentication();
app.UseAuthorization();

app.MapControllerRoute(
    name: "default",
    pattern: "{controller=Home}/{action=Index}/{id?}");

// Initialize the database
using (var scope = app.Services.CreateScope())
{
    var services = scope.ServiceProvider;
    try
    {
        var context = services.GetRequiredService&lt;ApplicationDbContext&gt;();
        context.Database.EnsureCreated();
        await DbInitializer.Initialize(services);
    }
    catch (Exception ex)
    {
        var logger = services.GetRequiredService&lt;ILogger&lt;Program&gt;&gt;();
        logger.LogError(ex, "An error occurred while seeding the database.");
    }
}

app.Run();

using LoginApp;

using Microsoft.AspNetCore.Identity;

using Microsoft.EntityFrameworkCore;

var builder = WebApplication.CreateBuilder(args);

// Add services to the container.

builder.Services.AddControllersWithViews();

builder.Services.AddDbContext<ApplicationDbContext>(options =>

options.UseSqlServer(builder.Configuration.GetConnectionString("DefaultConnection")));

builder.Services.AddIdentity<IdentityUser, IdentityRole>()

.AddEntityFrameworkStores<ApplicationDbContext>();

var app = builder.Build();

// Configure the HTTP request pipeline.

if (!app.Environment.IsDevelopment())

{

app.UseExceptionHandler("/Home/Error");

app.UseHsts();

}

app.UseHttpsRedirection();

app.UseStaticFiles();

app.UseRouting();

app.UseAuthentication();

app.UseAuthorization();

app.MapControllerRoute(

name: "default",

pattern: "{controller=Home}/{action=Index}/{id?}");

// Initialize the database

using (var scope = app.Services.CreateScope())

{

var services = scope.ServiceProvider;

try

{

var context = services.GetRequiredService<ApplicationDbContext>();

context.Database.EnsureCreated();

await DbInitializer.Initialize(services);

}

catch (Exception ex)

{

var logger = services.GetRequiredService<ILogger<Program>>();

logger.LogError(ex, "An error occurred while seeding the database.");

}

app.Run();

[/codesyntax]

Create Login Model Create Models/LoginModel.cs:
[codesyntax lang=”csharp”]

using System.ComponentModel.DataAnnotations;

namespace LoginApp.Models
{
    public class LoginModel
    {
        [Required]
        [EmailAddress]
        public string Email { get; set; } = string.Empty;

        [Required]
        [DataType(DataType.Password)]
        public string Password { get; set; } = string.Empty;

        [Display(Name = "Remember me?")]
        public bool RememberMe { get; set; }
    }
}

using System.ComponentModel.DataAnnotations;

namespace LoginApp.Models

{

public class LoginModel

{

[Required]

[EmailAddress]

public string Email { get; set; } = string.Empty;

[Required]

[DataType(DataType.Password)]

public string Password { get; set; } = string.Empty;

[Display(Name = "Remember me?")]

public bool RememberMe { get; set; }

}

[/codesyntax]

Create Account Controller Create Controllers/AccountController.cs:
[codesyntax lang=”csharp”]

using LoginApp.Models;
using Microsoft.AspNetCore.Identity;
using Microsoft.AspNetCore.Mvc;

namespace LoginApp.Controllers
{
    public class AccountController : Controller
    {
        private readonly SignInManager&lt;IdentityUser&gt; _signInManager;

        public AccountController(SignInManager&lt;IdentityUser&gt; signInManager)
        {
            _signInManager = signInManager;
        }

        [HttpGet]
        public IActionResult Login()
        {
            return View();
        }

        [HttpPost]
        public async Task&lt;IActionResult&gt; Login(LoginModel model)
        {
            if (ModelState.IsValid)
            {
                var result = await _signInManager.PasswordSignInAsync(model.Email, model.Password, model.RememberMe, lockoutOnFailure: false);
                if (result.Succeeded)
                {
                    return RedirectToAction("Index", "Home");
                }
                ModelState.AddModelError(string.Empty, "Invalid login attempt.");
            }
            return View(model);
        }
    }
}

using LoginApp.Models;

using Microsoft.AspNetCore.Identity;

using Microsoft.AspNetCore.Mvc;

namespace LoginApp.Controllers

{

public class AccountController : Controller

{

private readonly SignInManager<IdentityUser> _signInManager;

public AccountController(SignInManager<IdentityUser> signInManager)

{

_signInManager = signInManager;

}

[HttpGet]

public IActionResult Login()

{

return View();

}

[HttpPost]

public async Task<IActionResult> Login(LoginModel model)

{

if (ModelState.IsValid)

{

var result = await _signInManager.PasswordSignInAsync(model.Email, model.Password, model.RememberMe, lockoutOnFailure: false);

if (result.Succeeded)

{

return RedirectToAction("Index", "Home");

}

ModelState.AddModelError(string.Empty, "Invalid login attempt.");

}

return View(model);

}

[/codesyntax]

Create Login View Create Views/Account/Login.cshtml:
[codesyntax lang=”html4strict”]

@model LoginApp.Models.LoginModel

&lt;h2&gt;Login&lt;/h2&gt;

&lt;form asp-action="Login" method="post"&gt;
    &lt;div asp-validation-summary="ModelOnly" class="text-danger"&gt;&lt;/div&gt;
    &lt;div class="form-group"&gt;
        &lt;label asp-for="Email"&gt;&lt;/label&gt;
        &lt;input asp-for="Email" class="form-control" /&gt;
        &lt;span asp-validation-for="Email" class="text-danger"&gt;&lt;/span&gt;
    &lt;/div&gt;
    &lt;div class="form-group"&gt;
        &lt;label asp-for="Password"&gt;&lt;/label&gt;
        &lt;input asp-for="Password" class="form-control" /&gt;
        &lt;span asp-validation-for="Password" class="text-danger"&gt;&lt;/span&gt;
    &lt;/div&gt;
    &lt;div class="form-group"&gt;
        &lt;div class="checkbox"&gt;
            &lt;label&gt;
                &lt;input asp-for="RememberMe" /&gt; @Html.DisplayNameFor(m =&gt; m.RememberMe)
            &lt;/label&gt;
        &lt;/div&gt;
    &lt;/div&gt;
    &lt;button type="submit" class="btn btn-primary"&gt;Log in&lt;/button&gt;
&lt;/form&gt;

@model LoginApp.Models.LoginModel

<h2>Login</h2>

</div>

</div>

<label>

<input asp-for="RememberMe" /> @Html.DisplayNameFor(m => m.RememberMe)

</label>

</div>

</form>

[/codesyntax]

Set up the database. Create a new database ‘LoginApp’

Add a test user Create DbInitializer.cs:
[codesyntax lang=”csharp”]

using Microsoft.AspNetCore.Identity;

namespace LoginApp
{
    public static class DbInitializer
    {
        public static async Task Initialize(IServiceProvider serviceProvider)
        {
            var userManager = serviceProvider.GetRequiredService&lt;UserManager&lt;IdentityUser&gt;&gt;();

            string email = "admin@example.com";
            string password = "Admin123!";

            if (await userManager.FindByEmailAsync(email) == null)
            {
                var user = new IdentityUser { UserName = email, Email = email };
                await userManager.CreateAsync(user, password);
            }
        }
    }
}

using Microsoft.AspNetCore.Identity;

namespace LoginApp

{

public static class DbInitializer

{

public static async Task Initialize(IServiceProvider serviceProvider)

{

var userManager = serviceProvider.GetRequiredService<UserManager<IdentityUser>>();

string email = "admin@example.com";

string password = "Admin123!";

if (await userManager.FindByEmailAsync(email) == null)

{

var user = new IdentityUser { UserName = email, Email = email };

await userManager.CreateAsync(user, password);

}

[/codesyntax]
Note: it’ll create a new dummy user with
email: admin@example.com
password: Admin123!

Run the application Execute:

dotnet run

1

dotnet run
Navigate to http://localhost:5000/Account/Login in your browser.

create some navigation menus (login, logout, etc) on the homepage
Create a new file called _NavBar.cshtml in the Views/Shared folder with the following content:
[codesyntax lang=”html4strict”]

@using Microsoft.AspNetCore.Identity
@inject SignInManager&lt;IdentityUser&gt; SignInManager
@inject UserManager&lt;IdentityUser&gt; UserManager

&lt;nav class="navbar navbar-expand-sm navbar-toggleable-sm navbar-light bg-white border-bottom box-shadow mb-3"&gt;
    &lt;div class="container"&gt;
        &lt;a class="navbar-brand" asp-area="" asp-controller="Home" asp-action="Index"&gt;LoginApp&lt;/a&gt;
        &lt;button class="navbar-toggler" type="button" data-toggle="collapse" data-target=".navbar-collapse" aria-controls="navbarSupportedContent"
                aria-expanded="false" aria-label="Toggle navigation"&gt;
            &lt;span class="navbar-toggler-icon"&gt;&lt;/span&gt;
        &lt;/button&gt;
        &lt;div class="navbar-collapse collapse d-sm-inline-flex justify-content-between"&gt;
            &lt;ul class="navbar-nav flex-grow-1"&gt;
                &lt;li class="nav-item"&gt;
                    &lt;a class="nav-link text-dark" asp-area="" asp-controller="Home" asp-action="Index"&gt;Home&lt;/a&gt;
                &lt;/li&gt;
                @if (SignInManager.IsSignedIn(User))
                {
                    &lt;li class="nav-item"&gt;
                        &lt;a class="nav-link text-dark" asp-area="" asp-controller="Account" asp-action="Logout"&gt;Logout&lt;/a&gt;
                    &lt;/li&gt;
                }
                else
                {
                    &lt;li class="nav-item"&gt;
                        &lt;a class="nav-link text-dark" asp-area="" asp-controller="Account" asp-action="Login"&gt;Login&lt;/a&gt;
                    &lt;/li&gt;
                    &lt;li class="nav-item"&gt;
                        &lt;a class="nav-link text-dark" asp-area="" asp-controller="Account" asp-action="Register"&gt;Register&lt;/a&gt;
                    &lt;/li&gt;
                }
            &lt;/ul&gt;
        &lt;/div&gt;
    &lt;/div&gt;
&lt;/nav&gt;

@using Microsoft.AspNetCore.Identity

@inject SignInManager<IdentityUser> SignInManager

@inject UserManager<IdentityUser> UserManager

<a class="navbar-brand" asp-area="" asp-controller="Home" asp-action="Index">LoginApp</a>

<button class="navbar-toggler" type="button" data-toggle="collapse" data-target=".navbar-collapse" aria-controls="navbarSupportedContent"

aria-expanded="false" aria-label="Toggle navigation">

</button>

</li>

@if (SignInManager.IsSignedIn(User))

{

<a class="nav-link text-dark" asp-area="" asp-controller="Account" asp-action="Logout">Logout</a>

</li>

}

else

{

<a class="nav-link text-dark" asp-area="" asp-controller="Account" asp-action="Login">Login</a>

</li>

<a class="nav-link text-dark" asp-area="" asp-controller="Account" asp-action="Register">Register</a>

</li>

}

</ul>

</div>

</nav>

[/codesyntax]

Now, let’s include this partial view in your layout file. Open the Views/Shared/_Layout.cshtml file and add the following line just after the opening <body> tag:
[codesyntax lang=”html4strict”]

&lt;body&gt;
    &lt;partial name="_NavBar" /&gt;
    &lt;!--header&gt;
        &lt;nav class="navbar navbar-expand-sm navbar-toggleable-sm navbar-light bg-white border-bottom box-shadow mb-3"&gt;
            &lt;div class="container-fluid"&gt;
                &lt;a class="navbar-brand" asp-area="" asp-controller="Home" asp-action="Index"&gt;LoginApp&lt;/a&gt;
                &lt;button class="navbar-toggler" type="button" data-bs-toggle="collapse" data-bs-target=".navbar-collapse" aria-controls="navbarSupportedContent"
                        aria-expanded="false" aria-label="Toggle navigation"&gt;
                    &lt;span class="navbar-toggler-icon"&gt;&lt;/span&gt;
                &lt;/button&gt;
                &lt;div class="navbar-collapse collapse d-sm-inline-flex justify-content-between"&gt;
                    &lt;ul class="navbar-nav flex-grow-1"&gt;
                        &lt;li class="nav-item"&gt;
                            &lt;a class="nav-link text-dark" asp-area="" asp-controller="Home" asp-action="Index"&gt;Home&lt;/a&gt;
                        &lt;/li&gt;
                        &lt;li class="nav-item"&gt;
                            &lt;a class="nav-link text-dark" asp-area="" asp-controller="Home" asp-action="Privacy"&gt;Privacy&lt;/a&gt;
                        &lt;/li&gt;
                    &lt;/ul&gt;
                &lt;/div&gt;
            &lt;/div&gt;
        &lt;/nav&gt;
    &lt;/header--&gt;
    &lt;!-- ... existing content ... --&gt;
&lt;/body&gt;

<body>

<!--header>

<a class="navbar-brand" asp-area="" asp-controller="Home" asp-action="Index">LoginApp</a>

<button class="navbar-toggler" type="button" data-bs-toggle="collapse" data-bs-target=".navbar-collapse" aria-controls="navbarSupportedContent"

aria-expanded="false" aria-label="Toggle navigation">

</button>

</li>

<a class="nav-link text-dark" asp-area="" asp-controller="Home" asp-action="Privacy">Privacy</a>

</li>

</ul>

</div>

</nav>

</header-->

</body>

[/codesyntax]
Note: I need to remove the default <header> tag to use the new partial navbar

create controller for account logout
modify Controllers/AccountController.cs
[codesyntax lang=”csharp”]

using LoginApp.Models;
using Microsoft.AspNetCore.Identity;
using Microsoft.AspNetCore.Mvc;

namespace LoginApp.Controllers
{
    public class AccountController : Controller
    {
        ...

        [HttpPost]
        public async Task&lt;IActionResult&gt; Login(LoginModel model)
        {
           ...
        }

        [HttpPost]
        [ValidateAntiForgeryToken]
        public async Task&lt;IActionResult&gt; Logout()
        {
            await _signInManager.SignOutAsync();
            return RedirectToAction("Index", "Home");
        }
    }
}

using LoginApp.Models;

using Microsoft.AspNetCore.Identity;

using Microsoft.AspNetCore.Mvc;

namespace LoginApp.Controllers

{

public class AccountController : Controller

{

...

[HttpPost]

public async Task<IActionResult> Login(LoginModel model)

{

...

}

[HttpPost]

[ValidateAntiForgeryToken]

public async Task<IActionResult> Logout()

{

await _signInManager.SignOutAsync();

return RedirectToAction("Index", "Home");

}

[/codesyntax]

Now, let’s update the _NavBar.cshtml partial view to use a form for the logout action, as it should be a POST request. Update the logout link in the _NavBar.cshtml file like this:
[codesyntax lang=”html4strict”]

// ... existing code ...
@if (SignInManager.IsSignedIn(User))
{
    &lt;li class="nav-item"&gt;
        &lt;form asp-area="" asp-controller="Account" asp-action="Logout" method="post" id="logoutForm" class="navbar-right"&gt;
            &lt;button type="submit" class="btn btn-link navbar-btn navbar-link"&gt;Logout&lt;/button&gt;
        &lt;/form&gt;
    &lt;/li&gt;
}
// ... existing code ...

// ... existing code ...

@if (SignInManager.IsSignedIn(User))

{

<button type="submit" class="btn btn-link navbar-btn navbar-link">Logout</button>

</form>

</li>

}

// ... existing code ...

[/codesyntax]
at the end of this file, add this javascript
[codesyntax lang=”html4strict”]

&lt;script&gt;
    $(function() {
        $('#logoutForm').on('click', function(e) {
            e.preventDefault();
            $(this).submit();
        });
    });
&lt;/script&gt;

$(function() {

$('#logoutForm').on('click', function(e) {

e.preventDefault();

$(this).submit();

});

</script>

[/codesyntax]

Add controller for registration and forgot password?

Developing ASP.NET Core Project With VS Code – Razor Pages

ref: https://docs.microsoft.com/en-us/aspnet/core/tutorials/razor-pages/razor-pages-start?view=aspnetcore-2.2&tabs=visual-studio-code

Create a Razor Pages web app
Type in the terminal

teddy@teddy:~/Documents/dotnet$ dotnet new webApp -o RazorPagesMovie
The template "ASP.NET Core Web App" was created successfully.
This template contains technologies from parties other than Microsoft, see https://aka.ms/aspnetcore-template-3pn-210 for details.

Processing post-creation actions...
Running 'dotnet restore' on RazorPagesMovie/RazorPagesMovie.csproj...
  Restore completed in 476.81 ms for /home/teddy/Documents/dotnet/RazorPagesMovie/RazorPagesMovie.csproj.

Restore succeeded.

teddy@teddy:~/Documents/dotnet$ dotnet new webApp -o RazorPagesMovie

The template "ASP.NET Core Web App" was created successfully.

This template contains technologies from parties other than Microsoft, see https://aka.ms/aspnetcore-template-3pn-210 for details.

Processing post-creation actions...

Running 'dotnet restore' on RazorPagesMovie/RazorPagesMovie.csproj...

Restore completed in 476.81 ms for /home/teddy/Documents/dotnet/RazorPagesMovie/RazorPagesMovie.csproj.

Restore succeeded.

Open it on VSCode

teddy@teddy:~/Documents/dotnet$ code -r RazorPagesMovie

1	teddy@teddy:~/Documents/dotnet$ code -r RazorPagesMovie

After the status bar’s OmniSharp flame icon turns green, a dialog asks Required assets to build and debug are missing from ‘RazorPagesMovie’. Add them? Select Yes.

A .vscode directory, containing launch.json and tasks.json files, is added to the project’s root directory.

Run the app
On the VSCode, open the terminal by pressing CTRL + ~
then type

teddy@teddy:~/Documents/dotnet/RazorPagesMovie$ dotnet dev-certs https
A valid HTTPS certificate is already present.

1 2	teddy@teddy:~/Documents/dotnet/RazorPagesMovie$ dotnet dev-certs https A valid HTTPS certificate is already present.

NOTE: I FOUND THIS COMMAND: ‘dotnet dev-certs https –trust’ IS NOT WORKING
Then Press Ctrl-F5 to run without the debugger. It’ll open the browser automatically with this url: https://localhost:5001/

Add a data model
Add a folder named Models.
Add a class to the Models folder named Movie.cs.
Add the following properties to the Movie class:

using System;
using System.ComponentModel.DataAnnotations;

namespace RazorPagesMovie.Models
{
    public class Movie
    {
        public int ID {get; set;}
        public string Title {get; set;}

        [DataType(DataType.Date)]
        public DateTime ReleaseDate {get; set;}
        public string Genre {get; set;}
        public decimal Price {get; set;}
    }
}

using System;

using System.ComponentModel.DataAnnotations;

namespace RazorPagesMovie.Models

{

public class Movie

{

public int ID {get; set;}

public string Title {get; set;}

[DataType(DataType.Date)]

public DateTime ReleaseDate {get; set;}

public string Genre {get; set;}

public decimal Price {get; set;}

}

Add a database context class
Add the following RazorPagesMovieContext class to the Data folder:

using Microsoft.EntityFrameworkCore;

namespace RazorPagesMovie.Models
{
    public class RazorPagesMovieContext : DbContext
    {
        public RazorPagesMovieContext(DbContextOptions<RazorPagesMovieContext> options) : base(options)
        {

        }

        public DbSet<RazorPagesMovie.Models.Movie> Movie {get; set;}
    }
}

using Microsoft.EntityFrameworkCore;

namespace RazorPagesMovie.Models

{

public class RazorPagesMovieContext : DbContext

{

public RazorPagesMovieContext(DbContextOptions<RazorPagesMovieContext> options) : base(options)

{

}

public DbSet<RazorPagesMovie.Models.Movie> Movie {get; set;}

}

Add a database connection string
Add a connection string to the appsettings.json file as shown in the following highlighted code:

{
  "Logging": {
    "LogLevel": {
      "Default": "Warning"
    }
  },
  "AllowedHosts": "*",
  "ConnectionStrings": {
    "MovieContext": "DataSource=MvcMovie.db"
  }
}

{

"Logging": {

"LogLevel": {

"Default": "Warning"

}

"AllowedHosts": "*",

"ConnectionStrings": {

"MovieContext": "DataSource=MvcMovie.db"

}

Add required NuGet packages
Run the following .NET Core CLI command to add SQLite and CodeGeneration.Design to the project:

dotnet add package Microsoft.EntityFrameworkCore.SQLite
dotnet add package Microsoft.VisualStudio.Web.CodeGeneration.Design
dotnet add package Microsoft.EntityFrameworkCore.Design

dotnet add package Microsoft.EntityFrameworkCore.SQLite

dotnet add package Microsoft.VisualStudio.Web.CodeGeneration.Design

dotnet add package Microsoft.EntityFrameworkCore.Design

teddy@teddy:~/Documents/dotnet/RazorPagesMovie$ dotnet add package Microsoft.EntityFrameworkCore.SQLite
  Writing /tmp/tmp6s15JK.tmp
info : Adding PackageReference for package 'Microsoft.EntityFrameworkCore.SQLite' into project '/home/teddy/Documents/dotnet/RazorPagesMovie/RazorPagesMovie.csproj'.
info : Restoring packages for /home/teddy/Documents/dotnet/RazorPagesMovie/RazorPagesMovie.csproj...
info :   GET https://api.nuget.org/v3-flatcontainer/microsoft.entityframeworkcore.sqlite/index.json
info :   OK https://api.nuget.org/v3-flatcontainer/microsoft.entityframeworkcore.sqlite/index.json 1010ms
info :   GET https://api.nuget.org/v3-flatcontainer/microsoft.entityframeworkcore.sqlite/2.2.4/microsoft.entityframeworkcore.sqlite.2.2.4.nupkg
info :   OK https://api.nuget.org/v3-flatcontainer/microsoft.entityframeworkcore.sqlite/2.2.4/microsoft.entityframeworkcore.sqlite.2.2.4.nupkg 34ms
info :   GET https://api.nuget.org/v3-flatcontainer/microsoft.entityframeworkcore.sqlite.core/index.json
info :   GET https://api.nuget.org/v3-flatcontainer/sqlitepclraw.bundle_green/index.json
info :   OK https://api.nuget.org/v3-flatcontainer/microsoft.entityframeworkcore.sqlite.core/index.json 998ms
info :   GET https://api.nuget.org/v3-flatcontainer/microsoft.entityframeworkcore.sqlite.core/2.2.4/microsoft.entityframeworkcore.sqlite.core.2.2.4.nupkg
info :   OK https://api.nuget.org/v3-flatcontainer/microsoft.entityframeworkcore.sqlite.core/2.2.4/microsoft.entityframeworkcore.sqlite.core.2.2.4.nupkg 32ms
info :   GET https://api.nuget.org/v3-flatcontainer/microsoft.entityframeworkcore.relational/index.json
info :   GET https://api.nuget.org/v3-flatcontainer/microsoft.data.sqlite.core/index.json
info :   OK https://api.nuget.org/v3-flatcontainer/sqlitepclraw.bundle_green/index.json 1136ms
info :   GET https://api.nuget.org/v3-flatcontainer/sqlitepclraw.bundle_green/1.1.12/sqlitepclraw.bundle_green.1.1.12.nupkg
info :   OK https://api.nuget.org/v3-flatcontainer/sqlitepclraw.bundle_green/1.1.12/sqlitepclraw.bundle_green.1.1.12.nupkg 33ms
info :   GET https://api.nuget.org/v3-flatcontainer/sqlitepclraw.core/index.json
info :   GET https://api.nuget.org/v3-flatcontainer/sqlitepclraw.provider.e_sqlite3.netstandard11/index.json
info :   GET https://api.nuget.org/v3-flatcontainer/sqlitepclraw.lib.e_sqlite3.v110_xp/index.json
info :   GET https://api.nuget.org/v3-flatcontainer/sqlitepclraw.lib.e_sqlite3.osx/index.json
info :   GET https://api.nuget.org/v3-flatcontainer/sqlitepclraw.lib.e_sqlite3.linux/index.json
info :   OK https://api.nuget.org/v3-flatcontainer/microsoft.entityframeworkcore.relational/index.json 1002ms
info :   GET https://api.nuget.org/v3-flatcontainer/microsoft.entityframeworkcore.relational/2.2.4/microsoft.entityframeworkcore.relational.2.2.4.nupkg
info :   OK https://api.nuget.org/v3-flatcontainer/microsoft.entityframeworkcore.relational/2.2.4/microsoft.entityframeworkcore.relational.2.2.4.nupkg 31ms
info :   OK https://api.nuget.org/v3-flatcontainer/microsoft.data.sqlite.core/index.json 1100ms
info :   GET https://api.nuget.org/v3-flatcontainer/microsoft.data.sqlite.core/2.2.4/microsoft.data.sqlite.core.2.2.4.nupkg
info :   GET https://api.nuget.org/v3-flatcontainer/microsoft.entityframeworkcore/index.json
info :   OK https://api.nuget.org/v3-flatcontainer/microsoft.data.sqlite.core/2.2.4/microsoft.data.sqlite.core.2.2.4.nupkg 33ms
info :   OK https://api.nuget.org/v3-flatcontainer/sqlitepclraw.lib.e_sqlite3.v110_xp/index.json 1120ms
info :   GET https://api.nuget.org/v3-flatcontainer/sqlitepclraw.lib.e_sqlite3.v110_xp/1.1.12/sqlitepclraw.lib.e_sqlite3.v110_xp.1.1.12.nupkg
info :   OK https://api.nuget.org/v3-flatcontainer/sqlitepclraw.lib.e_sqlite3.linux/index.json 1122ms
info :   GET https://api.nuget.org/v3-flatcontainer/sqlitepclraw.lib.e_sqlite3.linux/1.1.12/sqlitepclraw.lib.e_sqlite3.linux.1.1.12.nupkg
info :   OK https://api.nuget.org/v3-flatcontainer/sqlitepclraw.lib.e_sqlite3.osx/index.json 1123ms
info :   GET https://api.nuget.org/v3-flatcontainer/sqlitepclraw.lib.e_sqlite3.osx/1.1.12/sqlitepclraw.lib.e_sqlite3.osx.1.1.12.nupkg
info :   OK https://api.nuget.org/v3-flatcontainer/sqlitepclraw.provider.e_sqlite3.netstandard11/index.json 1146ms
info :   GET https://api.nuget.org/v3-flatcontainer/sqlitepclraw.provider.e_sqlite3.netstandard11/1.1.12/sqlitepclraw.provider.e_sqlite3.netstandard11.1.1.12.nupkg
info :   OK https://api.nuget.org/v3-flatcontainer/sqlitepclraw.lib.e_sqlite3.v110_xp/1.1.12/sqlitepclraw.lib.e_sqlite3.v110_xp.1.1.12.nupkg 32ms
info :   OK https://api.nuget.org/v3-flatcontainer/sqlitepclraw.lib.e_sqlite3.linux/1.1.12/sqlitepclraw.lib.e_sqlite3.linux.1.1.12.nupkg 33ms
info :   OK https://api.nuget.org/v3-flatcontainer/sqlitepclraw.lib.e_sqlite3.osx/1.1.12/sqlitepclraw.lib.e_sqlite3.osx.1.1.12.nupkg 36ms
info :   OK https://api.nuget.org/v3-flatcontainer/sqlitepclraw.provider.e_sqlite3.netstandard11/1.1.12/sqlitepclraw.provider.e_sqlite3.netstandard11.1.1.12.nupkg 31ms
info :   OK https://api.nuget.org/v3-flatcontainer/sqlitepclraw.core/index.json 1476ms
info :   GET https://api.nuget.org/v3-flatcontainer/sqlitepclraw.core/1.1.12/sqlitepclraw.core.1.1.12.nupkg
info :   OK https://api.nuget.org/v3-flatcontainer/sqlitepclraw.core/1.1.12/sqlitepclraw.core.1.1.12.nupkg 139ms
info :   OK https://api.nuget.org/v3-flatcontainer/microsoft.entityframeworkcore/index.json 1026ms
info :   GET https://api.nuget.org/v3-flatcontainer/microsoft.entityframeworkcore/2.2.4/microsoft.entityframeworkcore.2.2.4.nupkg
info :   OK https://api.nuget.org/v3-flatcontainer/microsoft.entityframeworkcore/2.2.4/microsoft.entityframeworkcore.2.2.4.nupkg 158ms
info :   GET https://api.nuget.org/v3-flatcontainer/microsoft.entityframeworkcore.abstractions/index.json
info :   GET https://api.nuget.org/v3-flatcontainer/microsoft.entityframeworkcore.analyzers/index.json
info :   OK https://api.nuget.org/v3-flatcontainer/microsoft.entityframeworkcore.abstractions/index.json 997ms
info :   GET https://api.nuget.org/v3-flatcontainer/microsoft.entityframeworkcore.abstractions/2.2.4/microsoft.entityframeworkcore.abstractions.2.2.4.nupkg
info :   OK https://api.nuget.org/v3-flatcontainer/microsoft.entityframeworkcore.analyzers/index.json 1003ms
info :   GET https://api.nuget.org/v3-flatcontainer/microsoft.entityframeworkcore.analyzers/2.2.4/microsoft.entityframeworkcore.analyzers.2.2.4.nupkg
info :   OK https://api.nuget.org/v3-flatcontainer/microsoft.entityframeworkcore.abstractions/2.2.4/microsoft.entityframeworkcore.abstractions.2.2.4.nupkg 33ms
info :   OK https://api.nuget.org/v3-flatcontainer/microsoft.entityframeworkcore.analyzers/2.2.4/microsoft.entityframeworkcore.analyzers.2.2.4.nupkg 33ms
info : Installing Microsoft.EntityFrameworkCore.Analyzers 2.2.4.
info : Installing Microsoft.EntityFrameworkCore.Abstractions 2.2.4.
info : Installing Microsoft.EntityFrameworkCore 2.2.4.
info : Installing SQLitePCLRaw.lib.e_sqlite3.linux 1.1.12.
info : Installing SQLitePCLRaw.lib.e_sqlite3.osx 1.1.12.
info : Installing SQLitePCLRaw.lib.e_sqlite3.v110_xp 1.1.12.
info : Installing SQLitePCLRaw.core 1.1.12.
info : Installing SQLitePCLRaw.provider.e_sqlite3.netstandard11 1.1.12.
info : Installing Microsoft.EntityFrameworkCore.Relational 2.2.4.
info : Installing Microsoft.Data.Sqlite.Core 2.2.4.
info : Installing SQLitePCLRaw.bundle_green 1.1.12.
info : Installing Microsoft.EntityFrameworkCore.Sqlite.Core 2.2.4.
info : Installing Microsoft.EntityFrameworkCore.Sqlite 2.2.4.
info : Package 'Microsoft.EntityFrameworkCore.SQLite' is compatible with all the specified frameworks in project '/home/teddy/Documents/dotnet/RazorPagesMovie/RazorPagesMovie.csproj'.
info : PackageReference for package 'Microsoft.EntityFrameworkCore.SQLite' version '2.2.4' added to file '/home/teddy/Documents/dotnet/RazorPagesMovie/RazorPagesMovie.csproj'.
info : Committing restore...
info : Writing assets file to disk. Path: /home/teddy/Documents/dotnet/RazorPagesMovie/obj/project.assets.json
log  : Restore completed in 9.79 sec for /home/teddy/Documents/dotnet/RazorPagesMovie/RazorPagesMovie.csproj.
teddy@teddy:~/Documents/dotnet/RazorPagesMovie$ dotnet add package Microsoft.VisualStudio.Web.CodeGeneration.Design
  Writing /tmp/tmpUPJJcI.tmp
info : Adding PackageReference for package 'Microsoft.VisualStudio.Web.CodeGeneration.Design' into project '/home/teddy/Documents/dotnet/RazorPagesMovie/RazorPagesMovie.csproj'.
info : Restoring packages for /home/teddy/Documents/dotnet/RazorPagesMovie/RazorPagesMovie.csproj...
info :   GET https://api.nuget.org/v3-flatcontainer/microsoft.visualstudio.web.codegeneration.design/index.json
info :   OK https://api.nuget.org/v3-flatcontainer/microsoft.visualstudio.web.codegeneration.design/index.json 1296ms
info :   GET https://api.nuget.org/v3-flatcontainer/microsoft.visualstudio.web.codegeneration.design/2.2.3/microsoft.visualstudio.web.codegeneration.design.2.2.3.nupkg
info :   OK https://api.nuget.org/v3-flatcontainer/microsoft.visualstudio.web.codegeneration.design/2.2.3/microsoft.visualstudio.web.codegeneration.design.2.2.3.nupkg 35ms
info :   GET https://api.nuget.org/v3-flatcontainer/microsoft.visualstudio.web.codegenerators.mvc/index.json
info :   OK https://api.nuget.org/v3-flatcontainer/microsoft.visualstudio.web.codegenerators.mvc/index.json 1004ms
info :   GET https://api.nuget.org/v3-flatcontainer/microsoft.visualstudio.web.codegenerators.mvc/2.2.3/microsoft.visualstudio.web.codegenerators.mvc.2.2.3.nupkg
info :   OK https://api.nuget.org/v3-flatcontainer/microsoft.visualstudio.web.codegenerators.mvc/2.2.3/microsoft.visualstudio.web.codegenerators.mvc.2.2.3.nupkg 34ms
info :   GET https://api.nuget.org/v3-flatcontainer/microsoft.visualstudio.web.codegeneration/index.json
info :   OK https://api.nuget.org/v3-flatcontainer/microsoft.visualstudio.web.codegeneration/index.json 1001ms
info :   GET https://api.nuget.org/v3-flatcontainer/microsoft.visualstudio.web.codegeneration/2.2.3/microsoft.visualstudio.web.codegeneration.2.2.3.nupkg
info :   OK https://api.nuget.org/v3-flatcontainer/microsoft.visualstudio.web.codegeneration/2.2.3/microsoft.visualstudio.web.codegeneration.2.2.3.nupkg 31ms
info :   GET https://api.nuget.org/v3-flatcontainer/microsoft.visualstudio.web.codegeneration.entityframeworkcore/index.json
info :   OK https://api.nuget.org/v3-flatcontainer/microsoft.visualstudio.web.codegeneration.entityframeworkcore/index.json 1001ms
info :   GET https://api.nuget.org/v3-flatcontainer/microsoft.visualstudio.web.codegeneration.entityframeworkcore/2.2.3/microsoft.visualstudio.web.codegeneration.entityframeworkcore.2.2.3.nupkg
info :   OK https://api.nuget.org/v3-flatcontainer/microsoft.visualstudio.web.codegeneration.entityframeworkcore/2.2.3/microsoft.visualstudio.web.codegeneration.entityframeworkcore.2.2.3.nupkg 32ms
info :   GET https://api.nuget.org/v3-flatcontainer/microsoft.visualstudio.web.codegeneration.core/index.json
info :   OK https://api.nuget.org/v3-flatcontainer/microsoft.visualstudio.web.codegeneration.core/index.json 1004ms
info :   GET https://api.nuget.org/v3-flatcontainer/microsoft.visualstudio.web.codegeneration.core/2.2.3/microsoft.visualstudio.web.codegeneration.core.2.2.3.nupkg
info :   OK https://api.nuget.org/v3-flatcontainer/microsoft.visualstudio.web.codegeneration.core/2.2.3/microsoft.visualstudio.web.codegeneration.core.2.2.3.nupkg 34ms
info :   GET https://api.nuget.org/v3-flatcontainer/microsoft.visualstudio.web.codegeneration.templating/index.json
info :   OK https://api.nuget.org/v3-flatcontainer/microsoft.visualstudio.web.codegeneration.templating/index.json 994ms
info :   GET https://api.nuget.org/v3-flatcontainer/microsoft.visualstudio.web.codegeneration.templating/2.2.3/microsoft.visualstudio.web.codegeneration.templating.2.2.3.nupkg
info :   OK https://api.nuget.org/v3-flatcontainer/microsoft.visualstudio.web.codegeneration.templating/2.2.3/microsoft.visualstudio.web.codegeneration.templating.2.2.3.nupkg 31ms
info :   GET https://api.nuget.org/v3-flatcontainer/microsoft.visualstudio.web.codegeneration.utils/index.json
info :   OK https://api.nuget.org/v3-flatcontainer/microsoft.visualstudio.web.codegeneration.utils/index.json 1002ms
info :   GET https://api.nuget.org/v3-flatcontainer/microsoft.visualstudio.web.codegeneration.utils/2.2.3/microsoft.visualstudio.web.codegeneration.utils.2.2.3.nupkg
info :   OK https://api.nuget.org/v3-flatcontainer/microsoft.visualstudio.web.codegeneration.utils/2.2.3/microsoft.visualstudio.web.codegeneration.utils.2.2.3.nupkg 31ms
info :   GET https://api.nuget.org/v3-flatcontainer/microsoft.visualstudio.web.codegeneration.contracts/index.json
info :   GET https://api.nuget.org/v3-flatcontainer/microsoft.codeanalysis.csharp.workspaces/index.json
info :   GET https://api.nuget.org/v3-flatcontainer/nuget.frameworks/index.json
info :   OK https://api.nuget.org/v3-flatcontainer/microsoft.visualstudio.web.codegeneration.contracts/index.json 1000ms
info :   GET https://api.nuget.org/v3-flatcontainer/microsoft.visualstudio.web.codegeneration.contracts/2.2.3/microsoft.visualstudio.web.codegeneration.contracts.2.2.3.nupkg
info :   OK https://api.nuget.org/v3-flatcontainer/microsoft.visualstudio.web.codegeneration.contracts/2.2.3/microsoft.visualstudio.web.codegeneration.contracts.2.2.3.nupkg 31ms
info :   OK https://api.nuget.org/v3-flatcontainer/microsoft.codeanalysis.csharp.workspaces/index.json 1106ms
info :   GET https://api.nuget.org/v3-flatcontainer/microsoft.codeanalysis.csharp.workspaces/2.8.0/microsoft.codeanalysis.csharp.workspaces.2.8.0.nupkg
info :   OK https://api.nuget.org/v3-flatcontainer/nuget.frameworks/index.json 1132ms
info :   GET https://api.nuget.org/v3-flatcontainer/nuget.frameworks/4.7.0/nuget.frameworks.4.7.0.nupkg
info :   OK https://api.nuget.org/v3-flatcontainer/microsoft.codeanalysis.csharp.workspaces/2.8.0/microsoft.codeanalysis.csharp.workspaces.2.8.0.nupkg 35ms
info :   OK https://api.nuget.org/v3-flatcontainer/nuget.frameworks/4.7.0/nuget.frameworks.4.7.0.nupkg 39ms
info :   GET https://api.nuget.org/v3-flatcontainer/microsoft.codeanalysis.workspaces.common/index.json
info :   OK https://api.nuget.org/v3-flatcontainer/microsoft.codeanalysis.workspaces.common/index.json 1029ms
info :   GET https://api.nuget.org/v3-flatcontainer/microsoft.codeanalysis.workspaces.common/2.8.0/microsoft.codeanalysis.workspaces.common.2.8.0.nupkg
info :   OK https://api.nuget.org/v3-flatcontainer/microsoft.codeanalysis.workspaces.common/2.8.0/microsoft.codeanalysis.workspaces.common.2.8.0.nupkg 32ms
info :   GET https://api.nuget.org/v3-flatcontainer/system.composition/index.json
info :   GET https://api.nuget.org/v3-flatcontainer/system.linq.parallel/index.json
info :   OK https://api.nuget.org/v3-flatcontainer/system.composition/index.json 1004ms
info :   GET https://api.nuget.org/v3-flatcontainer/system.composition/1.0.31/system.composition.1.0.31.nupkg
info :   OK https://api.nuget.org/v3-flatcontainer/system.linq.parallel/index.json 1006ms
info :   GET https://api.nuget.org/v3-flatcontainer/system.linq.parallel/4.3.0/system.linq.parallel.4.3.0.nupkg
info :   OK https://api.nuget.org/v3-flatcontainer/system.composition/1.0.31/system.composition.1.0.31.nupkg 32ms
info :   GET https://api.nuget.org/v3-flatcontainer/system.composition.attributedmodel/index.json
info :   GET https://api.nuget.org/v3-flatcontainer/system.composition.convention/index.json
info :   GET https://api.nuget.org/v3-flatcontainer/system.composition.hosting/index.json
info :   GET https://api.nuget.org/v3-flatcontainer/system.composition.runtime/index.json
info :   GET https://api.nuget.org/v3-flatcontainer/system.composition.typedparts/index.json
info :   OK https://api.nuget.org/v3-flatcontainer/system.linq.parallel/4.3.0/system.linq.parallel.4.3.0.nupkg 39ms
info :   OK https://api.nuget.org/v3-flatcontainer/system.composition.attributedmodel/index.json 997ms
info :   GET https://api.nuget.org/v3-flatcontainer/system.composition.attributedmodel/1.0.31/system.composition.attributedmodel.1.0.31.nupkg
info :   OK https://api.nuget.org/v3-flatcontainer/system.composition.convention/index.json 1042ms
info :   GET https://api.nuget.org/v3-flatcontainer/system.composition.convention/1.0.31/system.composition.convention.1.0.31.nupkg
info :   OK https://api.nuget.org/v3-flatcontainer/system.composition.attributedmodel/1.0.31/system.composition.attributedmodel.1.0.31.nupkg 76ms
info :   OK https://api.nuget.org/v3-flatcontainer/system.composition.convention/1.0.31/system.composition.convention.1.0.31.nupkg 35ms
info :   OK https://api.nuget.org/v3-flatcontainer/system.composition.typedparts/index.json 1109ms
info :   GET https://api.nuget.org/v3-flatcontainer/system.composition.typedparts/1.0.31/system.composition.typedparts.1.0.31.nupkg
info :   OK https://api.nuget.org/v3-flatcontainer/system.composition.runtime/index.json 1120ms
info :   GET https://api.nuget.org/v3-flatcontainer/system.composition.runtime/1.0.31/system.composition.runtime.1.0.31.nupkg
info :   OK https://api.nuget.org/v3-flatcontainer/system.composition.typedparts/1.0.31/system.composition.typedparts.1.0.31.nupkg 33ms
info :   OK https://api.nuget.org/v3-flatcontainer/system.composition.hosting/index.json 1149ms
info :   GET https://api.nuget.org/v3-flatcontainer/system.composition.hosting/1.0.31/system.composition.hosting.1.0.31.nupkg
info :   OK https://api.nuget.org/v3-flatcontainer/system.composition.runtime/1.0.31/system.composition.runtime.1.0.31.nupkg 38ms
info :   OK https://api.nuget.org/v3-flatcontainer/system.composition.hosting/1.0.31/system.composition.hosting.1.0.31.nupkg 39ms
info : Installing System.Composition.Hosting 1.0.31.
info : Installing System.Composition.Runtime 1.0.31.
info : Installing System.Composition.TypedParts 1.0.31.
info : Installing System.Composition.Convention 1.0.31.
info : Installing System.Composition.AttributedModel 1.0.31.
info : Installing System.Composition 1.0.31.
info : Installing System.Linq.Parallel 4.3.0.
info : Installing Microsoft.CodeAnalysis.Workspaces.Common 2.8.0.
info : Installing Microsoft.CodeAnalysis.CSharp.Workspaces 2.8.0.
info : Installing NuGet.Frameworks 4.7.0.
info : Installing Microsoft.VisualStudio.Web.CodeGeneration.Contracts 2.2.3.
info : Installing Microsoft.VisualStudio.Web.CodeGeneration.Utils 2.2.3.
info : Installing Microsoft.VisualStudio.Web.CodeGeneration.Templating 2.2.3.
info : Installing Microsoft.VisualStudio.Web.CodeGeneration.Core 2.2.3.
info : Installing Microsoft.VisualStudio.Web.CodeGeneration.EntityFrameworkCore 2.2.3.
info : Installing Microsoft.VisualStudio.Web.CodeGeneration 2.2.3.
info : Installing Microsoft.VisualStudio.Web.CodeGeneration.Design 2.2.3.
info : Installing Microsoft.VisualStudio.Web.CodeGenerators.Mvc 2.2.3.
info : Package 'Microsoft.VisualStudio.Web.CodeGeneration.Design' is compatible with all the specified frameworks in project '/home/teddy/Documents/dotnet/RazorPagesMovie/RazorPagesMovie.csproj'.
info : PackageReference for package 'Microsoft.VisualStudio.Web.CodeGeneration.Design' version '2.2.3' added to file '/home/teddy/Documents/dotnet/RazorPagesMovie/RazorPagesMovie.csproj'.
info : Committing restore...
info : Generating MSBuild file /home/teddy/Documents/dotnet/RazorPagesMovie/obj/RazorPagesMovie.csproj.nuget.g.props.
info : Writing assets file to disk. Path: /home/teddy/Documents/dotnet/RazorPagesMovie/obj/project.assets.json
log  : Restore completed in 14.77 sec for /home/teddy/Documents/dotnet/RazorPagesMovie/RazorPagesMovie.csproj.
teddy@teddy:~/Documents/dotnet/RazorPagesMovie$ dotnet add package Microsoft.EntityFrameworkCore.Design
  Writing /tmp/tmprEZck2.tmp
info : Adding PackageReference for package 'Microsoft.EntityFrameworkCore.Design' into project '/home/teddy/Documents/dotnet/RazorPagesMovie/RazorPagesMovie.csproj'.
info : Restoring packages for /home/teddy/Documents/dotnet/RazorPagesMovie/RazorPagesMovie.csproj...
info :   GET https://api.nuget.org/v3-flatcontainer/microsoft.entityframeworkcore.design/index.json
info :   OK https://api.nuget.org/v3-flatcontainer/microsoft.entityframeworkcore.design/index.json 1252ms
info :   GET https://api.nuget.org/v3-flatcontainer/microsoft.entityframeworkcore.design/2.2.4/microsoft.entityframeworkcore.design.2.2.4.nupkg
info :   OK https://api.nuget.org/v3-flatcontainer/microsoft.entityframeworkcore.design/2.2.4/microsoft.entityframeworkcore.design.2.2.4.nupkg 34ms
info : Installing Microsoft.EntityFrameworkCore.Design 2.2.4.
info : Package 'Microsoft.EntityFrameworkCore.Design' is compatible with all the specified frameworks in project '/home/teddy/Documents/dotnet/RazorPagesMovie/RazorPagesMovie.csproj'.
info : PackageReference for package 'Microsoft.EntityFrameworkCore.Design' version '2.2.4' added to file '/home/teddy/Documents/dotnet/RazorPagesMovie/RazorPagesMovie.csproj'.
info : Committing restore...
info : Generating MSBuild file /home/teddy/Documents/dotnet/RazorPagesMovie/obj/RazorPagesMovie.csproj.nuget.g.props.
info : Writing assets file to disk. Path: /home/teddy/Documents/dotnet/RazorPagesMovie/obj/project.assets.json
log  : Restore completed in 2.01 sec for /home/teddy/Documents/dotnet/RazorPagesMovie/RazorPagesMovie.csproj.

100

101

102

103

104

105

106

107

108

109

110

111

112

113

114

115

116

117

118

119

120

121

122

123

124

125

126

127

128

129

130

131

132

133

134

135

136

137

138

139

140

141

142

143

144

145

146

147

148

149

150

151

152

153

154

155

156

157

158

159

160

161

162

163

164

165

166

167

168

169

170

171

172

173

174

175

176

177

178

179

180

181

182

183

184

185

186

187

188

189

teddy@teddy:~/Documents/dotnet/RazorPagesMovie$ dotnet add package Microsoft.EntityFrameworkCore.SQLite

Writing /tmp/tmp6s15JK.tmp

info : Adding PackageReference for package 'Microsoft.EntityFrameworkCore.SQLite' into project '/home/teddy/Documents/dotnet/RazorPagesMovie/RazorPagesMovie.csproj'.

info : Restoring packages for /home/teddy/Documents/dotnet/RazorPagesMovie/RazorPagesMovie.csproj...

info : GET https://api.nuget.org/v3-flatcontainer/microsoft.entityframeworkcore.sqlite/index.json

info : OK https://api.nuget.org/v3-flatcontainer/microsoft.entityframeworkcore.sqlite/index.json 1010ms

info : GET https://api.nuget.org/v3-flatcontainer/microsoft.entityframeworkcore.sqlite/2.2.4/microsoft.entityframeworkcore.sqlite.2.2.4.nupkg

info : OK https://api.nuget.org/v3-flatcontainer/microsoft.entityframeworkcore.sqlite/2.2.4/microsoft.entityframeworkcore.sqlite.2.2.4.nupkg 34ms

info : GET https://api.nuget.org/v3-flatcontainer/microsoft.entityframeworkcore.sqlite.core/index.json

info : GET https://api.nuget.org/v3-flatcontainer/sqlitepclraw.bundle_green/index.json

info : OK https://api.nuget.org/v3-flatcontainer/microsoft.entityframeworkcore.sqlite.core/index.json 998ms

info : GET https://api.nuget.org/v3-flatcontainer/microsoft.entityframeworkcore.sqlite.core/2.2.4/microsoft.entityframeworkcore.sqlite.core.2.2.4.nupkg

info : OK https://api.nuget.org/v3-flatcontainer/microsoft.entityframeworkcore.sqlite.core/2.2.4/microsoft.entityframeworkcore.sqlite.core.2.2.4.nupkg 32ms

info : GET https://api.nuget.org/v3-flatcontainer/microsoft.entityframeworkcore.relational/index.json

info : GET https://api.nuget.org/v3-flatcontainer/microsoft.data.sqlite.core/index.json

info : OK https://api.nuget.org/v3-flatcontainer/sqlitepclraw.bundle_green/index.json 1136ms

info : GET https://api.nuget.org/v3-flatcontainer/sqlitepclraw.bundle_green/1.1.12/sqlitepclraw.bundle_green.1.1.12.nupkg

info : OK https://api.nuget.org/v3-flatcontainer/sqlitepclraw.bundle_green/1.1.12/sqlitepclraw.bundle_green.1.1.12.nupkg 33ms

info : GET https://api.nuget.org/v3-flatcontainer/sqlitepclraw.core/index.json

info : GET https://api.nuget.org/v3-flatcontainer/sqlitepclraw.provider.e_sqlite3.netstandard11/index.json

info : GET https://api.nuget.org/v3-flatcontainer/sqlitepclraw.lib.e_sqlite3.v110_xp/index.json

info : GET https://api.nuget.org/v3-flatcontainer/sqlitepclraw.lib.e_sqlite3.osx/index.json

info : GET https://api.nuget.org/v3-flatcontainer/sqlitepclraw.lib.e_sqlite3.linux/index.json

info : OK https://api.nuget.org/v3-flatcontainer/microsoft.entityframeworkcore.relational/index.json 1002ms

info : GET https://api.nuget.org/v3-flatcontainer/microsoft.entityframeworkcore.relational/2.2.4/microsoft.entityframeworkcore.relational.2.2.4.nupkg

info : OK https://api.nuget.org/v3-flatcontainer/microsoft.entityframeworkcore.relational/2.2.4/microsoft.entityframeworkcore.relational.2.2.4.nupkg 31ms

info : OK https://api.nuget.org/v3-flatcontainer/microsoft.data.sqlite.core/index.json 1100ms

info : GET https://api.nuget.org/v3-flatcontainer/microsoft.data.sqlite.core/2.2.4/microsoft.data.sqlite.core.2.2.4.nupkg

info : GET https://api.nuget.org/v3-flatcontainer/microsoft.entityframeworkcore/index.json

info : OK https://api.nuget.org/v3-flatcontainer/microsoft.data.sqlite.core/2.2.4/microsoft.data.sqlite.core.2.2.4.nupkg 33ms

info : OK https://api.nuget.org/v3-flatcontainer/sqlitepclraw.lib.e_sqlite3.v110_xp/index.json 1120ms

info : GET https://api.nuget.org/v3-flatcontainer/sqlitepclraw.lib.e_sqlite3.v110_xp/1.1.12/sqlitepclraw.lib.e_sqlite3.v110_xp.1.1.12.nupkg

info : OK https://api.nuget.org/v3-flatcontainer/sqlitepclraw.lib.e_sqlite3.linux/index.json 1122ms

info : GET https://api.nuget.org/v3-flatcontainer/sqlitepclraw.lib.e_sqlite3.linux/1.1.12/sqlitepclraw.lib.e_sqlite3.linux.1.1.12.nupkg

info : OK https://api.nuget.org/v3-flatcontainer/sqlitepclraw.lib.e_sqlite3.osx/index.json 1123ms

info : GET https://api.nuget.org/v3-flatcontainer/sqlitepclraw.lib.e_sqlite3.osx/1.1.12/sqlitepclraw.lib.e_sqlite3.osx.1.1.12.nupkg

info : OK https://api.nuget.org/v3-flatcontainer/sqlitepclraw.provider.e_sqlite3.netstandard11/index.json 1146ms

info : GET https://api.nuget.org/v3-flatcontainer/sqlitepclraw.provider.e_sqlite3.netstandard11/1.1.12/sqlitepclraw.provider.e_sqlite3.netstandard11.1.1.12.nupkg

info : OK https://api.nuget.org/v3-flatcontainer/sqlitepclraw.lib.e_sqlite3.v110_xp/1.1.12/sqlitepclraw.lib.e_sqlite3.v110_xp.1.1.12.nupkg 32ms

info : OK https://api.nuget.org/v3-flatcontainer/sqlitepclraw.lib.e_sqlite3.linux/1.1.12/sqlitepclraw.lib.e_sqlite3.linux.1.1.12.nupkg 33ms

info : OK https://api.nuget.org/v3-flatcontainer/sqlitepclraw.lib.e_sqlite3.osx/1.1.12/sqlitepclraw.lib.e_sqlite3.osx.1.1.12.nupkg 36ms

info : OK https://api.nuget.org/v3-flatcontainer/sqlitepclraw.provider.e_sqlite3.netstandard11/1.1.12/sqlitepclraw.provider.e_sqlite3.netstandard11.1.1.12.nupkg 31ms

info : OK https://api.nuget.org/v3-flatcontainer/sqlitepclraw.core/index.json 1476ms

info : GET https://api.nuget.org/v3-flatcontainer/sqlitepclraw.core/1.1.12/sqlitepclraw.core.1.1.12.nupkg

info : OK https://api.nuget.org/v3-flatcontainer/sqlitepclraw.core/1.1.12/sqlitepclraw.core.1.1.12.nupkg 139ms

info : OK https://api.nuget.org/v3-flatcontainer/microsoft.entityframeworkcore/index.json 1026ms

info : GET https://api.nuget.org/v3-flatcontainer/microsoft.entityframeworkcore/2.2.4/microsoft.entityframeworkcore.2.2.4.nupkg

info : OK https://api.nuget.org/v3-flatcontainer/microsoft.entityframeworkcore/2.2.4/microsoft.entityframeworkcore.2.2.4.nupkg 158ms

info : GET https://api.nuget.org/v3-flatcontainer/microsoft.entityframeworkcore.abstractions/index.json

info : GET https://api.nuget.org/v3-flatcontainer/microsoft.entityframeworkcore.analyzers/index.json

info : OK https://api.nuget.org/v3-flatcontainer/microsoft.entityframeworkcore.abstractions/index.json 997ms

info : GET https://api.nuget.org/v3-flatcontainer/microsoft.entityframeworkcore.abstractions/2.2.4/microsoft.entityframeworkcore.abstractions.2.2.4.nupkg

info : OK https://api.nuget.org/v3-flatcontainer/microsoft.entityframeworkcore.analyzers/index.json 1003ms

info : GET https://api.nuget.org/v3-flatcontainer/microsoft.entityframeworkcore.analyzers/2.2.4/microsoft.entityframeworkcore.analyzers.2.2.4.nupkg

info : OK https://api.nuget.org/v3-flatcontainer/microsoft.entityframeworkcore.abstractions/2.2.4/microsoft.entityframeworkcore.abstractions.2.2.4.nupkg 33ms

info : OK https://api.nuget.org/v3-flatcontainer/microsoft.entityframeworkcore.analyzers/2.2.4/microsoft.entityframeworkcore.analyzers.2.2.4.nupkg 33ms

info : Installing Microsoft.EntityFrameworkCore.Analyzers 2.2.4.

info : Installing Microsoft.EntityFrameworkCore.Abstractions 2.2.4.

info : Installing Microsoft.EntityFrameworkCore 2.2.4.

info : Installing SQLitePCLRaw.lib.e_sqlite3.linux 1.1.12.

info : Installing SQLitePCLRaw.lib.e_sqlite3.osx 1.1.12.

info : Installing SQLitePCLRaw.lib.e_sqlite3.v110_xp 1.1.12.

info : Installing SQLitePCLRaw.core 1.1.12.

info : Installing SQLitePCLRaw.provider.e_sqlite3.netstandard11 1.1.12.

info : Installing Microsoft.EntityFrameworkCore.Relational 2.2.4.

info : Installing Microsoft.Data.Sqlite.Core 2.2.4.

info : Installing SQLitePCLRaw.bundle_green 1.1.12.

info : Installing Microsoft.EntityFrameworkCore.Sqlite.Core 2.2.4.

info : Installing Microsoft.EntityFrameworkCore.Sqlite 2.2.4.

info : Package 'Microsoft.EntityFrameworkCore.SQLite' is compatible with all the specified frameworks in project '/home/teddy/Documents/dotnet/RazorPagesMovie/RazorPagesMovie.csproj'.

info : PackageReference for package 'Microsoft.EntityFrameworkCore.SQLite' version '2.2.4' added to file '/home/teddy/Documents/dotnet/RazorPagesMovie/RazorPagesMovie.csproj'.

info : Committing restore...

info : Writing assets file to disk. Path: /home/teddy/Documents/dotnet/RazorPagesMovie/obj/project.assets.json

log : Restore completed in 9.79 sec for /home/teddy/Documents/dotnet/RazorPagesMovie/RazorPagesMovie.csproj.

teddy@teddy:~/Documents/dotnet/RazorPagesMovie$ dotnet add package Microsoft.VisualStudio.Web.CodeGeneration.Design

Writing /tmp/tmpUPJJcI.tmp

info : Adding PackageReference for package 'Microsoft.VisualStudio.Web.CodeGeneration.Design' into project '/home/teddy/Documents/dotnet/RazorPagesMovie/RazorPagesMovie.csproj'.

info : Restoring packages for /home/teddy/Documents/dotnet/RazorPagesMovie/RazorPagesMovie.csproj...

info : GET https://api.nuget.org/v3-flatcontainer/microsoft.visualstudio.web.codegeneration.design/index.json

info : OK https://api.nuget.org/v3-flatcontainer/microsoft.visualstudio.web.codegeneration.design/index.json 1296ms

info : GET https://api.nuget.org/v3-flatcontainer/microsoft.visualstudio.web.codegeneration.design/2.2.3/microsoft.visualstudio.web.codegeneration.design.2.2.3.nupkg

info : OK https://api.nuget.org/v3-flatcontainer/microsoft.visualstudio.web.codegeneration.design/2.2.3/microsoft.visualstudio.web.codegeneration.design.2.2.3.nupkg 35ms

info : GET https://api.nuget.org/v3-flatcontainer/microsoft.visualstudio.web.codegenerators.mvc/index.json

info : OK https://api.nuget.org/v3-flatcontainer/microsoft.visualstudio.web.codegenerators.mvc/index.json 1004ms

info : GET https://api.nuget.org/v3-flatcontainer/microsoft.visualstudio.web.codegenerators.mvc/2.2.3/microsoft.visualstudio.web.codegenerators.mvc.2.2.3.nupkg

info : OK https://api.nuget.org/v3-flatcontainer/microsoft.visualstudio.web.codegenerators.mvc/2.2.3/microsoft.visualstudio.web.codegenerators.mvc.2.2.3.nupkg 34ms

info : GET https://api.nuget.org/v3-flatcontainer/microsoft.visualstudio.web.codegeneration/index.json

info : OK https://api.nuget.org/v3-flatcontainer/microsoft.visualstudio.web.codegeneration/index.json 1001ms

info : GET https://api.nuget.org/v3-flatcontainer/microsoft.visualstudio.web.codegeneration/2.2.3/microsoft.visualstudio.web.codegeneration.2.2.3.nupkg

info : OK https://api.nuget.org/v3-flatcontainer/microsoft.visualstudio.web.codegeneration/2.2.3/microsoft.visualstudio.web.codegeneration.2.2.3.nupkg 31ms

info : GET https://api.nuget.org/v3-flatcontainer/microsoft.visualstudio.web.codegeneration.entityframeworkcore/index.json

info : OK https://api.nuget.org/v3-flatcontainer/microsoft.visualstudio.web.codegeneration.entityframeworkcore/index.json 1001ms

info : GET https://api.nuget.org/v3-flatcontainer/microsoft.visualstudio.web.codegeneration.entityframeworkcore/2.2.3/microsoft.visualstudio.web.codegeneration.entityframeworkcore.2.2.3.nupkg

info : OK https://api.nuget.org/v3-flatcontainer/microsoft.visualstudio.web.codegeneration.entityframeworkcore/2.2.3/microsoft.visualstudio.web.codegeneration.entityframeworkcore.2.2.3.nupkg 32ms

info : GET https://api.nuget.org/v3-flatcontainer/microsoft.visualstudio.web.codegeneration.core/index.json

info : OK https://api.nuget.org/v3-flatcontainer/microsoft.visualstudio.web.codegeneration.core/index.json 1004ms

info : GET https://api.nuget.org/v3-flatcontainer/microsoft.visualstudio.web.codegeneration.core/2.2.3/microsoft.visualstudio.web.codegeneration.core.2.2.3.nupkg

info : OK https://api.nuget.org/v3-flatcontainer/microsoft.visualstudio.web.codegeneration.core/2.2.3/microsoft.visualstudio.web.codegeneration.core.2.2.3.nupkg 34ms

info : GET https://api.nuget.org/v3-flatcontainer/microsoft.visualstudio.web.codegeneration.templating/index.json

info : OK https://api.nuget.org/v3-flatcontainer/microsoft.visualstudio.web.codegeneration.templating/index.json 994ms

info : GET https://api.nuget.org/v3-flatcontainer/microsoft.visualstudio.web.codegeneration.templating/2.2.3/microsoft.visualstudio.web.codegeneration.templating.2.2.3.nupkg

info : OK https://api.nuget.org/v3-flatcontainer/microsoft.visualstudio.web.codegeneration.templating/2.2.3/microsoft.visualstudio.web.codegeneration.templating.2.2.3.nupkg 31ms

info : GET https://api.nuget.org/v3-flatcontainer/microsoft.visualstudio.web.codegeneration.utils/index.json

info : OK https://api.nuget.org/v3-flatcontainer/microsoft.visualstudio.web.codegeneration.utils/index.json 1002ms

info : GET https://api.nuget.org/v3-flatcontainer/microsoft.visualstudio.web.codegeneration.utils/2.2.3/microsoft.visualstudio.web.codegeneration.utils.2.2.3.nupkg

info : OK https://api.nuget.org/v3-flatcontainer/microsoft.visualstudio.web.codegeneration.utils/2.2.3/microsoft.visualstudio.web.codegeneration.utils.2.2.3.nupkg 31ms

info : GET https://api.nuget.org/v3-flatcontainer/microsoft.visualstudio.web.codegeneration.contracts/index.json

info : GET https://api.nuget.org/v3-flatcontainer/microsoft.codeanalysis.csharp.workspaces/index.json

info : GET https://api.nuget.org/v3-flatcontainer/nuget.frameworks/index.json

info : OK https://api.nuget.org/v3-flatcontainer/microsoft.visualstudio.web.codegeneration.contracts/index.json 1000ms

info : GET https://api.nuget.org/v3-flatcontainer/microsoft.visualstudio.web.codegeneration.contracts/2.2.3/microsoft.visualstudio.web.codegeneration.contracts.2.2.3.nupkg

info : OK https://api.nuget.org/v3-flatcontainer/microsoft.visualstudio.web.codegeneration.contracts/2.2.3/microsoft.visualstudio.web.codegeneration.contracts.2.2.3.nupkg 31ms

info : OK https://api.nuget.org/v3-flatcontainer/microsoft.codeanalysis.csharp.workspaces/index.json 1106ms

info : GET https://api.nuget.org/v3-flatcontainer/microsoft.codeanalysis.csharp.workspaces/2.8.0/microsoft.codeanalysis.csharp.workspaces.2.8.0.nupkg

info : OK https://api.nuget.org/v3-flatcontainer/nuget.frameworks/index.json 1132ms

info : GET https://api.nuget.org/v3-flatcontainer/nuget.frameworks/4.7.0/nuget.frameworks.4.7.0.nupkg

info : OK https://api.nuget.org/v3-flatcontainer/microsoft.codeanalysis.csharp.workspaces/2.8.0/microsoft.codeanalysis.csharp.workspaces.2.8.0.nupkg 35ms

info : OK https://api.nuget.org/v3-flatcontainer/nuget.frameworks/4.7.0/nuget.frameworks.4.7.0.nupkg 39ms

info : GET https://api.nuget.org/v3-flatcontainer/microsoft.codeanalysis.workspaces.common/index.json

info : OK https://api.nuget.org/v3-flatcontainer/microsoft.codeanalysis.workspaces.common/index.json 1029ms

info : GET https://api.nuget.org/v3-flatcontainer/microsoft.codeanalysis.workspaces.common/2.8.0/microsoft.codeanalysis.workspaces.common.2.8.0.nupkg

info : OK https://api.nuget.org/v3-flatcontainer/microsoft.codeanalysis.workspaces.common/2.8.0/microsoft.codeanalysis.workspaces.common.2.8.0.nupkg 32ms

info : GET https://api.nuget.org/v3-flatcontainer/system.composition/index.json

info : GET https://api.nuget.org/v3-flatcontainer/system.linq.parallel/index.json

info : OK https://api.nuget.org/v3-flatcontainer/system.composition/index.json 1004ms

info : GET https://api.nuget.org/v3-flatcontainer/system.composition/1.0.31/system.composition.1.0.31.nupkg

info : OK https://api.nuget.org/v3-flatcontainer/system.linq.parallel/index.json 1006ms

info : GET https://api.nuget.org/v3-flatcontainer/system.linq.parallel/4.3.0/system.linq.parallel.4.3.0.nupkg

info : OK https://api.nuget.org/v3-flatcontainer/system.composition/1.0.31/system.composition.1.0.31.nupkg 32ms

info : GET https://api.nuget.org/v3-flatcontainer/system.composition.attributedmodel/index.json

info : GET https://api.nuget.org/v3-flatcontainer/system.composition.convention/index.json

info : GET https://api.nuget.org/v3-flatcontainer/system.composition.hosting/index.json

info : GET https://api.nuget.org/v3-flatcontainer/system.composition.runtime/index.json

info : GET https://api.nuget.org/v3-flatcontainer/system.composition.typedparts/index.json

info : OK https://api.nuget.org/v3-flatcontainer/system.linq.parallel/4.3.0/system.linq.parallel.4.3.0.nupkg 39ms

info : OK https://api.nuget.org/v3-flatcontainer/system.composition.attributedmodel/index.json 997ms

info : GET https://api.nuget.org/v3-flatcontainer/system.composition.attributedmodel/1.0.31/system.composition.attributedmodel.1.0.31.nupkg

info : OK https://api.nuget.org/v3-flatcontainer/system.composition.convention/index.json 1042ms

info : GET https://api.nuget.org/v3-flatcontainer/system.composition.convention/1.0.31/system.composition.convention.1.0.31.nupkg

info : OK https://api.nuget.org/v3-flatcontainer/system.composition.attributedmodel/1.0.31/system.composition.attributedmodel.1.0.31.nupkg 76ms

info : OK https://api.nuget.org/v3-flatcontainer/system.composition.convention/1.0.31/system.composition.convention.1.0.31.nupkg 35ms

info : OK https://api.nuget.org/v3-flatcontainer/system.composition.typedparts/index.json 1109ms

info : GET https://api.nuget.org/v3-flatcontainer/system.composition.typedparts/1.0.31/system.composition.typedparts.1.0.31.nupkg

info : OK https://api.nuget.org/v3-flatcontainer/system.composition.runtime/index.json 1120ms

info : GET https://api.nuget.org/v3-flatcontainer/system.composition.runtime/1.0.31/system.composition.runtime.1.0.31.nupkg

info : OK https://api.nuget.org/v3-flatcontainer/system.composition.typedparts/1.0.31/system.composition.typedparts.1.0.31.nupkg 33ms

info : OK https://api.nuget.org/v3-flatcontainer/system.composition.hosting/index.json 1149ms

info : GET https://api.nuget.org/v3-flatcontainer/system.composition.hosting/1.0.31/system.composition.hosting.1.0.31.nupkg

info : OK https://api.nuget.org/v3-flatcontainer/system.composition.runtime/1.0.31/system.composition.runtime.1.0.31.nupkg 38ms

info : OK https://api.nuget.org/v3-flatcontainer/system.composition.hosting/1.0.31/system.composition.hosting.1.0.31.nupkg 39ms

info : Installing System.Composition.Hosting 1.0.31.

info : Installing System.Composition.Runtime 1.0.31.

info : Installing System.Composition.TypedParts 1.0.31.

info : Installing System.Composition.Convention 1.0.31.

info : Installing System.Composition.AttributedModel 1.0.31.

info : Installing System.Composition 1.0.31.

info : Installing System.Linq.Parallel 4.3.0.

info : Installing Microsoft.CodeAnalysis.Workspaces.Common 2.8.0.

info : Installing Microsoft.CodeAnalysis.CSharp.Workspaces 2.8.0.

info : Installing NuGet.Frameworks 4.7.0.

info : Installing Microsoft.VisualStudio.Web.CodeGeneration.Contracts 2.2.3.

info : Installing Microsoft.VisualStudio.Web.CodeGeneration.Utils 2.2.3.

info : Installing Microsoft.VisualStudio.Web.CodeGeneration.Templating 2.2.3.

info : Installing Microsoft.VisualStudio.Web.CodeGeneration.Core 2.2.3.

info : Installing Microsoft.VisualStudio.Web.CodeGeneration.EntityFrameworkCore 2.2.3.

info : Installing Microsoft.VisualStudio.Web.CodeGeneration 2.2.3.

info : Installing Microsoft.VisualStudio.Web.CodeGeneration.Design 2.2.3.

info : Installing Microsoft.VisualStudio.Web.CodeGenerators.Mvc 2.2.3.

info : Package 'Microsoft.VisualStudio.Web.CodeGeneration.Design' is compatible with all the specified frameworks in project '/home/teddy/Documents/dotnet/RazorPagesMovie/RazorPagesMovie.csproj'.

info : PackageReference for package 'Microsoft.VisualStudio.Web.CodeGeneration.Design' version '2.2.3' added to file '/home/teddy/Documents/dotnet/RazorPagesMovie/RazorPagesMovie.csproj'.

info : Committing restore...

info : Generating MSBuild file /home/teddy/Documents/dotnet/RazorPagesMovie/obj/RazorPagesMovie.csproj.nuget.g.props.

info : Writing assets file to disk. Path: /home/teddy/Documents/dotnet/RazorPagesMovie/obj/project.assets.json

log : Restore completed in 14.77 sec for /home/teddy/Documents/dotnet/RazorPagesMovie/RazorPagesMovie.csproj.

teddy@teddy:~/Documents/dotnet/RazorPagesMovie$ dotnet add package Microsoft.EntityFrameworkCore.Design

Writing /tmp/tmprEZck2.tmp

info : Adding PackageReference for package 'Microsoft.EntityFrameworkCore.Design' into project '/home/teddy/Documents/dotnet/RazorPagesMovie/RazorPagesMovie.csproj'.

info : Restoring packages for /home/teddy/Documents/dotnet/RazorPagesMovie/RazorPagesMovie.csproj...

info : GET https://api.nuget.org/v3-flatcontainer/microsoft.entityframeworkcore.design/index.json

info : OK https://api.nuget.org/v3-flatcontainer/microsoft.entityframeworkcore.design/index.json 1252ms

info : GET https://api.nuget.org/v3-flatcontainer/microsoft.entityframeworkcore.design/2.2.4/microsoft.entityframeworkcore.design.2.2.4.nupkg

info : OK https://api.nuget.org/v3-flatcontainer/microsoft.entityframeworkcore.design/2.2.4/microsoft.entityframeworkcore.design.2.2.4.nupkg 34ms

info : Installing Microsoft.EntityFrameworkCore.Design 2.2.4.

info : Package 'Microsoft.EntityFrameworkCore.Design' is compatible with all the specified frameworks in project '/home/teddy/Documents/dotnet/RazorPagesMovie/RazorPagesMovie.csproj'.

info : PackageReference for package 'Microsoft.EntityFrameworkCore.Design' version '2.2.4' added to file '/home/teddy/Documents/dotnet/RazorPagesMovie/RazorPagesMovie.csproj'.

info : Committing restore...

info : Generating MSBuild file /home/teddy/Documents/dotnet/RazorPagesMovie/obj/RazorPagesMovie.csproj.nuget.g.props.

info : Writing assets file to disk. Path: /home/teddy/Documents/dotnet/RazorPagesMovie/obj/project.assets.json

log : Restore completed in 2.01 sec for /home/teddy/Documents/dotnet/RazorPagesMovie/RazorPagesMovie.csproj.

The Microsoft.VisualStudio.Web.CodeGeneration.Design package is required for scaffolding.

...
using RazorPagesMovie.Models;
using Microsoft.EntityFrameworkCore;
...

...

using RazorPagesMovie.Models;

using Microsoft.EntityFrameworkCore;

...

...
namespace RazorPagesMovie
{
    public class Startup
    {
        ...

        // This method gets called by the runtime. Use this method to add services to the container.
        public void ConfigureServices(IServiceCollection services)
        {
            services.Configure<CookiePolicyOptions>(options =>
            {
                ...
            });

            services.AddDbContext<RazorPagesMovieContext>(options => 
            options.UseSqlite(Configuration.GetConnectionString("MovieContext")));
            services.AddMvc().SetCompatibilityVersion(CompatibilityVersion.Version_2_2);
        }

        ...
    }
}

...

namespace RazorPagesMovie

{

public class Startup

{

...

// This method gets called by the runtime. Use this method to add services to the container.

public void ConfigureServices(IServiceCollection services)

{

services.Configure<CookiePolicyOptions>(options =>

{

...

});

services.AddDbContext<RazorPagesMovieContext>(options =>

options.UseSqlite(Configuration.GetConnectionString("MovieContext")));

services.AddMvc().SetCompatibilityVersion(CompatibilityVersion.Version_2_2);

}

...

}

Build the project (‘dotnet build’) to verify there are no compilation errors.

teddy@teddy:~/Documents/dotnet/RazorPagesMovie$ dotnet build
Microsoft (R) Build Engine version 16.1.76+g14b0a930a7 for .NET Core
Copyright (C) Microsoft Corporation. All rights reserved.

  Restore completed in 563.27 ms for /home/teddy/Documents/dotnet/RazorPagesMovie/RazorPagesMovie.csproj.
  RazorPagesMovie -> /home/teddy/Documents/dotnet/RazorPagesMovie/bin/Debug/netcoreapp2.2/RazorPagesMovie.dll
  RazorPagesMovie -> /home/teddy/Documents/dotnet/RazorPagesMovie/bin/Debug/netcoreapp2.2/RazorPagesMovie.Views.dll

Build succeeded.
    0 Warning(s)
    0 Error(s)

Time Elapsed 00:00:04.39

teddy@teddy:~/Documents/dotnet/RazorPagesMovie$ dotnet build

Microsoft (R) Build Engine version 16.1.76+g14b0a930a7 for .NET Core

Restore completed in 563.27 ms for /home/teddy/Documents/dotnet/RazorPagesMovie/RazorPagesMovie.csproj.

RazorPagesMovie -> /home/teddy/Documents/dotnet/RazorPagesMovie/bin/Debug/netcoreapp2.2/RazorPagesMovie.dll

RazorPagesMovie -> /home/teddy/Documents/dotnet/RazorPagesMovie/bin/Debug/netcoreapp2.2/RazorPagesMovie.Views.dll

Build succeeded.

0 Warning(s)

0 Error(s)

Time Elapsed 00:00:04.39

Scaffold the movie model
In this section, the movie model is scaffolded. That is, the scaffolding tool produces pages for Create, Read, Update, and Delete (CRUD) operations for the movie model.
Install the scaffolding tool:

teddy@teddy:~/Documents/dotnet/RazorPagesMovie$ dotnet tool install --global dotnet-aspnet-codegenerator
You can invoke the tool using the following command: dotnet-aspnet-codegenerator
Tool 'dotnet-aspnet-codegenerator' (version '2.2.3') was successfully installed.

teddy@teddy:~/Documents/dotnet/RazorPagesMovie$ dotnet tool install --global dotnet-aspnet-codegenerator

You can invoke the tool using the following command: dotnet-aspnet-codegenerator

Tool 'dotnet-aspnet-codegenerator' (version '2.2.3') was successfully installed.

Run the scaffolding tool to create CRUD for model ‘Movie’:

teddy@teddy:~/Documents/dotnet/RazorPagesMovie$ dotnet aspnet-codegenerator razorpage -m Movie -dc RazorPagesMovieContext -udl -outDir Pages/Movies --referenceScriptLibraries
Building project ...
Finding the generator 'razorpage'...
Running the generator 'razorpage'...
Attempting to compile the application in memory.
Attempting to figure out the EntityFramework metadata for the model and DbContext: 'Movie'
info: Microsoft.EntityFrameworkCore.Infrastructure[10403]
      Entity Framework Core 2.2.4-servicing-10062 initialized 'RazorPagesMovieContext' using provider 'Microsoft.EntityFrameworkCore.Sqlite' with options: None
Added Razor Page : /Pages/Movies/Create.cshtml
Added PageModel : /Pages/Movies/Create.cshtml.cs
Added Razor Page : /Pages/Movies/Edit.cshtml
Added PageModel : /Pages/Movies/Edit.cshtml.cs
Added Razor Page : /Pages/Movies/Details.cshtml
Added PageModel : /Pages/Movies/Details.cshtml.cs
Added Razor Page : /Pages/Movies/Delete.cshtml
Added PageModel : /Pages/Movies/Delete.cshtml.cs
Added Razor Page : /Pages/Movies/Index.cshtml
Added PageModel : /Pages/Movies/Index.cshtml.cs
RunTime 00:00:06.54

teddy@teddy:~/Documents/dotnet/RazorPagesMovie$ dotnet aspnet-codegenerator razorpage -m Movie -dc RazorPagesMovieContext -udl -outDir Pages/Movies --referenceScriptLibraries

Building project ...

Finding the generator 'razorpage'...

Running the generator 'razorpage'...

Attempting to compile the application in memory.

Attempting to figure out the EntityFramework metadata for the model and DbContext: 'Movie'

info: Microsoft.EntityFrameworkCore.Infrastructure[10403]

Entity Framework Core 2.2.4-servicing-10062 initialized 'RazorPagesMovieContext' using provider 'Microsoft.EntityFrameworkCore.Sqlite' with options: None

Added Razor Page : /Pages/Movies/Create.cshtml

Added PageModel : /Pages/Movies/Create.cshtml.cs

Added Razor Page : /Pages/Movies/Edit.cshtml

Added PageModel : /Pages/Movies/Edit.cshtml.cs

Added Razor Page : /Pages/Movies/Details.cshtml

Added PageModel : /Pages/Movies/Details.cshtml.cs

Added Razor Page : /Pages/Movies/Delete.cshtml

Added PageModel : /Pages/Movies/Delete.cshtml.cs

Added Razor Page : /Pages/Movies/Index.cshtml

Added PageModel : /Pages/Movies/Index.cshtml.cs

RunTime 00:00:06.54

The scaffold process creates and updates the following files:

Files created
Pages/Movies: Create, Delete, Details, Edit, and Index.
Data/RazorPagesMovieContext.cs
File updated
Startup.cs
The created and updated files are explained in the next section.