Database Cleaner

Posted in By waelouf 0 comments


When a developer works on a long-term project, it could happen that he stop using some stored procedures for any reason (change request, fix bug, update a module, ... etc), and since the stored procedure is the most preferred way to perform all CRUD transactions on the database, so you can create at least 3 stored procedures per table, and it may cause a headache when you try perform a cleaning operation to remove unused objects specially the stored procedures.

"Clean your database" is a simple project removes unused stored procedures from your project what ever the Data Access Layer you are using

This application works and tested on the following DAL (Data Access Layers):
  • ADO.NET
  • Entity Framework
  • Linq 2 SQL
And it is pretty simple to use in only 3 steps:
  1. Browse the project's folder
  2. Set the connection string to the required database
  3. Start the operation

After the searching completed successfully, you can either export the cleaning script and apply the cleaning later, or by performing the cleaning immediately

Download the project source code and installer from CodePlex .