473,231 Members | 1,751 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,231 software developers and data experts.

Unit Testing VS2008

Hi

I have setup UnitTests that go thru a SQL Server Table Sequentially using the
UntTest Property for DataSource.

What if I need to use 2 tables - I have a Parent child table that I need to
process
Do I do the db coding manually like I would in regular C# code by writing
SELECT statments and looping thru datasets ???

Let me know if there is a better newsgroup for this question

Thanks
Jun 27 '08 #1
3 1428
Hello sippyuconn,

One TestContext is designed for one SQL Server table in the Data-Driver
unit test of Visual Studio 2008. As a possible workaround, we can consider
building a View in the database for the two tables (Parent-Chiled table),
and consume the view in the test function. In addition, we may also build
two test method, and set the two tables for them respectively. I'm looking
for other workarounds and I will be back to you as soon as possible.

Regards,
Jialiang Ge (ji****@online.microsoft.com, remove 'online.')
Microsoft Online Community Support

=================================================
Delighting our customers is our #1 priority. We welcome your comments and
suggestions about how we can improve the support we provide to you. Please
feel free to let my manager know what you think of the level of service
provided. You can send feedback directly to my manager at:
ms****@microsoft.com.

This posting is provided "AS IS" with no warranties, and confers no rights.
=================================================

Jun 27 '08 #2
Hi

Thanks for looking into this.
What I am trying to do is some blackbox testing but also I can set the state
of the blackbox
Table 1 - BlackBox settings
key settings
1 string of "|" separated values
2 string of "|" separated values
Table 2 - Blackbox Input Values - Foreign Ties Table2 to Table 1 settings
key foreign key input expected results
1 1 string of csv
2 1 string of csv
3 1 string of csv
4 1 string of csv
5 2 string of csv
6 2 string of csv
7 2 string of csv
8 2 string of csv

"Jialiang Ge [MSFT]" wrote:
Hello sippyuconn,

One TestContext is designed for one SQL Server table in the Data-Driver
unit test of Visual Studio 2008. As a possible workaround, we can consider
building a View in the database for the two tables (Parent-Chiled table),
and consume the view in the test function. In addition, we may also build
two test method, and set the two tables for them respectively. I'm looking
for other workarounds and I will be back to you as soon as possible.

Regards,
Jialiang Ge (ji****@online.microsoft.com, remove 'online.')
Microsoft Online Community Support

=================================================
Delighting our customers is our #1 priority. We welcome your comments and
suggestions about how we can improve the support we provide to you. Please
feel free to let my manager know what you think of the level of service
provided. You can send feedback directly to my manager at:
ms****@microsoft.com.

This posting is provided "AS IS" with no warranties, and confers no rights.
=================================================

Jun 27 '08 #3
Hello sippyuconn, in the pass few days, I've been researching and
discussing it with the Visual Studio team. I am sorry that we do not find a
better workaround than the ones in my intial reply. We are aware that there
are places we can improve for cross-table unit test. The product team has
recorded this feature. Thank you, sippyuconn, for sharing this user
experience with us. Without the input of numerous intelligent and
warmhearted customers like you, our MSDN Managed Newsgroup can never be as
comprehensive and helpful as it is today. I appreciate your time and
efforts working with us.

Would you please let me know whether there is anything we can do for you.
If you have any comments on our support service, website design, our
product limitation, our process, and etc., please don't hesitate to let me
know. I will do my best to follow up.

Thanks
Jialiang Ge (ji****@online.microsoft.com, remove 'online.')
Microsoft Online Community Support

=================================================
Delighting our customers is our #1 priority. We welcome your comments and
suggestions about how we can improve the support we provide to you. Please
feel free to let my manager know what you think of the level of service
provided. You can send feedback directly to my manager at:
ms****@microsoft.com.

This posting is provided "AS IS" with no warranties, and confers no rights.
=================================================

Jun 27 '08 #4

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

4
by: Hugh Cowan | last post by:
Hello, I don't program full-time (anymore), but I do try and stay on-top of the latest technologies and like most are always trying to upgrade my skills and remain current (as much as is...
14
by: | last post by:
Hi! I'm looking for unit-testing tools for .NET. Somthing like Java has --> http://www.junit.org regards, gicio
4
by: Peter Rilling | last post by:
Does VS.NET 2005 Professional support integrated unit testing, or is that only with the team system?
72
by: Jacob | last post by:
I have compiled a set og unit testing recommendations based on my own experience on the concept. Feedback and suggestions for improvements are appreciated: ...
4
by: Dat AU DUONG | last post by:
Hi, I am new to Unit testing, could you tell me where I could find information (hopefully step by step) and what is the benefit of unit testing. I am a sole developer in a company, therefore I...
176
by: nw | last post by:
Hi, I previously asked for suggestions on teaching testing in C++. Based on some of the replies I received I decided that best way to proceed would be to teach the students how they might write...
48
by: Ark Khasin | last post by:
Unit testing is an integral component of both "formal" and "agile" models of development. Alas, it involves a significant amount of tedious labor. There are test automation tools out there but...
2
by: dmeglio | last post by:
Hello, I've just ported an ASP.NET project from VS 2003 to 2008. In 2003, I was using NUnit to test. Under 2008, I don't get a single DLL for my website, so I can't use NUnit anymore....
4
by: Smokey Grindel | last post by:
Is there any good tutorials out there on unit testing in VS2008 Pro? looking for a starting point.. thanks!
0
by: VivesProcSPL | last post by:
Obviously, one of the original purposes of SQL is to make data query processing easy. The language uses many English-like terms and syntax in an effort to make it easy to learn, particularly for...
0
by: jianzs | last post by:
Introduction Cloud-native applications are conventionally identified as those designed and nurtured on cloud infrastructure. Such applications, rooted in cloud technologies, skillfully benefit from...
2
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 7 Feb 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:30 (7.30PM). In this month's session, the creator of the excellent VBE...
0
by: fareedcanada | last post by:
Hello I am trying to split number on their count. suppose i have 121314151617 (12cnt) then number should be split like 12,13,14,15,16,17 and if 11314151617 (11cnt) then should be split like...
0
by: stefan129 | last post by:
Hey forum members, I'm exploring options for SSL certificates for multiple domains. Has anyone had experience with multi-domain SSL certificates? Any recommendations on reliable providers or specific...
0
by: MeoLessi9 | last post by:
I have VirtualBox installed on Windows 11 and now I would like to install Kali on a virtual machine. However, on the official website, I see two options: "Installer images" and "Virtual machines"....
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: Aftab Ahmad | last post by:
Hello Experts! I have written a code in MS Access for a cmd called "WhatsApp Message" to open WhatsApp using that very code but the problem is that it gives a popup message everytime I clicked on...
0
by: Aftab Ahmad | last post by:
So, I have written a code for a cmd called "Send WhatsApp Message" to open and send WhatsApp messaage. The code is given below. Dim IE As Object Set IE =...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.