NET code displays this data on a form, as shown below: Relations.Add(_categories,RelationType.Find, Internal readonly Model.Categories _categories = new Model.Categories() Internal readonly Model.Products _products = new Model.Products()
To start with, we'll create a simple UIController, which will display a list of products and it's Categories.
To read more about these topics, and get code samples please see: RelationType Documentation Find Relation This article doesn't address Insert relation type and InsertIfNotFound relation types.
We will also discuss optimizing the SQL code for Relations, by using Cache.
We'll look at the difference between Find (Find, Insert if not found) and Join (Left Outer Join, Inner Join) as well as the different SQL code that each one generates. In this article we are going to review different types of Relations in your migrated code and their interaction with the database.
