Project Description
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

Purpose

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, so I made this application to help the developers deleting the stored procedures they are not using.

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

Last edited May 29, 2010 at 9:09 PM by waelouf, version 4