ORDER BY for SQL Server based DataSource

Question

Is it possible to add ORDER BY clause to SQL Server based DataSource in data driven Web Test - VS 2010?

Answer 1

Hello Piotr,

As far as I know that you can't use SQL Script directly for the data-source in data-driven web test. You can consider submit one feature request on the Microsoft Connect site here: http://visualstudio.uservoice.com/forums/121579-visual-studio

And for your issue, I think you need to get the data in the SQL Server with the correct order first and save it as a XML, csv, Excel file or just save it in another table, and then use the new created file or table as data-source in the data-driven web test. You can create a web test plug-in to do the work for you. For more information about web test plug-in, see: http://msdn.microsoft.com/en-us/library/ms243191.aspx

Thanks.

---

Vicky Song [MSFT]
MSDN Community Support | Feedback to us