ADO.Net EF – how to define foreign key relation in model first approach?

by

First of all your model is probably wrong. ConsoleType and Game is not in one-to-one relation (unless you have single game for each console type). I expect 1 console can have multiple games. So it should be one-to-many. In reality game can be released on multiple platforms so it should be many-to-many.

You got unvanted column because your relation between ConsoleType and Game doesn’t know that it should use Console property as a foreign key. This happens if you use independent association. Independent associations are used by default when you draw them from one entity to other entity in Entity designer. You must use foreign key association.

Start with this set up (draw association from ConsoleType to Game – you must have one-to-many relation):

enter image description here

Select relation between ConsoleType and Game an in properties click on Referential Constraint:

enter image description here

In Referential Constraint dialog just set up relation:

enter image description here

Save your model and generate database again.

More Related Contents:

  1. Entity Framework and Connection Pooling
  2. Entity Framework 4 selective lazy loading properties
  3. There is already an object named in the database
  4. The object ‘DF__*’ is dependent on column ‘*’ – Changing int to double
  5. “Cannot drop database because it is currently in use”. How to fix?
  6. Normalization in database management system
  7. Database development mistakes made by application developers [closed]
  8. Copying PostgreSQL database to another server
  9. Do you use source control for your database items? [closed]
  10. Entity Framework VS LINQ to SQL VS ADO.NET with stored procedures? [closed]
  11. Disable lazy loading by default in Entity Framework 4
  12. SQL Server Connection Strings – dot(“.”) or “(local)” or “(localdb)”
  13. Synchronous database queries with Node.js
  14. ADO.NET DbContext Generator vs. ADO.NET Poco Entity Generator (ObjectContext)
  15. How to include a child object’s child object in Entity Framework 5
  16. How can I avoid SQL injection attacks?
  17. What is the recommended way to delete a large number of items from DynamoDB?
  18. Supertype-subtype database design
  19. Storing time-series data, relational or non?
  20. Good Free Alternative To MS Access [closed]
  21. Creating dynamic queries with entity framework
  22. What’s wrong with nullable columns in composite primary keys?
  23. Convert String ISO-8601 date to oracle’s timestamp datatype
  24. EF Code First giving me error Cannot insert explicit value for identity column in table ‘People’ when IDENTITY_INSERT is set to OFF. [duplicate]
  25. Are Cloud Firestore queries still case sensitive?
  26. How should you build your database from source control?
  27. Entity Framework v2 doesn’t support sql 2000?
  28. The type or namespace name ‘DbContext’ could not be found [closed]
  29. DB design for microservice architecture [closed]
  30. Strongly-Typed ASP.NET MVC with ADO.NET Entity Framework [closed]

Leave a Comment