Problem setting Identity for Databse View

[Jeff Clark]

I am trying to use the Domain Model of OpenAccess ORM 2011 Q1 release.

I have a bunch of views that I want to use to query from. Since views do not have a primary key I have to either set a primary key in the rlinq Designer or make use of the voa_keygen table.  Neither of these methods are working for me.

voa_keygen table Method
If I use the voa_keygen table method, I get a yellow screen of death error with 'Invalid column name 'tablename_id' 

This column of course does not exist in the view; so, Why is it trying to use this column?

Primary Key Method
More importantly, I would prefer to just set a primary key.  But when I right click on the entity and click 'edit table', click the Identity checkbox next to the appropriate column(s) and click ok, nothing happens. If I go back to the 'Edit Table' dialog box the identity columns are not checked. (They remain checked for entities created form tables, but not entities created from views).

Is this the appropriate way to create a primary key? If yes, why doen't it work? If no, what is the appropriate way?

I can get the views to work if I edit the generated code and add IsPrimaryKey=true to the Column property of the appropriate column, but since this is generated code my changes are removed whenever the code is regenerated.

Thank you for your help.

[Jeff Clark]

Any help would be appreciated, thanks.

[Alexander]

Hello Jeff Clark,

The "voa_keygen" approach is the OpenAccess' mechanism for handling identities internally. In such cases OpenAccess expects that a column with name "tablename_id". Since you do not have such columns in the views this approach cannot be used.

The correct way to set a primary key for a class is actually to set one (or more) of its properties as identity. It is not required that the column mapped to this property is a primary key column. So all you have to do is select in the diagram the property that you want to be an identity and set its Identity property to True from the Properties pane (press F4 to open it). After doing this a small key should appear in the icon of the identity member.
I hope that helps.

Kind regards,
Alexander
the Telerik team

[Jeff Clark]

That works.  Thank you very much.