I am developing a Selenium Test Automation Framework for the purpose of testing multiple websites.
I have currently set up the Framework in Visual Studio using C# and implementing the Page Object Model.
The Framework itself is a C# project and the Test project is separate but references the Framework.
I am happy with the fundamentals of the Framework but I want to implement some Data Driven aspects in order to increase the durability of the tests. I currently have NUnit running paramaterised test using [TestCase] but the data is hardcoded by me.
The ideal scenario would be to add a DatabaseHelper class to the Framework which would allow me to define queries on the database under test to return values and Nunit would repeat the same test for each row of the SQL query.
Has anyone here implemented a similar method and how would you go about creating it?