Update From Database Function Does Not Import Stored Procedures

Thread is closed for posting
2 posts, 0 answers
  1. Stephen
    Stephen avatar
    1 posts
    Member since:
    Mar 2013

    Posted 18 Aug 2013 Link to this post

    I've built a model which includes some of the stored procedures in the database but am unable to update the model for new stored procedures from the database.  The first page 'choose database items' of the wizard pops up with all the stored procedures that are not in the model but the after I select the models to include and click the next button to go to the 'select  changes' page there are no stored  procedures shown and the 'finish' and 'next' buttons are disabled.  Is there some feature or option that exists that I've not discovered that will resolve this issue for me?
  2. Boris Georgiev
    Boris Georgiev avatar
    190 posts

    Posted 21 Aug 2013 Link to this post

    Hello Stephen,

    Unfortunately we were not able to reproduce the issue on our side. The only scenario in our tests when there aren't any stored procedures in Update From Database -> Select Changes window, is when the checked stored procedures are already added.

    Could you verify that you are not trying to add stored procedures that are already in the Domain Model? You can see the added stored procedures from the Model Schema Explorer in the Stored Procedures and Functions section.

    If this is not the case, could you try to reproduce the wrong behavior in these two scenarios:
    1) In another project with the same database.
    2) In another project with a different database.

    If you reproduce the problem and you can send a sample application that demonstrates it, could you let us know, so that we can make the attachments available in this thread and you can send it over for analysis?

    I am looking forward to hearing from you.
    Boris Georgiev
    OpenAccess ORM Q2 2013 brings you a more powerful code generation and a unique Bulk Operations support with LINQ syntax. Check out the list of new functionality and improvementsshipped with this release.

Back to Top