Design And Implementation Of Database-Oriented Unit Test Frame

In software development, many applications use the database, so it is very important to use database-oriented unit test. A new database-orient unit test frame is designed and implemented here. It can improve the efficiency of software developing in the database-oriented unit test which is used on .NET.Database-oriented unit test belongs to unit test. Because the database state will be shifted when the unit test is developing, we can't benefit from the unit completely. To be honest, to implement the database-oriented unit test, the key is setup and restore the state of the database. To implement the Database-oriented unit test, it is necessary to understand other unit test frame. Now there is many unit test frames, including JUnit, NUnit, DbUnit, etc. The first unit test frame is JUnit, most of the other frames use its'structure and thought.There are many methods to implement the unit test frame. The database-oriented unit test frame is implemented through XML. To set and restore the state of the database, some functions are needed, including insert, delete, update, refresh, etc. When going into particulars, SqlClient and OldDB is included in the design of the frame. What's more, XML, many methods and design patterns, like Composite, Adapter, Template, Bridge and Facade, are also included in the design of the frame.To the frame, one dll files is got at last. After using the database-oriented unit test frame, the development of the project can be improved the efficiently.