MVC 3 Entitiy - Model first DB problems

Question

I am getting the following error when defining an association between my ExerciseSession and LatLons.

Basically i want a one- to- many relation between my:

asp_net_user -> exerciseSession
ExerciseSession -> LatLons

Is there a difference between an associations and a foreign key relation? and Can someone point to a tutorial which show how to create a 1 -> many relation in an existing .edmx Model Diagram?

Here is a picture to show everything that is going wrong.

enter image description here

rouen · Accepted Answer · 2011-10-25 08:31:19Z

1

Are you sure your foreign key have right "direction" ? From it name it looks it points from session to latlon, but from model it is obvious that it have to be in the opposite direction.

answered Oct 25, 2011 at 8:31

rouen

5,1742 gold badges28 silver badges52 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

rouen Over a year ago

in your DB, key ExcersiseSessionTOLatLon - where it is ? to achieve one to many relation between ExcersiseSession and LatLons, it have to be in LatLon (ExcersiseSessionId, pointing to ExcersiseSession). But from its name, i tend to think, you have LatLonId in the table ExcersiseSession

Collectives™ on Stack Overflow

MVC 3 Entitiy - Model first DB problems

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related