Posted in C#, ORM, SQL, Visual Studio 2010 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):
- Entity Framework
- Linq 2 SQL
- Browse the project's folder
- Set the connection string to the required database
- 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 .