Ordering query using lambda expression and Include method

One of the slower parts of database queries is the transport of your selected data from the DBMS to your local process. Hence it is wise to limit the amount of transferred data.

Apparently your FieldSetGroup has zero or more FieldSets. Each FieldSet belongs to exactly one FieldsetGroup. This is identified by the foreign key FieldSetGroupId. The value of this field equals the Id of the FieldSetGroup.

So if you have FieldSetGroupwith Id = 10, and this FieldSetGroup has, 1000 FieldSets, then every FieldSet will have a value of foreign key FieldSetGroupId of 10. No need to transfer this value 1000 times.

Advice: To limit the amount of transferred data, avoid transferring more data than needed, use Select instead of Include and select only the data you actually plan to use. Use Include if you plan to update the fetched data.

If you use Select, you can order whatever you want:

var result = dbContext.FieldsetGroup
   .Where((fieldSetGroup => fieldSetGroup.FieldsetGroupId == fieldSetGroupId)
   .Select(fieldSetGroup => new
   {
       ... // select the fieldSetGroup properties you plan to use

       FieldSets = fieldSetGroup.FieldSets
           .OrderBy(fieldSet => fieldSet.Order)
           .Select(fieldSet => new
           {
                ... // only select the fieldSet properties you plan to use

                FieldSetFields = fieldSet.FieldSetFields
                    .OrderBy(fieldSetField => fieldSetField.Order)
                    .Select(fieldSetField => new
                    {
                        ...
                    })
                    .ToList(),
                })
                .ToList(),
           })
           .ToList(),
    })
    .FirstOrDefault();