c# - writing unit test cases -

c# - writing unit test cases -

in project dealing database (sql server 2008). reading, inserting, deleting , updating data. of sql script created xml automation tool , manually written developer. of times face issues manual missing entry , automated generated scripts. lie write unit test cases scripts take care not face issues after checkin code. question is way write unit test cases these scripts?

if want test sql suggest have @ sql server info tools include database uts can run via visual studio 2010 , 2012

c# unit-testing nunit mstest