stored procedures

Thread is closed for posting
9 posts, 0 answers
  1. goxel
    goxel avatar
    9 posts
    Member since:
    Jan 2009

    Posted 08 Apr 2009 Link to this post

    Hi

    We're using open access as an orm tool.
    Does openaccess generates sql stored procedures automatically according to reverse mapping ?
    How can we success this ? We want to use open access persistent classes with crud operations over stored procedures. We don't want to use objectscope.add or any method like that.

    Thanks.
  3. PetarP
    Admin
    PetarP avatar
    754 posts

    Posted 09 Apr 2009 Link to this post

    Hi goxel,
    you will first need to actually tell OA to generate those stored procedures for you. You can do so in the reverse mapping wizard. You should open the reverse map wizard and click on the Advanced View (TreeView) tab. 
    You can choose the class for which you want to create a stored procedure. When you select class mark the Use stored procedure check box and on the insert procedure(or any other procedure) from the drop down list instead of Use Dynamic SQL choose Create Stored Procedures. Click generate and save config. Check if the Update Database property of your class library is set to true and if so rebuild your project. When you rebuild your project the stored procedure will be created on your sql server. Now you need to open the reverse mapping wizard again and do a merge to reflect the changes in the sql server. Merge the new procedures. When you do so you will be able to find those procedures in the Stored Procedures node in the Advanced View(TreeView) tab. Choose the procedure you want to generate and set the property Generate method to true. Click generate and save config. Now your stored procedure will be available as a static method into StoredProcedure.cs class inside your class library. To invoke them you will need to call [ClassLibraryName].StoredProcedures.[NameOfProcedure] (here you can replace the class library name with the class library that holds your persistent classes and NameOfProcedure with the actual name of your procedure).
    Note that the newly created stored procedure will require all the fields from your table plus an instance of the IObjectScope.
    Additional information can be found here.

    Greetings,
    PetarP
    the Telerik team

    Check out Telerik Trainer , the state of the art learning tool for Telerik products.
  5. goxel
    goxel avatar
    9 posts
    Member since:
    Jan 2009

    Posted 09 Apr 2009 Link to this post

    Hi

    i cant find screen you said. when i open the advenced tab there is no use stored procedures checkbox. i think version is different. mine is 2008.3.1204.1.
  7. PetarP
    Admin
    PetarP avatar
    754 posts

    Posted 09 Apr 2009 Link to this post

    Hello goxel,
    stored procedures are introduced in Q1 2009. If you want to use them please update your version with the newest open access available on our web site.

    Greetings,
    PetarP
    the Telerik team

    Check out Telerik Trainer , the state of the art learning tool for Telerik products.
  9. goxel
    goxel avatar
    9 posts
    Member since:
    Jan 2009

    Posted 13 Apr 2009 Link to this post

    Hi

    what should I do to update the version that I use, is it possiple for you to tell me the procedure step by step?
    It is an urgent and a critical situation. I have to process the operation as quick as possible

     

     

     

    Thanks.

    Thanks.
  11. Zoran
    Admin
    Zoran avatar
    534 posts

    Posted 14 Apr 2009 Link to this post

    Hi goxel,

    There are three simple steps that require to be done in your scenario:
    • Uninstall the current version of OpenAccess from your machine
    • Download the latest version from our website
    • Install the new version that you have downloaded
    After you do so your stored procedures should be found by the Reverse-Mapping wizard as explained in our documentation.

    Greetings,
    Zoran
    the Telerik team

    Check out Telerik Trainer , the state of the art learning tool for Telerik products.
  13. Rhyss
    Rhyss avatar
    60 posts
    Member since:
    Jan 2007

    Posted 15 Apr 2009 Link to this post

    I just did an install of the new version, as I had this problem too.
    But on installation, the menu from VS2008 is no longer there.
    Is this a known issue?  Is there something new I have to do to have OpenAccess play nice with VS2008?
    Thanks,
    Steele.
  15. Dimitar Kapitanov
    Admin
    Dimitar Kapitanov avatar
    632 posts

    Posted 16 Apr 2009 Link to this post

    Hi Jordan,
    We moved to a single 'company adopted' menu called Telerik. You should find the OpenAccess sub menu there. If you have other products from Telerik like Reporting or AJAX controls you will find additional stuff there.

    Greetings,
    Dimitar Kapitanov
    the Telerik team

    Instantly find answers to your questions on the new Telerik Support Portal.
    Check out the tips for optimizing your support resource searches.
  17. prabhu
    prabhu avatar
    6 posts
    Member since:
    Jun 2007

    Posted 16 Apr 2009 Link to this post

    hi goxel,

    im vignesh

    Steps

    1.Choose the database (openaccess-->Enable project---->Expertwizard--->update database set true)
    2.Telerik--->openaccess---->Reverse mapping
    3.choose Avanced view tab --->select ur tables,
    4.click ur  table (before initialize primay key in ur table)
    5.select right corner one check box wil be display in dialog box (use stored procedure)
    6.it wil automtically display the some option(insert,update,delete)select u r process wat u have done ..
    7.Another way is there

         u just click Stored procedure --->right side wil be display u r stored procedure and select ur tables

    8.And also dont forget simple view Tab select ur tables
    9. Generate& save config
    10.bulid the class file.


    Further any doubt contact my mail id m.vigneshbabu@gmail.com

    take care bye!!!!
Back to Top