FetchMode property sometimes was a magic solution for report development in Axapta 3.0. Since then I wanted to run several tests and describe the feature.Problem description
Analyse how a query is translated into SQL Server query based on
FetchMode property.Solution
Based on the description in msdn
FetchMode property is available on an embedded datasource and determines a relation between parent and child datasources.FetchMode values are 1:1 and 1:n, but there is no description of them.The property name and values can lead to an assumption:
1:1 - data for parent and child datasources is fetched simultaneously
1:n - data for parent and child datasources is fetched separately.
Running ahead I must say that the assumption is not precisely correct, but let's analyse it. You can also jump to the conclusion section.
