I have a C# application which communicates with DB. I want to test some functions which depend on DB. So I want to be sure that DB has an initial state before each test run. I use NUnit to test my application. What means are available to restore an initial state of DB?
Thank you for your help!
你们可以在记忆库数据库中用于创造试验环境。
http://www.dotnetguy.co.uk/post/2009/10/20/sqlite-nunit-fluent-nhibernate-test-your-data-access-layer/“rel=” 缩略语
您不测试与数据库的互动。 这类测试称为一体化测试。 您可以为此使用您通常的测试工具(NUnit,MS Test, 等),但最好将一体化测试与单独的项目分开,使用专门的测试数据库,并在交易中进行这些测试(例如,使用TransactionScope)。 这确保数据不会改变,你的测试行为可以预测,这一点非常重要。
如果你能够,就设法设计你的申请,那么,很容易毁掉所有外部来源,如你的数据库,以允许你进行(通常更快)单位测试。 然而,这并不容易。 特别是在处理现有申请时,已经设计了可检测性。 在这种情景下,我发现一体化测试是一个良好的开端。
As others have said, you must NOT depend on a DB and it s structure in unit-testing. Hence I would create an Interface which hides the DB from the component which uses it (aka DB abstraction layer) and then implement an in-memory-DB for the sake of unit-testing.
可通过每个非行表格使用简单的C# HashT表执行该非行的表格。
这种地震还有助于在行文中将行文分离,从而可能改变(例如从MySQL移至Oracle等)的成分。
Consider switching to MbUnit for your integration tests. It has very handy Rollback attribute exactly for your needs.
MbUnit与NUnit一样具有标识测试类别和方法的特性。 因此,你只需要改变指令和参考MbUnit dll。
What is the use of default keyword in C#? Is it introduced in C# 3.0 ?
I m the only developer in my company, and am getting along well as an autodidact, but I know I m missing out on the education one gets from working with and having code reviewed by more senior devs. ...
I m pretty new to the Objective-C world and I have a long history with .net/C# so naturally I m inclined to use my C# wits. Now here s the question: I feel really inclined to create some type of ...
I cannot figure out how to marshal a C++ CBitmap to a C# Bitmap or Image class. My import looks like this: [DllImport(@"test.dll", CharSet = CharSet.Unicode)] public static extern IntPtr ...
I have two EF entities. One has a property called HouseNumber. The other has two properties, one called StartHouseNumber and one called EndHouseNumber. I want to create a many to many association ...
How to user GhostScript DLL to convert PDF to PDF/A. I know I kind of have to call the exported function of gsdll32.dll whose name is gsapi_init_with_args, but how do i pass the right arguments? BTW, ...
Since I cannot order my dictionary, what is the best way of going about taking key value pairs and also maintaing an index?
Maybe it s something I m doing wrong. I m just learning Linq because I m bored. And so far so good. I made a little program and it basically just outputs all matches (foreach) into a label control. ...
