🍉 Meet Flexmonster Pivot Table & Charts 2.9.Check out all hot features!
Get Free Trial

Connecting to relational database with net core | OutOfMemory Exception

Rafael Mello asked on January 22, 2020

I´m using Flexmonster by Connecting to relational database with .Net Core.
The sample that you provide in your documentation is only “for simple cases”, like you said on the link below:
But i have a large amount of data. I get “System.OutOfMemoryException” when i call:

string output = reader.ReadToEnd();

You provide another solution in .Net Framework, but this is not available on .netCore
Do you have a solution for this problem?
Rafael Mello

1 answer

Vera Didenko Vera Didenko Flexmonster January 23, 2020

Hello, Rafael,
Thank you for reaching out to us.
We would like to kindly inform you that we are planning to release the major 2.8 version within a few weeks.
In the 2.8 version, the Custom Data Source API will be used instead of the Flexmonster Data Compressor.
Our team kindly recommends checking out our custom data source API approach. Currently, it is in the beta version available on GitHub and we have a .Net Core sample project using the Custom Data Source API approach for JSON datasource.
It allows implementing your own data aggregation service based on your existing infrastructure. Such an approach allows sending already aggregated data to Flexmonster. 
Custom data source API gives full control for the data management and provides the widest variety of optimization options.
This way you have the ability to load just part of the data necessary for the specified report.
You can send only the part of the data needed for the current representation in Flexmonster to the client-side.
When more data is needed to be shown (for example, a row is expanded, a field is added to the slice, etc), a query can be formed to send a different set of data to Flexmonster.
You are welcome to write to us in case further questions arise.
Best regards,

Please login or Register to Submit Answer