I'm wondering if anyone out there has used SQL Queries inside of a Coded WebTest (using C#). Here's the situation I have; I'm testing a product that includes both firmware and a web interface. Due to the fluid nature of our products I need to be able to query the database and pull values from our products in able to be able to set up our tests. I've tried a variety of different ways to make it work and worked with our lead developer to try and figure this one out. Unfortunately we've all been stumped. If you've actually been able to work with this scenario I'd love to hear what you did to get it up and running.
I use the SqlConnection, SqlCommand, and SqlDataReader. The problem I have is that VSTS appears to just skip the SQL code. If you've got it working then it means that there's something else going on. I'll work with our IT guy and see if they've got VSTS setup correctly. At least I know that someone has had it working.