[Solved] Reverse Mapping Views with Q2 Release

[Andrew]

Hi,

I'm trying get primary keys defined for a view so I can use it in a domain service.  The only way I've found to do this is through reverse mapping, but all the references for it use the Reverse Mapping Wizard instead of the new Visual Designer.  

How can I set primary keys on my views to use them in my domain service?

Thanks,
Andrew

[Damyan Bogoev]

Hello Andrew,

You can define primary keys for a view by doing the following steps:
1.   Select the generated class from the Visual Designer;
2.   Click on the class’ property which should be set as primary key;
3.   Set its Identity property from the Properties pane of Visual Studio to True and save the diagram;
Hope that helps.

Greetings,
Damyan Bogoev
the Telerik team

[Sumith Jayasuriya]

I converted to Domain Model and would like to set up a primary key for a view in the model using multiple fields.  The view is combining data from two tables and the Primary Key of the view is the combination of key of Table 1 (Identity) and key of Table 2 (Identity).  

[Serge]

Hello Andrew,

 As the primary key that you will define will only be used by OpenAccess it will not reflect upon your database schema. Marking the properties as identities using the designer as Damyan has suggestion should be the only thing you need to do in order to achieve your goal. 

I hope this is helpful.

Kind regards,
Serge
the Telerik team