Best practice issue: Datatable and representation in objects

Question

Hello...

I need a datatable in order to display the data at a WPF datagrid augmented by some generated data. But i also need to load the data from the database to local C# objects because the classes that represent tha data do many calculations .

So what is better? Depend only at datatable ? Or have the data both in objects and datatable?

Answer 1

You may adopt following startegy

If you maintaining two sets of data (one in data table and another in C # class objects, you need to manually synchronize data.)

What you can do is create a class which will bring all the columns which needs to show on grid than create a List of this class and bind the data in grid.

in this way , you will be able to avoid duplication of your model as well as manully synchronization between sets of data.