NET 5 error when adding migration on Entity Framework Core

Question

I'm setting up a new project with Entity Framework Core 5 and Postgres. All my project and my context are in the same project.

When adding a migration, I'm getting this error:

/src/Api.csproj : error MSB4057: The target "GetEFProjectMetadata" does not exist in the project. Unable to retrieve project metadata. Ensure it's an MSBuild-based .NET Core project. If you're using custom BaseIntermediateOutputPath or MSBuildProjectExtensionsPath values, Use the --msbuildprojectextensionspath option.

EF Core version: 5.0.1 Target framework: net5.0

These are all the commands I tried:

dotnet ef migrations add NewMigration

dotnet ef migrations add NewMigration --msbuildprojectextensionspath     

dotnet ef migrations add NewMigration -p ".\src\Api.csproj"

dotnet ef migrations add NewMigration -p ".\src\Api.csproj" --msbuildprojectextensionspath*

I have tried a lot of options I found on the internet, but none worked.

if i add -v , the last lines are:

Using project '/media/pablo/l/Projetos/Web/backend/boilerplate/dotnet_csharp/src/Api.csproj'.
Using startup project '/media/pablo/l/Projetos/Web/backend/boilerplate/dotnet_csharp/src/Api.csproj'.
Writing '/media/pablo/l/Projetos/Web/backend/boilerplate/dotnet_csharp/src/obj/Api.csproj.EntityFrameworkCore.targets'...
dotnet msbuild /target:GetEFProjectMetadata /property:EFProjectMetadataFile=/tmp/tmpbscOwZ.tmp /verbosity:quiet /nologo /media/pablo/l/Projetos/Web/backend/boilerplate/dotnet_csharp/src/Api.csproj
/media/pablo/l/Projetos/Web/backend/boilerplate/dotnet_csharp/src/Api.csproj : error MSB4057: O destino "GetEFProjectMetadata" não existe no projeto.
Microsoft.EntityFrameworkCore.Tools.CommandException: Unable to retrieve project metadata. Ensure it's an SDK-style project. If you're using a custom BaseIntermediateOutputPath or MSBuildProjectExtensionsPath values, Use the --msbuildprojectextensionspath option.
   at Microsoft.EntityFrameworkCore.Tools.Project.FromFile(String file, String buildExtensionsDir, String framework, String configuration, String runtime)
   at Microsoft.EntityFrameworkCore.Tools.RootCommand.Execute(String[] _)
   at Microsoft.EntityFrameworkCore.Tools.Commands.CommandBase.<>c__DisplayClass0_0.b__0(String[] args)
   at Microsoft.DotNet.Cli.CommandLine.CommandLineApplication.Execute(String[] args)
   at Microsoft.EntityFrameworkCore.Tools.Program.Main(String[] args)
Unable to retrieve project metadata. Ensure it's an SDK-style project. If you're using a custom BaseIntermediateOutputPath or MSBuildProjectExtensionsPath values, Use the --msbuildprojectextensionspath option.

Api.csproj:



  
    net5.0
    bin\Debug
et5.0\comments.xml
    true
    1591;1572;1573
    false
    ../roslynator.ruleset

Program.cs:

using Microsoft.AspNetCore;
using Microsoft.AspNetCore.Hosting;

namespace Linear.Service_Name.Api
{
  public static class Program
  {
    public static void Main(string[] args)
    {
      CreateWebHostBuilder(args).Build().Run();
    }

    public static IWebHostBuilder CreateWebHostBuilder(string[] args) =>
      WebHost.CreateDefaultBuilder(args).UseStartup();
  }
}

Startup.cs:

using Linear.Service_Name.DataBase.Entities;
using Microsoft.AspNetCore.Builder;
using Microsoft.AspNetCore.Hosting;
using Microsoft.EntityFrameworkCore;
using Microsoft.Extensions.Configuration;
using Microsoft.Extensions.DependencyInjection;
using System.Reflection;

[assembly: Microsoft.AspNetCore.Mvc.ApiController]
namespace Linear.Service_Name.Api
{
  public class Startup
  {
    private IWebHostEnvironment _environment { get; }

    public Startup(IConfiguration _, IWebHostEnvironment environment)
    {
      _environment = environment;
    }

