question about mapping stored procedure

7 posts, 0 answers
  1. Paolo
    Paolo avatar
    423 posts
    Member since:
    Jun 2009

    Posted 02 May 2011 Link to this post

    Hello,
    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
  2. N Mackay
    N Mackay avatar
    228 posts
    Member since:
    Dec 2010

    Posted 04 May 2011 Link to this post

    Paolo,
     
    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. 

  3. DevCraft banner
  4. PetarP
    Admin
    PetarP avatar
    754 posts

    Posted 04 May 2011 Link to this post

    Hello Paolo and Norman,

     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
    Q1’11 SP1 of Telerik OpenAccess is available for download; also available is the Q2'11 Roadmap for Telerik OpenAccess ORM.
  5. Paolo
    Paolo avatar
    423 posts
    Member since:
    Jun 2009

    Posted 04 May 2011 Link to this post

    Hello Petar,
    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
  6. PetarP
    Admin
    PetarP avatar
    754 posts

    Posted 05 May 2011 Link to this post

    Hi Paolo,

     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
    Q1’11 SP1 of Telerik OpenAccess is available for download; also available is the Q2'11 Roadmap for Telerik OpenAccess ORM.
  7. Brian
    Brian avatar
    28 posts
    Member since:
    Dec 2008

    Posted 13 Jul 2011 Link to this post

    Can 2011 Q2 map stored procedures?
  8. PetarP
    Admin
    PetarP avatar
    754 posts

    Posted 14 Jul 2011 Link to this post

    Hello Brian,

     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!

Back to Top
DevCraft banner