An application that is highly dependent on stored procedures

Question

We currently have an application that depends a lot on stored procedures. There is heavy use of temporary tables. This is an extremely large application.

In this situation, I would like to use Entity Framework or Linq2Sql for rewriting. I might consider using Fluent Hibernate or subsonic, since I used them quite widely in the past.

I had problems with Linq2Sql generating return types for stored procedures due to the use of temporary tables, and I think it is cumbersome to go and change all stored procedures from temporary tables to tables in memory.

Given the two options I want to do, which of the two is the best route and why? If my choices are extremely idiotic, provide alternatives.

Edit: The reason for the question and change is that the data access layer does not exist and was built 10 years ago. Currently, we are still facing many problems. I don’t want to disclose too much, but if you saw this, bleeding will begin in your eyes :)

Answer 1

This is probably not the answer you need, but it seems that it mainly concerns the allocation of the appropriate code to the “new” level of data access.

If you abstract data access through interfaces, you can use any data access available to you. I'm just not 100% sure how this applies to things like Enity Framework.

The reason that I will stick to this path is that it allows you to very well understand the problems that make the application easier to work over time, and this does not do it at the expense of performance (in my experience).

As a first step - instead of rewriting, which I would like to do, just draw the Data layer in place and cross it out so you can work with it.

At the same time, you can make some evidence of working on concepts with materials such as the Enity Framework, so that when you are ready to reorganize the new DAL, you have reliable information to substantiate your decision.

Just remember that the "quality of execution" must be balanced with the "evolutionary" :)

Answer 2

Have you thought about LLBLGen Pro ? This is a commercial solution, but it is quite cheap, and I believe that it is much better than these two alternatives. I think Frans Bouma is actually an SO user, but their forums are also very helpful.