Unable to perform migration in .NET Core 6.0 solution with PostgreSQL

Question

I have cloned a .NET Core 6.0 solution from Git and made changes to my dbcontext inherited class. The change involves adding a condition to check if a table already exists in the database, and if not, to create it or skip the creation. I have added the necessary code for this condition. Now, I want to push these changes to my cluster. However, before that, I need to apply the migration to reflect the changes in the database. My database is PostgreSQL, and I am using .NET Core 6.0.

When I try to perform the migration using the command dotnet ef migrations add updateDbcontext, I encounter the following error:

"Your startup project MywebApp doesn't reference Microsoft.EntityFrameworkCore.Design. This package is required for the Entity Framework Core Tools to work. Ensure your startup project is correct, install the package, and try again."

I have already installed all the necessary packages through NuGet, but I am still unable to migrate. Could someone please assist me in resolving this issue?

 

below is my .csproj file

<Project Sdk="Microsoft.NET.Sdk.Web">

    <PropertyGroup>
        <TargetFramework>net6.0</TargetFramework>
        <UserSecretsId>aspnet-myWebApp-007</UserSecretsId>
        <DockerDefaultTargetOS>Linux</DockerDefaultTargetOS>
    </PropertyGroup>

    <ItemGroup>
        <PackageReference Include="AspNetCoreRateLimit" Version="4.0.2" />
        <PackageReference Include="AspNetCoreRateLimit.Redis" Version="1.0.1" />
        <PackageReference Include="AWSSDK.Extensions.NETCore.Setup" Version="3.7.2" />
        <PackageReference Include="IdentityModel.AspNetCore.OAuth2Introspection" Version="6.1.0" />
        <PackageReference Include="Microsoft.AspNetCore.Authentication.JwtBearer" Version="6.0.6" />
        <PackageReference Include="Microsoft.AspNetCore.Authentication.OpenIdConnect" Version="6.0.6" />
        <PackageReference Include="Microsoft.Identity.Web" Version="1.25.1" />
        <PackageReference Include="Minio" Version="4.0.3" />
        <PackageReference Include="Newtonsoft.Json" Version="13.0.1" />
        <PackageReference Include="Npgsql.EntityFrameworkCore.PostgreSQL" Version="6.0.5" />
        <PackageReference Include="Serilog" Version="2.11.0-dev-01380" />
        <PackageReference Include="Serilog.AspNetCore" Version="6.0.0-dev-00265" />
        <PackageReference Include="Serilog.Sinks.Console" Version="4.0.2-dev-00890" />
        <PackageReference Include="Serilog.Sinks.Fluentd" Version="0.4.0" />
        <PackageReference Include="Swashbuckle.AspNetCore" Version="6.3.1" />
        <PackageReference Include="Microsoft.NETCore.App" Version="2.2.8" />
    </ItemGroup>



</Project>