Unit test with live data

Posted by Kurresmack on Stack Overflow See other posts from Stack Overflow or by Kurresmack
Published on 2010-03-18T19:52:38Z Indexed on 2010/03/18 20:01 UTC
Read the original article Hit count: 392

Filed under:
|
|
|
|

Hey,

I have googled this a little and didn't really find the answer I needed.

I am working on a webpage in C# with MSSQL and LINQ for a customer. I want the users to be able to send messages to each other. So what I do is that I unit test this with live data.

The problem is that I now depend on having at least 2 users who I know the ID of. Furthermore I have to clean up after my self. This leads to rather large unit tests that test alot in one test.

Lets say I would like to update a user. That would mean that I would have to ceate the user, update it, and then delete it. This a lot of assertions in one unit test and if it fails with updating i have to manually delete it.

If I would do it any other way, without live data, I would not fore sure be able to know that the data was present in the database after updating etc.

What is the proper way to do this without having a test that tests a lot of functuality by it self?

© Stack Overflow or respective owner

Related posts about c#

Related posts about LINQ