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
{
[Key]
[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.

Roland

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?

Regards,

David

Comment
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

Comment
  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.
We use cookies which are necessary for the proper functioning of our websites. We also use cookies to analyze our traffic, improve your experience and provide social media features. If you continue to use this site, you consent to our use of cookies.