    public void ConfigureServices(IServiceCollection services)
    {
      services.AddDbContext(opt => opt
        .UseNpgsql(EnvVariables.LINEAR_API_DOMAIN_NAME_DB_CONNECTION_STRING)
      );
      services.AddCommonsServices(new CommonServices
      {
        Env = _environment,
        ConnectionString = EnvVariables.LINEAR_API_DOMAIN_NAME_DB_CONNECTION_STRING,
        Assembly = Assembly.GetExecutingAssembly(),
        Swagger = new CommonServices.SwaggerSettings{
          Version = "v1",
          Title = "Service_Name",
          Description = "API REST do Módulo de " + ("Service_Name").ToUpper()
            + " da solução SG Web."
        }
      });
    }

    public void Configure(IApplicationBuilder app)
    {
      app.UserCommonsMiddlewares(new CommonMiddlewares
      {
        Env = _environment,
        PathBase = EnvVariables.LINEAR_API_SERVICE_NAME_BASE_PATH,
        Swagger = new CommonMiddlewares.SwaggerSettings
        {
          Version = "v1",
          Title = "Service_Name"
        }
      });
    }
  }
}

Context.cs:

using Linear.Infrastructure.Data.Audit;
using Linear.Infrastructure.Data.MultiTenancy;
using Microsoft.EntityFrameworkCore;

namespace Linear.Service_Name.DataBase.Entities
{
  public class Context : DbContext
  {
    public virtual DbSet Sample_Names { get; set; }
    private readonly IAuditEntity _auditEntity;
    private readonly IMultiTenancy _multiTenancy;
    public Context(DbContextOptions options, IAuditEntity auditEntity,
      IMultiTenancy multiTenancy)
      : base(options)
    {
      _auditEntity = auditEntity;
      _multiTenancy = multiTenancy;
    }
    #region Métodos Protegidos
    protected override void OnConfiguring(DbContextOptionsBuilder optionsBuilder)
    {
    }
    protected override void OnModelCreating(ModelBuilder modelBuilder)
      => modelBuilder.ApplyConfigurationsFromAssembly(typeof(Context).Assembly);

    #endregion
    #region Métodos Públicos
    public override int SaveChanges()
    {
      _multiTenancy.OnSaveChanges(this);
      _auditEntity.OnSaveChanges(this);
      return base.SaveChanges();
    }
    public int SaveChangesWithoutMultiTenancy()
    {
      _auditEntity.OnSaveChanges(this);
      return base.SaveChanges();
    }
    public int SaveChangesWithoutMultiTenancyAndAudit() => base.SaveChanges();
    #endregion
  }
}

Project link to download: https://drive.google.com/file/d/1YWlm_teyGMjJe193AwrFqe3VAeVVKWLq/view?usp=sharing

I've been stuck with this problem for over 3 hours, tried a lot of suggestions on internet and still no sucess, i appreciate if i have some help.

dglozano · Accepted Answer

After doing some research, it seems that there is a problem with projects with docker integration and the EF Core tooling.

I have downloaded your code and this is the content of your Directory.Build.props


  
    $(DefaultItemExcludes);$(MSBuildProjectDirectory)/obj/**/*
    $(DefaultItemExcludes);$(MSBuildProjectDirectory)/bin/**/*
  

  
    $(MSBuildProjectDirectory)/obj/container/
    $(MSBuildProjectDirectory)/bin/container/
  

  
    $(MSBuildProjectDirectory)/obj/local/
    $(MSBuildProjectDirectory)/bin/local/

According to @bricelam in this issue the root of the problem lies here:

Changing BaseIntermediateOutputPath from its default when not running inside a container breaks the EF Core tooling experience (*)

Since your BaseIntermediateOutputPath was changed from its default to obj/local when running outside the docker container, what you need to do is let the EF Core CLI know where to find that folder. You can accomplish that by using the --msbuildprojectextensionspath parameter. In your case, it would like like this (as suggested here):

dotnet ef migrations add NewMigration --msbuildprojectextensionspath obj/local

If you are still unable to make it work, you could follow the discussion in this other issue. In there, it was suggested that another possible fix is to change a bit your Directory.Build.props and *.csproj files so that the latter looks like the following:

 

  
     
    $(MSBuildProjectDirectory)\_intermediate_\

NET 5 error when adding migration on Entity Framework Core

Answers (1)

Related Questions