How to execute stored procedure?

5 posts, 0 answers
  1. Richard M
    Richard M avatar
    76 posts
    Member since:
    Mar 2010

    Posted 21 Jun 2011 Link to this post

    I have a stored procedure in sql server that takes 2 parameters, and does not return any values.  How do I do this with Open Access?  Here's what I have so far, but it doesn't work:

    MyEntityDiagram conn = new MyEntityDiagram();

    var results = conn.SpCopyUserSettings(userID1, userID2);
    return results;
  2. Damyan Bogoev
    Admin
    Damyan Bogoev avatar
    581 posts

    Posted 22 Jun 2011 Link to this post

    Hi Richard M,

    I prepared a sample application that demonstrates how to achieve that goal.
    Hope you will find the attached application helpful. If any other questions arise, do not hesitate to contact us back.

    Best wishes,
    Damyan Bogoev
    the Telerik team
    Q1’11 SP1 of Telerik OpenAccess is available for download; also available is the Q2'11 Roadmap for Telerik OpenAccess ORM.
  3. DevCraft banner
  4. Richard M
    Richard M avatar
    76 posts
    Member since:
    Mar 2010

    Posted 22 Jun 2011 Link to this post

    That is very easy to use, thank you very much
  5. Matt
    Matt avatar
    2 posts
    Member since:
    Feb 2013

    Posted 20 Feb 2013 Link to this post

    Hi

    Im trying the same but calling a stored procedure using Silverlight ria services. I have built the stored procedures and am trying to populate a listbox. Can you please provide an example of a persistent type SP into a listbox

    regards
    matt
  6. Boris Georgiev
    Admin
    Boris Georgiev avatar
    190 posts

    Posted 25 Feb 2013 Link to this post

    Hello Matt, 

    As this thread is duplicating with another, please find my answer here.


    All the best,
    Boris Georgiev
    the Telerik team
    Q3'12 SP1 of OpenAccess ORM packs Multi-Table Entities mapping support. Check it out.
Back to Top
DevCraft banner