how to set foregin key in model

Question

0.00/5 (No votes)

See more:

hi to all,
Here i want to set foregin key for employee id but while running code first migration i got a error.How to resolve it.

MODEL DESCRIPTION:-

C#

[Required]
[ForeignKey("Employee_Id")]
public int Employee_Id { get; set; }

ERROR DESCRIPTION:-
The property 'Employee_Id' cannot be configured as a navigation property. The property must be a valid entity type and the property should have a non-abstract getter and setter. For collection properties the type must implement ICollection<t> where T is a valid entity type.

Posted 1-Aug-14 1:29am

JOTHI KUMAR Member 10918227

Add a Solution

3 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Kunjammu · Answer 1 · 2014-08-01T01:42:00

Solution 1

C#

[Required]
[ForeignKey("TableName")]
public int Employee_Id { get; set; }

use tablename inside ForeignKey("----")

Posted 1-Aug-14 1:42am

Kunjammu

Comments

JOTHI KUMAR Member 10918227 1-Aug-14 7:46am

The ForeignKeyAttribute on property 'Employee_Id' on type 'Tata.BusinessEntities.Entities.User' is not valid. The navigation property 'tblUser' was not found on the dependent type 'Tata.BusinessEntities.Entities.User'. The Name value should be a valid navigation property name.
Now i got this error

Kunjammu 1-Aug-14 7:49am

Did u set foriegn key in table( i mean in the database)

JOTHI KUMAR Member 10918227 1-Aug-14 7:56am

hey table not created yet bcz i'm using entity frame work so table was created automatically

Kunjammu 1-Aug-14 8:12am

please try in reverse way. then it will work

JOTHI KUMAR Member 10918227 1-Aug-14 8:18am

ok wait i will try and tell to you ok

Ashok8033 · Answer 2 · 2014-08-01T02:21:00

public class Customer
{
[Key]
public int CustomerId { get; set; }

[StringLength(20)]
[Required]
public string CustomerName { get; set; }

}

public class Address
{
[Key]
public int AddressId { get; set; }

[DataType(DataType.Text)]
public string Street { get; set; }

//Foreign Key
public int CustomerId { get; set; }
public virtual Customer Customer { get; set; }

}

Ashok8033 · Answer 3 · 2014-08-01T02:30:00

Solution 3

u can define customer model in dbset as fellow

public class LocalContext : DbContext
{
public LocalContext() : base("test")
{

//Database.SetInitializer<LocalContext>(null);
}

public DbSet<Customer> Customers { get; set; }
public DbSet<Address> Addresses { get; set; }

}

Posted 1-Aug-14 2:30am

Ashok8033

Comments

Nirav Prabtani 1-Aug-14 9:16am

Dont post more than one answer, just edit answer if you want.