How do i query Pivot data stored in Data Table by LINQ

  • Thread starter Thread starter Sudip_inn
  • Start date Start date
S

Sudip_inn

Guest
see the screen shot please

1612382.png

The data is stored in my data tabble like above picture. where Quarter or Period is column name. now how could i query this datatable by LINQ where i will mention Section, LineItem, Broker and period ?

the problem is period column name is not fixed. one period column name is 1Q 2021E another one 2Q 2022E. when we query by linq then we have to mention column name. so how could i query for period or quarter by LINQ?

please discuss if any good solution exist to handle this query by LINQ. thanks

Continue reading...
 
Back
Top