Primary foreign key in model class mvc

Mark Tabor

I have a registration table in which i have city and country as foreign key , as shown below , I have their own model classess as well but when i am writing a navigation property as city and country i my model class it gives error like

below are my model classes

and below is for country

4 Replies

Know the answer? Post it — somebody with the same question will find it here.

Nirmal Dayal6y ago
Hi Mark,

Below code help for you !

[Column("ServingId")] - Column Name want you want
[ForeignKey(typeof(NI_Serving))] - Model name for having primary key
public int ServingId { get; set; } - field name declare
Mageshwaran R6y ago
Hi,
please refer this link:
http://techfunda.com/howto/132/primary-key-and-foreign-key-relationship-in-model
Mark Tabor7y ago
[Display(Name ="City")]
public int City_Id { get; set; }
[ForeignKey("City")]
public virtual City Cities { get; set; }
public Boolean Remember_Token { get; set; }
[ForeignKey("Country")]
public Nullable Country { get; set; }

Now it works fine basically my city and coutry class was not set to public that was the reason but still i am not able to see these two items as drop down while creating a new listing for user regitration as shown below

How to convert this into the dropdown and gettign values from db table for city i have city name in my city table but in registration table i am saving the id of the city instead of name
Sai Kumar Koona7y ago
Hi Mark,

You need to declarate the forgin key attribute [ForeignKey("City")] to your CityId property i.e., it should be as follows
[ForeignKey("City")]

public int CityId { get; set; }

public City City { get; set; }

Please refer following link for more details
https://www.entityframeworktutorial.net/code-first/foreignkey-dataannotations-attribute-in-code-first.aspx