How to ignore ThenInclude's related data?

Many-to-Many Relationships in EF7 - Select query for a list including related data

The error message says it all. SqlException: Invalid column name 'Id'...Your database is different than the models on your project. If you have database migration enabled then run the commands...dnx ef migrations add [migration name] dnx ef database update ...If you don't want to use database migration, you have to update the models on your databa...

Can not load related data with Include or ThenInclude or Select/Many with ONE query

1 Test has 1 TestType assigned....I need to load all TestType entities with relation to a Test OR not and Schoolclass , Subject and Assigned Pupils to a test (PupilsTests)...The .SelectMany or .Select fails here during runtime....I tried different combinations of Include and ThenInclude but no chance to get the Tests WITH the PupilsTests....I can o...

Loading multiple levels of related data in Entity Framework Core not working as expected

Try ....Include(x => x.ArticleTags.Tag?.Value)

Data Annotations being ignored in .Net Core/EF Core Model (MySQL Backend)

I have created a Web API using .Net Core 1.1 and EF Core. The backend is a MySQL Database, so I have included the ..."MySql.Data.EntityFrameworkCore": "7.0.6-IR31"... dependency in the project.json file....I have a simple model in my project. I am trying to map the columns in my model to the columns in an existing database. So I am using Data Annot...

Doesn't retrieve the related table data in Entity Framework Core with PostgreSQL

You have to add "Include()" in your query. Unless doing that, it returns null relations.

Ignore table columns in EF Core

You have two alternatives:...Using ...NotMappedAttribute... :...public class MyEntity { public int Id { get; set; } [NotMapped] public string DeprecatedFeature { get; set; } } ...Using FluentAPI:...modelBuilder.Entity<MyEntity>().Ignore(c => c.DeprecatedFeature );

Entity Framework Core Explicitly loading related data according to Type of Class

I have Repository class with includes. the code below works for one to one relationships. However for Collections I need to change ...DbContext.Entry(model.Result).Reference(include).Load();... to ...DbContext.Entry(model.Result).Collection(include).Load();... public virtual async Task<TEntity> GetByIdAsync(object[] keyValues, List<Expre...

EntityFrameworkCore 2.1.0 loads all related data by default without using Include

I don't know why, but now I see that the problem was that my DbContext was registered as singleton....Thanks to @IvanStoev

Entity framework 2.1 , 2.2 : Loading related data returns Null or Incomplete

Apparently this happens because of self-reference loops in JSON so we can set this off by code below and it resolve the issue:...public void ConfigureServices(IServiceCollection services) { services.AddDbContext<ApiContext>(options => options.UseSqlServer(Configuration.GetConnectionString("DefaultConnection")) .UseLazyLoadingProxies()); servi...

Best Practice For Loading Related Data in Asp.net Core Web API And EF.Core

Well in most cases eager loading would be fine because in one round trip to database you fetch necessary data but consider following examples:...1- If you are going to show order list of specific customer and by click on each order, order lines should be listed, in this case lazy loading or explicit loading is better. you are not going to fetch all...