Unit Testing

I am Currently Working on Few Project and those projects are at their initial stage.

I need to define "Unit Testing- Test Guidelines" So that we can use while development........

I have few in my mind but working on detailed information...... So that in near future Can apply "Test Driven Development" Methodology.

Few Points regarding Unit Testing

Write a Test Case to make sure that every line of code has tested at least once in a test cycle

Write a Test Case to make sure that every condition is tested at least once in case of conditional statement is used

Write a Test Case to make sure that Select statement [thru SQL] is being selected information properly from a respective table or not.

Write a Test Case to make sure that Update statement [thru SQL] is being updated information properly in a respective table or not.

Write a Test Case to make sure that Create statement [thru SQL] is being created information properly in a respective table or not.

Write a Test Case to make sure that Delete statement [thru SQL] is being deleted information properly from a respective table or not.

Write a Test Case to validate the output of Stored Procedures and Methods as well.

Write a Test Case to test the boundaries & validations of a field.

Write a UI Test Case to verify all elements are appearing properly those need to appear on the screen.

Code Review & Formal walk through needs to be done.