Invalid object name 'voa_keygen'

5 posts, 0 answers
  1. Duncan
    Duncan avatar
    93 posts
    Member since:
    Jul 2012

    Posted 06 Dec 2011 Link to this post

    I have just added the .Net membership tables to my database using aspnet_regsql.exe and now i am getting the error Invalid object name 'voa_keygen'...

    Any ideas on what is going on here. I have received this once before when there was no Primary key on a table but i have checked for that and am not finding anything wrong with this... What else should i be looking for?

    Duncan
  2. Duncan
    Duncan avatar
    93 posts
    Member since:
    Jul 2012

    Posted 06 Dec 2011 Link to this post

    I do also have a new table with UserId as a primary key. It is of type Guid and has a relation to aspnet_Users membership table. I suspect that this Guid primary key may be the issue. This is my first table with the Guid as a PK so i am not to sure how to handle this with OpenAccess...
  3. DevCraft banner
  4. Duncan
    Duncan avatar
    93 posts
    Member since:
    Jul 2012

    Posted 06 Dec 2011 Link to this post

    So i guess it does not make sense to include the .Net membership tabled in the entities diagram as you not supposed to be editing these tables directly anyways. So removing them seems to get rid of the issue.
  5. Damyan Bogoev
    Admin
    Damyan Bogoev avatar
    581 posts

    Posted 07 Dec 2011 Link to this post

    Hello Duncan,

    This table is required by OpenAccess when one or more classes in the model use the HighLow KeyGenerator(default Identity Mechanism). Telerik OpenAccess ORM uses the "voa_keygen" table to store some system values.
    You could the Update Database from Model wizard to create this table in the database.
    Hope that helps.

    Best wishes,
    Damyan Bogoev
    the Telerik team

    Q3’11 of Telerik OpenAccess ORM is available for download. Register for the What's New in Data Tools webinar to see what's new and get a chance to WIN A FREE LICENSE!

  6. Rui
    Rui avatar
    30 posts
    Member since:
    Feb 2012

    Posted 27 Mar 2012 Link to this post

    Check Many-to-many relations... Maybe you are doing something wrong.
Back to Top
DevCraft banner