Stored Procedure is not just a way to plug a complicated and absurd business logic into the database; it also avoids inserting a complicated and absurd storage logic into the application.ProgramAn application layer. It enables applications to be seen as ideal data performance without disclosing the magic of Database Administrators (DBAs. Various temporary tables, nonstandard Report Tables, views, and table functions are hidden behind simple stored procedure calls, forming a public application programming interface (API) for the database ). Note that everything from minor performance adjustments to comprehensive Refactoring can be done without the need to redeploy many applications that depend on the database.
If you are using the code first technology of Entity Framework, you must wait until Entity Framework 6 to get some form of stored procedure support. However, a guy in codeproject has implemented the code first technology to support the stored procedure. For details, seeArticle: Http://www.codeproject.com/articles/179481/code-first-stored-procedures.
EF Power Tools Beta 3 available