Articles → ASP.NET CORE → Create A Database And Table From A Code-First Approach In ASP.NET Core

Create A Database And Table From A Code-First Approach In ASP.NET Core

This article describes creating a database and table from a code-first approach in ASP.NET Core.

Package Installation

To begin with, install the following packages: -

Microsoft.EntityFrameworkCore
Microsoft.EntityFrameworkCore.SqlServer
Microsoft.EntityFrameworkCore.Tools
Microsoft.AspNetCore.Mvc.Razor.RuntimeCompilation

Add Connection String In Appsettings.Json

The second step is to add the connection string in "appsettings.json".

Picture showing the connection string in the appsettings.json file

Click to Enlarge

Add Model Class

In this article, we will create a table called "Book" that contains the following fields: "Id," "Name," and "Author." To achieve this, we will create a code file named "Book.cs."

Add the following code to the Book.cs file.

using System.ComponentModel.DataAnnotations;

namespace BookManagementSystem.Model {
  public class Book {
    [Key]
    public int Id {
      get;
      set;
    }

    [Required]
    public string Name {
      get;
      set;
    }

    public string Author {
      get;
      set;
    }
  } 
}

Create A DbContext Class

Create a new class file named ApplicationDbContext.cs, and add the following code inside it.

using Microsoft.EntityFrameworkCore;

namespace BookManagementSystem.Model {
  public class ApplicationDbContext: DbContext {
    public ApplicationDbContext(DbContextOptions < ApplicationDbContext > options): base(options) {

    }

    public DbSet < Book > Book {
      get;
      set;
    }
  }
}

Add ApplicationDbContext In Startup.cs

In the startup.cs file, we will carry out the following actions: -

Import Microsoft.EntityFrameworkCore.
Add the following code inside the ConfigureServices method.

services.AddDbContext<ApplicationDbContext>(option => option.UseSqlServer(Configuration.GetConnectionString("DefaultConnection")));

Run Migration Command

The final step is to execute the migration commands. These commands will establish the database and tables. For that purpose, we will perform these steps: -

Navigate to Tools → NuGet Package Manager → Package Manager Console.
Write the following command.

add-migration AddBookToDb

Here, "AddBookToDb" is the custom name. You can give any name.

Then execute the following command

update-database

Once the commands are executed, the database and tables are created.

Picture showing the table created from the code first approach in asp.net core

Click to Enlarge

If you are getting an error - "The term 'add-migration' is not recognized as the name of a cmdlet in .net core" , you can follow this link to solve it.

Posted By -	Karan Gupta

Posted On -	Wednesday, March 31, 2021

Updated On -	Wednesday, January 26, 2022

Query/Feedback

Your Email Id		**

Subject		*

Query/Feedback	Characters remaining 250	**