Index Mapping Error

[Mark Sheldon]

I'm working on a project involving a large number of Foreign Key relationships in most of the tables. Reverse mapping the db (tables  only) resulted in the creation multiple indexes of the same name, similarly to the posting below:
http://www.telerik.com/community/forums/orm/getting-started/error-mapping-table-indexes.aspx

The error message I received on attempting to use the update from dateabase wizard was:: Cannot add item with key 'MetaIndex'ActivityAttemptItem'.ActivityPackageIndex' to MetaItemIndex.

I manually renamed the indexes in the .rlinq underlying xml and it seems to have worked around the Issue, however, Is there a better approach? I'm sure I must have missed something simple.

OpenAccess v2011.1.325.1, SqlServer 2008R2

Thanks in advance.

[Jordan]

Hello Mark Sheldon,

This error message basically means that in the model there are two or more objects (in your case of the MetaIndex type) that seem to be the same. In your case "the same" means indexes for the same table with the same name.

Do you have in your model multiple indexes for the same table with the same name?
Normally SQL Server should not allow this so it is not normal that you see this error.

It will be best if you can send us the .rlinq file and the database schema so that we can investigate this case with your exact model.

Kind regards,
Jordan
the Telerik team

[Mark Sheldon]

Thanks for your assistance, Jordan. I appreciate your efforts.

I'll open a support ticket and attach the files.

Thanks again.

[Jordan]

Hello Mark Sheldon,

Thank you for sending the files.
Please, find the answer to your original question in the support ticket.

Kind regards,
Jordan
the Telerik team