Error: Association named xxx defined on entity type

11-03-2009 6:55 PM |

 I have setup a Silverlight application with RIA services as described in this article:

http://www.silverlightshow.net/items/Creating-applications-with-.NET-RIA-Service-Part-3-Adding-DomainService-class.aspx

I created the Entity Data Model with one table and everything works fine. Then I added another table witha one to one relationship and then build the web project it works fine. But when I build the solution it gives me this error:

 

Association named xxx defined on entity type xxxx is invalid: ThisKey property named 'PeopleId' cannot be found.  

I just add two tables which have a relationship defined in the database. The primary key (which is a foreign key in the second table) has a space in it. [People Id], but for some reason the error shows as PeopleId. I am really freustrated trying to resolve this.

 

The error comes when I create the domain service and rebuild the solution. I tried to do from scratch, still same error. Can someone help

 

 

 

Re: Error: Association named xxx defined on entity type

11-04-2009 10:07 AM |

Till then is there any workaround. Would appreciate any links or anything.

Re: Error: Association named xxx defined on entity type

11-05-2009 8:26 AM |

Has anyone else received this error. I googled it but still did not get a solution.

Re: Error: Association named xxx defined on entity type

11-08-2009 10:27 PM |

 I guess there is no solution. For now I switched to using ADO .net data services without RIA services. Guess when 2010 is released I will try to use it...