[Solved] Invalid object name 'voa_keygen'

[Duncan]

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

[Duncan]

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...

[Duncan]

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.

[Damyan Bogoev]

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

[Rui]

Check Many-to-many relations... Maybe you are doing something wrong.