Expand definition with GetManager.Find< >

[Ecologic_dsi (Sylvain)]

Hi

Is there a way to expand a specific proxyList using GetManager.Find< > ?
Currently I'm using

TXDataOperationContext.Current.GetManager.ProxyListLoadDepth := 1; // or 2 or more
TXDataOperationContext.Current.GetManager.Find<TObject>(id_object)

But in this case it expands all sub objects by proxyList

1. it can be heavy and long for not useful data
2. it can expose data without control

Thanks for you help
Sylvain

[wlandgraf (Wagner Landgraf)]

You can use CreateAlias('MyAssociation', 'a', 'TFetchMode.Eager):

https://doc.tmssoftware.com/biz/aurelius/guide/queries.html#specifying-eager-fetching-for-associations-loaded-as-lazy-by-default

[Ecologic_dsi (Sylvain)]

Thanks Wagner

Indeed, it seems to be the right way but unfortunately, I get difficulties to find the right syntax with FetchEager behind a Find<> with Id.

TXDataOperationContext.Current.GetManager.Find<TObject>(id_object).FetchEager('subobject'));

is wrong.
Same with CreateAlias.

What's the right syntax to use in this case?

Thanks

[Ecologic_dsi (Sylvain)]

I found a working syntax but not sure it's the bes

TXDataOperationContext.Current.GetManager.Find<TObject>.CreateAlias('SubObjectList', 'sobj', TFetchMode.Eager).Where(Linq['id_object'] = id_object).UniqueResult);

[wlandgraf (Wagner Landgraf)]

@Ecologic_dsi

I found a working syntax but not sure it's the bes

That is correct.
Note that since you are loading a single object, you could just force the proxy load this way as well:

Object := TXDataOperationContext.Current.GetManager.Find<TObject>(id_object);
Object.SubObject;  //forces loading of SubObject