Storing tree structures where a node can be in multiple trees
I am trying to find a way to build a model in Entity Framework to represent LearningJourneys, Courses and Lessons, where each course can have multiple Courses and lessons within it. However i also want to make it so lessons and courses can be used in multiple LearningJourneys.
Using Microsoft scaffolded controller, when I try to POST to a child record I get parent field required
I have a foreign key relationship in my database between two tables, one-to-many, which I used scaffold to create the DBContext:
Efficently Updating Large Datasets in EF Core
I am looking to improve on the updating performance of data sets and seeking insights.
I have a set of 2000 rows of data in table TestResults, when new datset is made available all of the 2000 rows of data have to be updated with their respective values, in this case ratingDate and rating.
Choosing the Best Approach for Computed Columns
This code works as expected: the ExhibitionName property brings the concatenation of the fields according to their values.