Testcasesource attribute reads all the test data's of existing tests even if we run only one test.

See more:

C#

NUnit

selenium

My requirement: I want to read multiple TestData for single case and execution with all TestData should happen by itself.

TestCaseSource attribute provides these requirement but not exactly.

Using TestDataSource it is fetching TestData of tests which need not to be executed.If 100 tests are there and running on one test it is fetching TestData of all tests.

Solution needed as: Is there any possible way to read the TestData for each test while each test start executing.

Worst case solution: Single loop for all tests under class is considerable.

What I have tried:

If dividing tests into multiple category and while running tests based on category, it is fetching the data for other tests from different category.

How I have implemented:

OleDbConnection is used for connecting with excel.
For each class separate excel document is used.
For each test separate worksheet is used.
Multiple test data is given in separate rows.