Invalid object name 'voa_keygen'

[Eric Krauska]

Brand new project using EntityDiagram.  All tables were pulled from the DB and the primary key for each table is a guid.  Upon the first call to our DataContext, we get the below error.  All the posts on the forum I've found relating to this error are for the "Classic" version of OpenAccess, so I have been unable to figure out what is going on here.  Any help is appreciated.

Code that raises the exception:

using (DAL.BarcodeDataContext dal = new DAL.BarcodeDataContext())
{
    DAL.User user = (from n in dal.Users where n.LoginID == username && n.Password == password select n).Single();
    if (user != null) return true;
    else return false;
}

Exception raised:

Invalid object name 'voa_keygen'. Telerik.OpenAccess.RT.sql.SQLException:
Invalid object name 'voa_keygen'.<BR>   at
Telerik.OpenAccess.RT.Adonet2Generic.Impl.StatementImp.executeQuery(String sql)

[Eric Krauska]

Sorry, I just figured this out.  The exception is not a friendly one at all.  It ends up the error was caused by a View that was mapped to a persistent type and the view did not have a primary key specified.  I removed the mapping the view and all is well.  

[Alexander]

Hello Eric Krauska,

This table is required by OpenAccess when one or more classes in the model use internal identity. Internal identity means that the persistent class does not have an identity member defined and this should be handled automatically. The implementation of this mechanism uses the HighLow keygenerator and that is why OpenAccess needs the "voa_keygen" table to store some system values.
By default classes mapped to database views are not generated with identity members and OpenAccess treats them as classes with internal identity. If all classes in your model have identity members and their IdentityMechanism property is not set to Default or HighLow, you should not observe this error.
Hope that helps.

All the best,
Alexander
the Telerik team

[Ken]

Hello, regarding the last sentence in your response (If all classes in your model have identity members and their IdentityMechanism property is not set to Default or HighLow, you should not observe this error.) I assume this means all non sql view classes which don't require the identity mechanism. I have my PK columns set up as guid and the key generator set to

[

 

KeyGenerator(KeyGenerator.Guid)].

 

Why do I still get this error?

Thanks Ken

[Alexander]

Hello Ken,

I just verified that having only classes with Guid identity should not require the voa_keygen table to be present in the database. It would be best if you could send us your rlinq file in a support ticket, so we can have a look at the model and find the reason why this table is needed in your case. 

Kind regards,
Alexander
the Telerik team