How to exclude one table from automatic code first migrations in the Entity Framework?

by

This is now possible in EF Core 5.0 using the ExcludeFromMigrations() method, but strangely enough you have to call the ToTable() method and then use the TableBuilder.

https://devblogs.microsoft.com/dotnet/announcing-entity-framework-core-efcore-5-0-rc1/#exclude-tables-from-migrations

public class ReportingContext : DbContext
{
    public DbSet<User> Users { get; set; }

    protected override void OnModelCreating(ModelBuilder modelBuilder)
    {
        modelBuilder.Entity<User>().ToTable(nameof(Users), t => t.ExcludeFromMigrations());
    }
}

More Related Contents:

  1. ASP.NET MVC 2.0 Implementation of searching in jqgrid
  2. Code First: Independent associations vs. Foreign key associations?
  3. What’s the difference(s) between .ToList(), .AsEnumerable(), AsQueryable()?
  4. Unique Key constraints for multiple columns in Entity Framework
  5. Entity Framework 6 Code first Default value
  6. Database first create entity framework 6.1.1 model using system.data.sqlite 1.0.93
  7. EF Code First “Invalid column name ‘Discriminator'” but no inheritance
  8. Improve navigation property names when reverse engineering a database
  9. Create a Dropdown List for MVC3 using Entity Framework (.edmx Model) & Razor Views && Insert A Database Record to Multiple Tables
  10. Can I specify global mapping rules in Entity Framework Code First?
  11. The specified named connection is either not found in the configuration, not intended to be used with the EntityClient provider, or not valid
  12. Entity Framework loading child collection with sort order
  13. “like” queries in Entity Framework
  14. Equivalent for .HasOptional in Entity Framework Core 1 (EF7)
  15. Ramifications of DbSet.Create versus new Entity()
  16. How to pass parameters to the DbContext.Database.ExecuteSqlCommand method?
  17. Entity Framework : How do you refresh the model when the db changes?
  18. Entity framework code first creates “discriminator” column
  19. EF Migrations: Rollback last applied migration?
  20. Keyword not supported: “data source” initializing Entity Framework Context
  21. Entity Framework Data Annotations Set StringLength VarChar
  22. EF 4.1 loading filtered child collections not working for many-to-many
  23. How to map Table per Type (TPT) inheritance in Entity designer?
  24. Entity Framework 4.0: Error 113: Multiplicity is not valid in Role
  25. Paging in Entity Framework
  26. Using SimpleMembership with EF model-first
  27. Entity Framework: Inheritance and Include
  28. Entity Framework – Get List of Tables
  29. EF Core 2: How to apply HasQueryFilter for all entities
  30. Entity framework code first delete with cascade

Leave a Comment