Hi, all.
Is it possible to run a query in the data source rather than connect it to a table I have a SQL Server database that I would like to run a query on rather than select from a specific table.
Thank you.
Can I run a query as a data source to a SQL Server database?
Hot Topic
- TF30177 - Error
- Installing Team Explorer over Visual Studio 2005 Professional
- Help me justify TeamSystem to my boss.
- Custom rules (and Mono)
- Testing: Call Context is lost
- MSTest Error?
- Diagram designer orders?
- Invalid Build Type
- Can't find some VSS features in new source control system
- no coverage result for website
VS Team System
- Team Explorer - Disconnect error
- One-way links between work items
- Random datasource
- Newbie, need help on import existing projects
- Using FxCop code (Need to write CustomRule for TreeView -> TreeNode value)
- TF Beta 3 Compatible with VS 2005 RC1 ?
- MS Project intagration problems
- Where to post questions/comments about...
- Seeing a report into VSTS
- Batch update work items
Can I run a query as a data source to a SQL Server database?
JockeP
Yulia, I beleive you are asking about Data Driven Unit Tests. It is not possible to specify a query but you can create a view or stored procedure on your SQL server and specify the name of the view as data table name for the test.
Thank you,
Michael Koltachev
VSTS
KC Oaks
After selecting the connection string, the Choose Tables dialog appears. The views appear in this dialog. Are you not seeing them
One other option is to perform custom databinding. I would use the built in functionality if possible, but if it does not meet your needs, you can manage the databinding yourself. Check out this blog post for more information on custom databinding: http://blogs.msdn.com/slumley/archive/2006/04/07/570772.aspx
Sean
Charles Berry
ccc3