ICollections | Javascript implementation for some common data | Natural Language Processing library

I have an Entity set of classes where there is a recipe; that recipe can have multiple Ingredients (handled with a foreign key), each ingredient can have a component. There are several sets of tables that follow a pattern similar to this, which several layers

When I add a single recipe, which contains some ingredients that ultimately lead to the same component, I get an error message saying that adding the recipe to the database causes a primary key violation on the components table. Is there a way to tell Entity that if a component has the same primary key value, it should be updated not inserted? I get that you can do this at the top level using context.Recipes.AddOrUpdate(recipe), but how could I achieve it for each of the sub levels down into the tree structure?

here are some summarised examples of the entity classes that I have in place:

Have been spending a significant amount of time googling and searching for a resolution to this but not getting any closer.

I have a series of objects:

• Assumptions
• Dependencies
• Issues
• Risks
• Tasks ... etc (there are c15 object types)

At present they are all defined as simple classes at present - i will create the specifics of each later on:

Lets say I would implement a Table Per Hierarchy for a class where I would store subclasses of this type distinguished by a discriminator (~ 5 types). Some subclasses will have their own ICollections and some wont, so this will not be specified in the superclass. Im currenly only able to fetch the data that is directly stored in the table but unable to fetch the collection of this subclass (length of collection will be 0) Any thoughts on how I would be able to fill in this list when I fetch this specific subclass (with specific discriminator) object from the database?

Here are my view models. The entities are exactly the same structure except the name has no ViewModel

Initializing the mapper

I have the following problem to resolve and would like some assistance in the best way forward.

I have attached an image showing the setup of 4 tables (EF has removed the linking tables for some many-to-many relationships).

A brief overview of what I am trying to obtain via a LINQ query: (I try to use method syntax). The system will allow users to submit a post under a category (depending on if they can access the category) for review before it's displayed. The categories have a top level parent theme hence the self-referenced table (but could expand many children in the future). Each post can belong to 1 or more categories, i.e a post can be about sports and IT (silly example, I know). Each category can have one or more approvers. The announcement_approver table will record & be a process-based table where one or more of the approvers will have to record whether the post has been edited, denied approval or approved by them. This will set a flag in the announcement_posts table (hence the one-to-many).

What I need to obtain is a list of all announcement_posts that have not been approved/pending (false in status), broken up by the Parent > Child relationship for a particular approver (the where clause will be based on the username field in the categories_approvers table). Hopefully I have explained properly here.

I have tried a method to start at the category table, use .include for the the virtual ICollections of category(self-reference), cat_approvers & announcements_posts. Then I have tried to join announcements_posts to announcements_approvers.

I have failed to get this working properly. I did think about working backwards from the posts table and include the cat table and announcements_approvers, but I think it would be a sticky situation to join Category to Category and then the approvers.

Sorry, if I have waffled on a bit here.

Db Schema Desired Output hierarchy

Many to Many Category to Posts

Edit:

Some code I am trying to start with but getting no joy. This does not include any where clauses so its essentially all categories with their children, posts, approvers, and approval_posts. I feel I am getting myself tied in knots and need a reset :)

I have an nested object array like this.

here is my array:

I have an array of angular material controls and their properties.

I have an array of the list of my database collection and it's fields.

Also I have a data table in a specific component of my angular project that it will be filled with collection array elements data.

here is some sample codes:

collection field interface:

I'm an EF noob (as in I just started today, I've only used other ORMs), and I'm experiencing a baptism of fire.

I've been asked to improve the performance of this query created by another dev: