This project is a basic ASP.NET Core web application that demonstrates how to use Entity Framework Core with Code First approach to interact with a SQL Server database.

Before running the application, ensure you have the following installed:

• .NET 6 SDK
• SQL Server (or SQL Server Express) installed and running

1. Clone the repository to your local machine.
2. Open the solution in Visual Studio
3. Open the appsettings.json file and replace server-name and database-name in the DefaultConnection connection string with your actual server and database name

"ConnectionStrings": {
    "DefaultConnection": "Server=your-server-name;Database=your-database-name;Trusted_Connection=True;TrustServerCertificate=True"
}

• I am using asp .net core version 6 and adding necessary packages based on these version specific

 01. Microsoft.EntityFrameworkCore.Design - Version 6.0.27
 02. Microsoft.EntityFrameworkCore.Tools  - Version 6.0.27
 03. Microsoft.EntityFrameworkCore.SqlServer - Version 6.0.27

1. Create a new Folder name Data
2. Create a new class ApplicationDbContext.cs in that Data folder

using Microsoft.EntityFrameworkCore;

namespace WebApp.Data
{
    public class ApplicationDbContext : DbContext
    {
        public ApplicationDbContext(DbContextOptions<ApplicationDbContext> options)
            : base(options)
        {
        }

        // Add DbSet properties for your entities here
    }
}

1. Update the Program.cs to configure ApplicationDbContext

builder.Services.AddDbContext<ApplicationDbContext>(options =>
    options.UseSqlServer(builder.Configuration.GetConnectionString("DefaultConnection"))) ;

add-migration suitableMigrationName
update-database

If you need to seed data into the database, modify the ApplicationDbContext class and override the OnModelCreating method to define seeding logic using the ModelBuilder API. After making changes, run the migration and database update commands again.

• Ensure you have the necessary permissions to create databases on the target server.
• Consider handling database migrations carefully in production environments to avoid data loss or downtime.

This README file provides a step-by-step guide for setting up and using Entity Framework Core in your ASP.NET Core project, along with additional notes and considerations. Feel free to customize it further based on your project's specific requirements. Thanks