从数据库读取数据时如何编写NUUnit测试用例？
我想测试一个功能，其中包括调用 Web 服务以从数据库获取数据。然后这些方法对该数据进行操作。
现在我想为这些方法编写 NUnit 测试用例。当我无法知道（在编写案例时）运行时将获取哪些数据时，如何断言结果或值？
I want to test a functionality which includes a call to web service to get the data from database. The methods then operate on that data.
Now I want to write NUnit test cases for those methods. How can I assert results or values when I cannot know (at the time of writing cases) which data would be fetched at the run time?
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（1）
执行此操作的一个很好的方法是插入数据（在负索引范围内执行（假设负索引未用于生产数据））使用该数据集运行测试，然后在完成后回滚事务。
另一个可以帮助您更好地测试数据层的选项是为数据库层创建一个包装接口。然后，您可以在运行需要该接口的测试时模拟该接口。
通常，您可能拥有 IDataReader 对象并调用 IdataReader.GetMeData，它将从数据库返回结果集。在这种情况下，您可以模拟它（我使用 Rhino Mocks）并告诉它在调用 GetMeData 时返回您的测试数据集。
ps 不要忘记使用依赖注入来传入模拟数据库访问对象。
An excellent way of doing this is by inserting data (do it in the negative index range (assuming the negatives are not in use for production data)) run your tests with that dataset, and then roll back your transaction once you are done.
Another option that would help you test your datalayer better down the road, it to make a wrapping interface for your database layer. You can then mock that interface when you are running tests that need it.
Normally you might have your IDataReader object and call IdataReader.GetMeData and it would return the result set from the DB. In this case you would mock it (I use Rhino Mocks) and tell it to return your set of test data when GetMeData is called.
p.s. Don't forget to use dependency injection to pass in the mock database access object.