Can a DataSource be anything other than a table?

Question

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.

Answer 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?

Answer 2

Actually, I hadn't looked for my views. What I REALLY want/need is SPROCS and dynamic SQL queries.

Answer 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.