Click Here to View Step by Step Core 8 Web Application With SQL Server Database Connection

Watch the video

Visual Studio 2022 download


Create New ASP.NET Core Project


Create Asp.Net Core models


Create Asp.Net Core models


  public class Emplyee
     public int Id { get; set; }
     public string FirestName { get; set; }
     public string MiddleName { get; set; }
     public string LastName { get; set; }
     public string EmailAddress { get; set; }
     public int PhoneNo { get; set; }

Create Database and Table MS SQL Server


Install Nugets ASP.NET Core ( Entity Framework )


Create Application Db Context Class


    public class ApplicationDbContext : DbContext
        public ApplicationDbContext(DbContextOptions<ApplicationDbContext> contextOptions) : base(contextOptions)  { } 
        public DbSet<Emplyee> Emplyees { get; set; }

Configure SQL Database Connection on appsettings.json file


   "ConnectionStrings": {
                 "DefualtConnection": "Data Source=.;Initial Catalog=company;Integrated Security=True;Trust Server Certificate=True"

Register Database Connections on class


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

Add-Migrations ASP.NET Core


Update-Database (Apply Migrations) Asp.Net Core


Scaffolding in Asp.Net Core


CRUD Operation


Add Fontawsome in Asp.Net Core Application