How to add unit test To ADO.Net Generic Data Access Layer

I m developping a generic ADO.net DAL and I want to add some unit tests. I need to find a way how to test for example an insert query is there a good tutorial or blog to do such a thing.

Regards.