c# - Select count from datatable against dynamic query -


i have data set in memory has 2 data tables in it.

  • cont
  • ins

secondly have separate data table (in memory) in have rows in following format.

and suppose has 2 rows. in actual may have million of rows

id    tablename    columnname    operator    value  1       const        id            =           1   2       ins         app_id         =         558877  

as is: information given rows , construct query , execute in database server like:

select count(*) cont.id= 1 , ins.app_id = 558877; 

on basis of above query result have implemented business logic.

objective: in order increase performance want execute query in application server have complete table in memory. how can it.

note: tables name may vary according data.

do want keep tables millions of rows in memory?

in terms of counting in memory table, how kept? if it's datatable per tag can use datatable.rows.count property.

if table names aren't known, can loop on tables in dataset.tables , call rows.count on each of them.


Comments

Popular posts from this blog

java - activate/deactivate sonar maven plugin by profile? -

python - TypeError: can only concatenate tuple (not "float") to tuple -

java - What is the difference between String. and String.this. ? -