.net unit testing - How to test Insert/Update/Delete methods

Question

I am using .net unit testing in my project. I can unit test, get methods by using Assert.AreEqual. But how can i test Insert/update/delete methods. Please help

Thanks in advance.

Answer 1

For insert, the basic test pattern could be:

• create entity instance
• insert entity
• read inserted entity
• compare created entity and read entity
• delete entity

For update:

• create entity instance
• insert entity
• change entity properties
• update entity
• read updated entity
• compare changed entity and read entity
• delete entity

For delete:

• create entity instance
• insert entity
• delete entity
• read deleted entity (should fail)

Note than in order to compare reference entities, you can do it manually for each entity type or use a recursive entity comparison method