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
Post a Comment