Can a DataSource be anything other than a table?

SPROCs, dynamic SQL queries and views would all be very useful data sources. Tables are very limiting, especially when testing systems that don't have database delete capabilities

I know, such a system was not designed with testability in mind, but that's my reality. I suspect its a common reality.Sad

[376 byte] By [kklasman] at [2008-2-20]
# 1
You should be able to use database tables and views as a datasource. You can also use csv files and excel files.

Are your database views not appearing in the selection form after you set your connection string?

slumley at 2007-9-8 > top of Msdn Tech,Visual Studio Team System,Visual Studio Team System - Web and Load Testing...
# 2
Actually, I hadn't looked for my views. What I REALLY want/need is SPROCS and dynamic SQL queries. Big Smile
kklasman at 2007-9-8 > top of Msdn Tech,Visual Studio Team System,Visual Studio Team System - Web and Load Testing...
# 3
SPROCs and SQL Queries are specifcally not supported in this version. You can always execute these SPROCS or Queries into some temporary tables then databind to those. Though not as straight-forward is the built-in databinding it should work.

One interesting thing to note that Our databinding will only include the data that is in the data source at the start of the test. The engine will not requery the data source once a test has started so data inserted during a run will not be included in the data source until the next test run.

Hopefully this limitation won't be a problem for most uses.

EricA_MS at 2007-9-8 > top of Msdn Tech,Visual Studio Team System,Visual Studio Team System - Web and Load Testing...

Visual Studio Team System

Site Classified