How to tell what name RIA Services/EF Model uses for Associations?

Posted by Nick Gotch on Stack Overflow See other posts from Stack Overflow or by Nick Gotch
Published on 2010-02-23T20:24:46Z Indexed on 2010/03/23 21:53 UTC
Read the original article Hit count: 453

Filed under:

entity-framework

Hi, I'm working on a C#.NET 3.5 WCF RIA Services app and having an issue with my Entity Framework model.

My entity Foo is mapped to a DB table and has a primary key called FooId. My Bar is mapped to a DB view. I've selectively designed this view to generate a composite key in the EF using two of the columns (by making sure they were non-nullable and the others are all nullable. This was done using NULLIF and ISNULL in the view design.)

I'm able to add this view to the model with no problem but I keep running into an issue when I try to map an association between the two. Foo should contain many Bars but I keep getting the following error when I add the association:

Unable to retrieve AssociationType for association 'FK_Bar_Foo'

According to this page, it looks like this might work if I can properly name the association (since RIA Services looks for specific names.) I've tried several variants of names that match the pattern of other associations with no success. Does anyone know if there's a place I can look to find out what name it's looking for?

Thanks,

Related posts about .net-ria-services

A WaspKiller Game with Silverlight 3, .NET RIA Services, MVP and MVVM Patterns Part 2

as seen on Dot net Slackers - Search for 'Dot net Slackers'
In this second part, we will continue to discuss the WaspKiller game development—to extend the functionalities with the server-side database support. As mentioned in the first part, we’re going to rest upon another well-known design pattern, MVVM, to achieve the extension, and at the same time, introduce… >>> More
A WaspKiller Game with Silverlight 3, .NET RIA Services, MVP and MVVM Patterns Part 1

as seen on Dot net Slackers - Search for 'Dot net Slackers'
In this article, we will focus upon the development of the front end of the game using the MVP pattern; in the second part, we will discuss the database related work using the MVVM pattern. >>> More
Can't add Silverlight App with "Enable .NET RIA Services" to existing project

as seen on Stack Overflow - Search for 'Stack Overflow'
I can create new Silverlight App with ".NET RIA Services" enabled. But when I try to add Silverlight App into existing solution in the "New Silverlight Application" the "Enable .NET RIA Services" checkbox is disabled. Why? How can I add Silverlight App into existing solution? Thanks. P.S. Environment… >>> More
DomainDataSource DataPager with silverlight 3 DataGrid & .Net RIA Services

as seen on Stack Overflow - Search for 'Stack Overflow'
I have a simple datagrid example with silverlight 3, and am populating it with the .NET ria services using a DomainDataSource along with a DataPager declaratively (nothing in the code-behind), and am experiencing this problem: The LoadSize is 30, and the Page size is 15, and when the page is loaded… >>> More
Silverlight/.Net RIA Services - Authorization Working Sample!??!

as seen on Stack Overflow - Search for 'Stack Overflow'
Hello! I have followed numerous tutorials and walkthroughs/blogs about the capabilities that Ria Services brings to the table when using Silverlight with ASP.Net. Essentially I am looking for a live working example of the authorization functionality that Ria Services can apparently take hold of from… >>> More

Developer IT