“Build failed” on Database First Scaffold-DbContext

by

Two most important tips:

[1] – Make sure that your project builds completely before you run a new scaffold command.

Otherwise…

  • You’ll start writing a line of code.
  • You’ll realize a required DB column is missing from your model.
  • You’ll go to try to scaffold it.
  • Twenty minutes later you’ll realize the reason your build (and scaffold command) is failing is because you literally have a half written line of code. Oops!

[2] – Check into source control or make a copy:

  • Allows you to easily verify what changed.
  • Allows rollback if needed.

You can get some very annoying ‘chicken and egg’ problems if you get unlucky or make a mistake.

Other problems:

If you have multiple DLLs make sure you aren’t generating into the wrong project. A ‘Build failed’ message can occur for many reasons, but the dumbest would be if you don’t have EFCore installed in the project you’re scaffolding into.

In the package manager console there is a Default project dropdown and that’s probably where your new files ended up if you’re missing an expected change.

A better solution than remembering to set a dropdown is to add the -Project switch to your scaffolding command.

This is the full command I use:

For EF Core 2

Scaffold-DbContext -Connection
“Server=(local);Database=DefenderRRCart;Integrated
Security=True;Trusted_Connection=True;” -Provider
Microsoft.EntityFrameworkCore.SqlServer -OutputDir RRStoreContext.Models
-context RRStoreContext -Project RR.DataAccess -force

For EF Core 3

dotnet ef dbcontext scaffold
“Server=tcp:XXXXX.database.windows.net,1433;Initial
Catalog=DATABASE_NAME;Persist Security Info=False;User
ID=USERNAME;Password=PASSWORD;MultipleActiveResultSets=False;Encrypt=True;TrustServerCertificate=False;Connection
Timeout=30;” Microsoft.EntityFrameworkCore.SqlServer -o DB.Models
–context-dir DB.Contexts –context RRDBContext –project RR.EF.csproj –force –use-database-names

Note: -force will overwrite files but not remove ones that don’t exist any more. If you delete tables from your DB you must delete the old entity files yourself (just sort in Explorer by date and delete the old ones).

Full Scaffolding reference:

EF Core 2:

https://docs.efproject.net/en/latest/miscellaneous/cli/powershell.html#scaffold-dbcontext (this

EF Core 3:

https://learn.microsoft.com/en-us/ef/core/miscellaneous/cli/dotnet

More Related Contents:

  1. Dynamically change connection string in Asp.Net Core
  2. Many-to-many self referencing relationship
  3. navigation property should be virtual – not required in ef core?
  4. How to instantiate a DbContext in EF Core
  5. auto create database in Entity Framework Core
  6. Filter all queries (trying to achieve soft delete)
  7. The entity type ‘Microsoft.AspNet.Identity.EntityFramework.IdentityUserLogin’ requires a key to be defined
  8. How to add the same column to all entities in EF Core?
  9. Unable to create migrations after upgrading to ASP.NET Core 2.0
  10. Dynamically changing schema in Entity Framework Core
  11. How to store JSON in an entity field with EF Core?
  12. EF CORE 2.1 HasConversion on all properties of type datetime
  13. How can I call a SQL Stored Procedure using EntityFramework 7 and Asp.Net 5
  14. Include with FromSqlRaw and stored procedure in EF Core 3.1
  15. Azure Function, EF Core, Can’t load ComponentModel.Annotations 4.2.0.0
  16. Could not load file or assembly Microsoft.Extensions.DependencyInjection.Abstractions, Version=1.1.0.0
  17. Entity framework EF.Functions.Like vs string.Contains
  18. The LINQ expression could not be translated and will be evaluated locally
  19. Avoid or control circular references in Entity Framework Core
  20. Unable to edit db entries using EFCore, EntityState.Modified: “Database operation expected to affect 1 row(s) but actually affected 0 row(s).”
  21. Add migration with different assembly
  22. ef core doesn’t use ASPNETCORE_ENVIRONMENT during update-database
  23. How to load navigation properties on an IdentityUser with UserManager
  24. How to get user information in DbContext using Net Core
  25. How to create a password protected database?
  26. Implementing recursive property loading in EF Core
  27. How to set Identity Seed value in code-first?
  28. EF Core takes a lot of time, sometimes, to perform SELECT query
  29. How to resolve .net core build error NETDSDK1061 and warning MSB3277
  30. How to access DbContext in .NET 6 minimal API Program.cs

Leave a Comment