efcore select all rows from one table into another table code example
Example: Select records that does not exist in another table in Entity Framework
db.Customers
.Where(c => !db.Blacklists
.Select(b => b.CusId)
.Contains(c.CusId)
);