Retrieving DataTable or DataReader from Visual Studio to Outsystems

Retrieving DataTable or DataReader from Visual Studio to Outsystems

  
I would like to know what is the best way to get a Record List from a DataTable or DataReader (Visual Studio)

So far, I have a web service made it in Visual Studio that returns a Generic List
in outsystem we get this Generic List as a Record List.
the problem is that the generic list is filled going throught all datatable/datareader rows

any idea to improve this performance?
Hi Miguel,

The best way to improve the performance would be to integrate directly with the external database using the external entities integration capabilities of the platform. That would also ease the implementation because you would be handling the data directly from your application and take advantage of the built in funtionalities (Fetch optimization, sorting, etc).

If the use of the DataTable/DataReader is mandatory I would recommend that you create a structure inside an extension and an action that would encapsulate the call/fetch and also to populate and return a record list of that same structure.

Cheers