I have two classes and I am trying to get Table-per-concrete-type mapping strategy to work for my inheritance. My setup has these two classes:

I’m trying to recursively include the inner pages of this entity:

Can someone explain why EF is failing here?

Can someone explain why EF is failing here?

I need to filter the elements and their child elements to display on the list, the idea was to search on the parent or child elements that contains the text to search, so I first launch the query with Include().
Then manipulate the result with the Where function on the parent and child elements.
But the EntityFramework had some strange results, the 1st time all went well, but when I wanted to do another EntityFramework search returned the parent elements with 0 child elements

I have a TasksDbContext for my Tasks table where each task has a user identified by a UserId field, but the Users table is in a different database and is managed by a different team’s UsersDbContext. Is there a way to populate the task’s UserName property in my DbContext without stepping on the other team’s toes with regards to datamigrations etc.?

I have a JobOffer class which has a many-to-many relationship with the JobOfferTags class.

I’m using this code to update some records of a table which has around 600k records:

I’m using this code to update some records of a table which has around 600k records:

I would like to create algorithm for using only unique rows in some table, for avoiding repeating some rows. To do it, I’m enumerating existing table and looking for existing row, then create new or using reference for existing. But in case when database can be used with more then one user in the same time, both clients may have a different enumerated table (if one of them inserting some values already).