Excellent post about O/R Mapping and stored procedures. Paul writes, that there are two good approaches for development:
- O/R Mapping
- Stored Procedures (SP) + Code Generator (CG)
I agree. Other ways are not so good and bring additional problems (sometimes serious). Just one point is discussable for me. Paul puts O/R mapping on the first place, but I don’t think that CG+SP definitely worse than O/R Mapping. I have very bright example in our company. We've used CodeSmith, and this tool really great. Sure, templates took time, and I can't insist that O/R Mapping will not solve the same problems faster next time. But, anyway, CG is a good alternative.
I personally prefer O/R Mapping. I have experience with NEO.NET and Tangram, and these tools are good and helpful. But there were some nasty problems with them, and (sadly) lack of documentation is very serious problem for many free open-source tools. It takes time to dig into source code and get the problem fixed. It takes time to understand system behavior, when it does not mach expectations. But these are problems of exact (free) tools, not an O/R Mapping in general.
You can subscribe to our monthly newsletter here:
Сheck out latest blog posts:
Get started for free
Manage complex work, projects and products with Targetprocess
We’ve sent you a confirmation e-mail — please, go check it.
With our product specialist Ksenia