I've started today evaluating if OpenAcces can do my businness.... I've got a stored procedure which has 2 dataset as resultset (its just a select on 2 tables), how can I map this to an object? In the truth I've just problem mapping a single dataset to an entity... doesn't openacess provide a tool for automated mapping as EF does?
Thanks
Paolo
6 Answers, 1 is accepted
Rank 1
The ORM guys probably won't thank me for this but ORM doesn't map to SP's very well, we had the same requirements and ORM falls a little short regarding stored procs although it has lots of nice features especially if your going model 1st instead of database 1st. If we didn't have to do so much retro plumbing with SP's we'd have most likely used ORM.
We ended up running with LLBLGEN which does what you describe very well, just comes down to what your requirements are but the Telerik ORM guys are very helpful, I'd choose it over EF.
Indeed currently we somewhere lack functionality in regards to stored procedures. Basically the problem is that you are not able to use design time to specify the result set of a stored procedure. This said our result sets are always automatically set to object arrays. This is subject to a change and we will be targeting huge improvements in our API. If you look into our road map you will see that we are preparing an ADO like API that will greatly ease the work with stored procedures.
Greetings,Petar
the Telerik team
Rank 2
I 've no doubt you'll improve the API but what I need is need now ... I can't wait too much I need to have the data filtered based on some authentication mechanism I've got right now in store procedure...almost 80% of my DB access are throught SP
Thanks
Unfortunately currently OpenAccess will not be perfectly applicable for your scenario. It will certainly improve and cover your case(and all others as well) but that will be Q2 2011 earliest. I would advice you to come back and check after some time to see if our improvements will benefit your project.
All the best,Petar
the Telerik team
Rank 2
The functionality for automatically mapping stored procedures to a result time did not make it in the product for the Q release and it will be available with our service pack. What made it though is the ability to obtain multiple results sets from a single stored procedure. This is made available via our ADO.API. Additional information can be found in our online documentation located here.
Best wishes,Petar
the Telerik team
Register for the Q2 2011 What's New Webinar Week. Mark your calendar for the week starting July 18th and book your seat for a walk through of all the exciting stuff we will ship with the new release!