Understanding data issues

Maintaining data integrity is important to the success of any ASP.NET MVC 4 application. It is especially critical when working on a data-intensive application, like a point-of-sales application.

What are some tools that help you prevent data corruption?
What are some tools you can use to diagnose whether data corruption has occurred?