[ROOT] / doc / toc / ARCQuery / Class / EntityMethodKey / TryGetForeignField

Returns foreign field through foreign key given.

Helper method not used directly by EntityMethodKey but useful for actually implementation methods in entity classes.

For instance, given 'CustomerP.GeographyId' it can look up values like 'GeographyId.City', 'GeographyId.Province', 'GeographyId.State', 'GeographyId.Country'.

This enables easier querying without having to denormalize the tables themselves, like when querying for 'Customer', to do
'SELECT Name, Address, City, State, Country'
instead of the more laborous
'SELECT Geography.Name, Geography.Address, Geography.City, Geography.State, Geography.Country'
(the latter approach would have utilized ForeignKey).

Generated 2024-04-18 14:13:07.668 UTC