FIltering Test Data with a specific condition
Posted: Sun Jan 10, 2016 1:41 am
Hi,
I am using Ranorex out of functionality to load data from excel.
Scenario: I have 4 submodule in my test suite. For one test case.. I need 1 row from the 1st module, 5 rows from 2nd module, 3 rows from 3rd module etc.
Currently I am using "foreach" loop to filter the data based on some condition (eg: client id). For 100-150 records, it's working fine. But recently I got to know that business team is planning to use and there are more than 5000 records for each module. I tried with 1000 records and noticed that it's taking lot of time to the filter the data.
Is there any easy fix for this problem. I have heard about LINQ but does not have enough knowledge to write code. I don't want to change my complete framework for loading data.
Thanks in advance for all the help and suggestion.
I am using Ranorex out of functionality to load data from excel.
Scenario: I have 4 submodule in my test suite. For one test case.. I need 1 row from the 1st module, 5 rows from 2nd module, 3 rows from 3rd module etc.
Currently I am using "foreach" loop to filter the data based on some condition (eg: client id). For 100-150 records, it's working fine. But recently I got to know that business team is planning to use and there are more than 5000 records for each module. I tried with 1000 records and noticed that it's taking lot of time to the filter the data.
Is there any easy fix for this problem. I have heard about LINQ but does not have enough knowledge to write code. I don't want to change my complete framework for loading data.
Thanks in advance for all the help and suggestion.