to get write all stored prodedure

4 posts, 1 answers
  1. PureRamu
    PureRamu avatar
    37 posts
    Member since:
    Feb 2009

    Posted 28 May 2009 Link to this post

    is there any way to get write all stored prodedure  using OpenAcess if i  have databse with tables?
    stored prodecures to insert , update, delete, select,find
    are expected to produced by this orm  if i can chose the databse
  2. PetarP
    Admin
    PetarP avatar
    754 posts

    Posted 30 May 2009 Link to this post

    Hello PureRamu,
    OpenAccess can generate stored procedures for the basic CRUD operations for you. Please have a look at our help topic located here.

    Kind regards,
    PetarP
    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.
  3. DevCraft banner
  4. PureRamu
    PureRamu avatar
    37 posts
    Member since:
    Feb 2009

    Posted 30 May 2009 Link to this post

    i have enable a project to use open acess and i am retrieving data  using a codes
    (I  created class  from tables)
    I looked my databse  .but no stored procedures are  created newly on the database
    why?

    "The Telerik OpenAccess ORM tool supports usage of stored procedures for retrieving and modifying data."

    do this mea that it creates stored procedures .
    can u point out what  step may i go wrong?
    Can you give me step by step instruction to create a web application as 3 tiere?
  5. Answer
    PetarP
    Admin
    PetarP avatar
    754 posts

    Posted 01 Jun 2009 Link to this post

    Hi PureRamu,
    when you reverse map your tables you can switch to advanced tab in the reverse mapping wizard. From there you can select any class and check the Use stored procedure check box. A list with available stored procedures will appear and from there you can specify whether to use Dynamic SQL(meaning that every time when you add for example a new SQL statement will be generated) or you can select create stored procedure which will generate a new stored procedure on your SQL server and that stored procedure will be used the next time you try to add an object.

    All the best,
    PetarP
    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.
Back to Top