This question is locked. New answers and comments are not allowed.
1) It would be nice if the ORM would take into account Oracle packages in lieu of just dumping everything into stored procedures. Even if it were just grouping in the SchemaExplorer. I can have the same named proc in different packages.
2) Will Functions be supported? both inside and outside packages?
3) What about quering data via SProc? I currently have ~200+ views but I have SProcs written to return the data as strongly typed ref cursors
4) What about functions that return multiple ref cursors? For example to populate a large complex screen I'm selecting all the data in one pass. All the master data records and all the detail data records. In my BO or my UI I can then use LINQ/filters to handle the parent/child. How would I model that in the ORM?
5) I'm a bit confused on what one can actually do with a SP that is imported... I can get it into the Schema Explorer but can't do anything from there.
6) Is there an ETA on when I can use existing SProcs for CRUD? In the simple case a ORM generated SPROC is fine but how do I tie in my extra logic? Currently I might do a simple insert/update but then I do some math and update other tables. How do I simply extend an autogenerated CUD proc?
7) I'm missing how to have a single entity vs. a collection. Say for example I have Person and PersonList both which derive from my v_person view. Currently I have a proc pkg_person.get_person(an_id in number, arec_data in out system_refcursor) and pkg_person.get_person_list(arec_data in out system_refcursor).
What I'm hoping for is that in my BO I can do Person person = MyDAL.Person.GetById(123) and/or Person person = MyDal.PersonList(x=>x.Id == 123). PersonList was somehow populated earlier.
I think I'm missing where all the retrieval logic goes... I'm currently have an existing library of retrieval packages/procedures - how do I plug them in so they are wrapped and the data transformation is all completed for me? Is that not available?
Thanks
jack
I feel like the ORM has potential... my goal is to have this giant DAL that
2) Will Functions be supported? both inside and outside packages?
3) What about quering data via SProc? I currently have ~200+ views but I have SProcs written to return the data as strongly typed ref cursors
4) What about functions that return multiple ref cursors? For example to populate a large complex screen I'm selecting all the data in one pass. All the master data records and all the detail data records. In my BO or my UI I can then use LINQ/filters to handle the parent/child. How would I model that in the ORM?
5) I'm a bit confused on what one can actually do with a SP that is imported... I can get it into the Schema Explorer but can't do anything from there.
6) Is there an ETA on when I can use existing SProcs for CRUD? In the simple case a ORM generated SPROC is fine but how do I tie in my extra logic? Currently I might do a simple insert/update but then I do some math and update other tables. How do I simply extend an autogenerated CUD proc?
7) I'm missing how to have a single entity vs. a collection. Say for example I have Person and PersonList both which derive from my v_person view. Currently I have a proc pkg_person.get_person(an_id in number, arec_data in out system_refcursor) and pkg_person.get_person_list(arec_data in out system_refcursor).
What I'm hoping for is that in my BO I can do Person person = MyDAL.Person.GetById(123) and/or Person person = MyDal.PersonList(x=>x.Id == 123). PersonList was somehow populated earlier.
I think I'm missing where all the retrieval logic goes... I'm currently have an existing library of retrieval packages/procedures - how do I plug them in so they are wrapped and the data transformation is all completed for me? Is that not available?
Thanks
jack
I feel like the ORM has potential... my goal is to have this giant DAL that