I was reading Karl Seguin post "Stored Procedures Going going .... gone" and I realized that although the stored procedures are not gone yet but they are slowly fading away. I have always developed application using stored procedures and to me it is just a natural way of building applications. But as time changes the way we design the software also changes. Now, I see many OR mappers that are replacing the stored procedures approach



I was reading Karl Seguin post "Stored Procedures Going going .... gone" and I realized that although the stored procedures are not gone yet but they are slowly fading away. I have always developed application using stored procedures and to me it is just a natural way of building applications. But as time changes the way we design the software also changes. Now, I see many OR mappers that are replacing the stored procedures approach. Here is a small list of OR mappers:

1) NHibernate (You can also use stored procedures).

2) SPRING.NET

3) GENTLE.NET

Even, Microsoft is coming out with DLINQ technology which executes dynamic SQL as well as stored procedures. I am not planning to dive into the debate that which is the best way to handle data I am just looking at different technologies that are changes very fast.

Not only Microsoft technologies are adapting the dynamic SQL way but Ruby also executes dynamic SQL.

What do you think is the future of Stored Procedures?