|
|
Rank: Newbie
Groups: Member
Joined: 9/9/2008
Posts: 1
Points: 3
Location: Mumbai
|
Hi,
How do we call/ use stored procedures from ADF? Does ADF have a inbuilt support for SP's or do we need to extend the framework?
Thanks,
Arvind
|
|
Rank: Administration
Groups: Administration
Joined: 5/29/2008
Posts: 14
Points: 42
Location: Zoetermeer
|
I am not aware of a ADF project which are using SP's. You have to create a new plugin for ADF.Data. It's is just creating a new class based on ADF.Data.SQLServer.SQLServerProvider
Robert de Wolff - ADP Core Team
|
|
Rank: Administration
Groups: Administration
Joined: 5/29/2008
Posts: 14
Points: 42
Location: Zoetermeer
|
You also need the define (or generate) generic SP's for CRUD actions
Robert de Wolff - ADP Core Team
|
|
Rank: Newbie
Groups: Member
Joined: 10/13/2008
Posts: 0
Points: -188
Location: Utrecht, NL
|
Please realize that CRUD is not enough. If SP's are to be introduced into the framework we need some combination of the following nine kinds of SP-templates for Tobago:
1. Simple select for single root record
2. Set based select to retrieve multiple records (option: from multi8.ble tables?)
3. Insert record
4. Update record
5. Delete record
6. Process (complex set based operations)
7. Administrative procedures for actions like create table, alter table, drop table & set privileges
8. Reporting stored procedures
9. Miscellaneous
Although decoupling the application from the database by means of a required stored procedure interface has been a common requirement for some of my projects in the past, I personally would not put any effort in this untill it is an actual requirement for an actual project. Until then I recommend the lazy student pattern and stick with the current ORM. Because when you start working on this you soon realized you have entered a hornests' nest.
Maurice
|
|
|
Guest |
