In a PowerBuilder-based project, there are overs three hundred stored procedures on a Microsoft SQL Server. It's a client-server application which relies a lot on PB's DataWindow.
Now, there is an feature request from the users which will most likely add several web-based screens to interface w开发者_JAVA百科ith the system.
We are evaluating Rails (for our team member experience) and CakePHP (for performance/deployment considerations).
We use a lot of ActiveRecord (on Rails, naturally) for other web-based projects. However, stored procedures and ActiveRecord do not play well with each other.
I'd like to hear your experience and suggestions on:
- how to minimize rewriting (duplicating) the stored proecedures in ActiveRecord
- besides what we are already looking at (Rails and CakePHP), what are the alternatives (say, DataWindow.NET?, LINQ?)
Thanks!
Powerbuilder 11.5 Webform's datawindows work very nicely with stored procedures. It works exactly the same as client-server Powerbuilder. No rewrite at all.
The obvious answer if you're only interested in SQL Server stored procedures is ASP.NET. You could even consider IronRuby!
精彩评论