Primary foreign key in model class mvc

Question

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

Nirmal Dayal · Answer

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 R · Answer

Hi, please refer this link: http://techfunda.com/howto/132/primary-key-and-foreign-key-relationship-in-model

Mark Tabor · Answer

[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 Koona · Answer

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