How to write NUnit test cases for inserting records in DB?

Question

I've to write a test case for inserting a validated record into more than one tables of database using NUnit.

 

So how it should be done? and what is the best way to do that?