A
A
Alexander2014-03-03 12:38:13
WPF
Alexander, 2014-03-03 12:38:13

Is there an alternative to DataSet in c# for calculated fields?

Good day!
I have a DataSet, which stores the structure of tables and relationships between these tables (about 30 tables). In my WPF application, at startup, I load data from xml into this DataSet, when I exit the program, accordingly, I save the data to the same xml.
In the DataSet, in some tables, mathematical expressions (expression) are used in the fields, it would seem that it’s okay, but when there are a lot of records, when loading data from xml, the program freezes for 10 minutes. I found out the reason, this is due to calculated fields, in particular because for fields that use aggregate functions of the Sum() type.
What can you advise to use as an alternative to DataSet'u to calculate the values ​​in the fields?
To work with xml, nothing else comes to mind.

Answer the question

In order to leave comments, you need to log in

1 answer(s)
S
snuffi, 2014-09-11
@snuffi

use classes instead of DataSet, and calculate anything inside the classes

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question