I have three tables: A, B, AtoB. A and B relate as may-to-many via the AtoB:

Suppose we have a Book which contains two accounts:

This query works until filter.Exported and filter.Ordered are null but when they are true or false, it returns unexpected items and I don’t know why

I have a program that has a number of objects (say 200).
In addition, I have an entity framework which declares a dbset for each of these.
The objects are similar (but not all identical). I feel like a factory pattern would be worthwhile here to build the objects as well as the Dbcontext dynamically.

I have a query that I’m running in EF Core hooked up to a SQLite DB. I noticed it was running a bit slower than I expected so I turned on the logs to output the query. In the logs, it says:

I have created a SQL script file with a bunch of insert’s into a table if the values do not already exist.

I have created an SQL script file with a bunch of insert’s into a table if the values do not already exist.

I recently upgraded from EF7 to EF8, and because I do scaffolding models from DB (DB first approach), now I have DateOnly data types instead of DateTime for the Date column.

How can I create a new record, whilst also storing its related entities without creating a new record for the related entities (THEY ALREADY EXIST).

I’m trying to disable tracking for related children entities. I have a model like below (simplified):