1. Roland Mühlberger
  2. .NET DataStore
  3. Tuesday, 23 November 2021 14:40 PM UTC

Dear .NET DataStore users,

we have a Web API based on the .NET Datastore that - especially in one case - uses heavily structured objects derived from DataObjects with nested objects which then get added as Properties in the Model annotated as DwReport. Example:

public class ItemModel
[DwColumn("items", "art")]
public int itemId { get; set; }

[DwReport(typeof(ItemClientModel), ParamValues = "itemId")]
public IList<ItemClientModel> clients { get; set; }


We use GetModel(<TModel>, true) on each and every base object ("row") to force retrieval of the nesteds objects. This leads to sub-elements (in this case the IList clients) to be retrieved and filled.

My question:

Is it possible to force Async retrieval for retrieving nested data?

Is there a better way to do this than described above?

We have thought about reading nesteds not for every row but for all rows in a single go and distributing data to the ILists programmatically. We then would only have one SELECT issued for one nested and not n (for n being the number of main rows in the result).

Any help appreciated.


Accepted Answer
David Xiong @Appeon Accepted Answer Pending Moderation
  1. Friday, 26 November 2021 09:14 AM UTC
  2. .NET DataStore
  3. # Permalink

Hi Roland,

Currently does not support asynchronous retrieval of nested data. You can submit an enhancement request through our support ticketing system (https://www.appeon.com/standardsupport/newbug).

In addition, can you describe the scenario in which the data you get through Web API will be used? For example, do you import the data you get into a PowerBuilder application?



There are no comments made yet.
Roland Mühlberger Accepted Answer Pending Moderation
  1. Friday, 26 November 2021 09:30 AM UTC
  2. .NET DataStore
  3. # 1

Thanks for the reply, David. 

The "consumers" of the API are not PowerBuilder clients, but customers of customers that need to get structured information from customer-installed applications via a defined API.

Regards, Roland

  1. Armeen Mazda @Appeon
  2. Friday, 26 November 2021 16:53 PM UTC
Hi Roland, Can you open a support ticket as David suggested with this information so we don't lose track of this request?
  1. Helpful
  1. Roland Mühlberger
  2. Monday, 29 November 2021 12:50 PM UTC
Done. Thanks, Armeen.
  1. Helpful
  1. Armeen Mazda @Appeon
  2. Monday, 29 November 2021 16:59 PM UTC
Thanks Roland.
  1. Helpful
There are no comments made yet.
  • Page :
  • 1

There are no replies made for this question yet.
However, you are not allowed to reply to this question.