asp.net entity framework code first foreign key not retrieve

Question

I'm trying to retrieve company with trades. I have included the entites and the retrieve method. As shown, the companies are inside trades already.

//company entity
public class Companies
{
  public int id { get; set; }
  public string companyID { get; set; }
  public string companyName { get; set; }
  public bool companyMointor { get; set; }   
}

//trade entity
public class Trade
{
  public int id { get; set; }
  public DateTime tradeDate { get; set; }
  public double tradePrice { get; set; }
  public int tradeQuantity  { get; set; }
  public Companies tradeCompany { get; set; }
  public int type { get; set; }

  public types tradeType 
  {
    get { return (Entities.types)type; }
    set { type = (int) value; }
  }
}

//methods to retrieve
public List<Trade> getTrade()
{
  List<Trade> trades = (from t in dbContext.trades
                        orderby t.tradeDate descending             
                        select t).ToList();
  return trades;
}

What is your problem, is the company variable empty? in the trades list? — TBohnen.jnr
– TBohnen.jnr, Commented Nov 22, 2011 at 14:22

Eranga · Accepted Answer · 2011-11-22 14:35:37Z

1

Use the Include method to eager load navigational properties.

public List<Trade> getTrade()
{
    List<Trade> trades=dbContext.trades.Include(t => t.tradeCompany)
      .OrderBy(t => t.tradeDate).ToList();

    return trades;
}

Edit: If you are using ObjectContext API try the following

public List<Trade> getTrade()
{
    List<Trade> trades=dbContext.trades.Include("tradeCompany")
      .OrderBy(t => t.tradeDate).ToList();

    return trades;
}

edited Nov 22, 2011 at 14:35

answered Nov 22, 2011 at 14:27

Eranga

32.5k5 gold badges100 silver badges98 bronze badges

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

6 Comments

user2514963 Over a year ago

Cannot convert lambda expression to type 'string' because it is not a delegate type

user2514963 Over a year ago

A specified Include path is not valid. The EntityType 'Shares.Entities.Trade' does not declare a navigation property with the name 'Companies'.

Eranga Over a year ago

@user974459 Did you replace tradeCompany parameter with Companies?

Eranga Over a year ago

@user974459 that is the problem. You need to give the name of the navigational property as a string. In your code you have named it as tradeCompany. So use that.

user2514963 Over a year ago

The underlying provider failed on Open.

|

TBohnen.jnr · Accepted Answer · 2011-11-22 14:34:56Z

1

change your gettrade method to have an include line:

//methods to retrieve 
    public List<Trade> getTrade() 
    { 
        List<Trade> trades=(from t in dbContext.trades 
                .Include("tradeCompany")
                orderby t.tradeDate descending 

                select t).ToList(); 
        return trades; 
    }

answered Nov 22, 2011 at 14:34

TBohnen.jnr

5,1191 gold badge22 silver badges26 bronze badges

1 Comment

user2514963 Over a year ago

A specified Include path is not valid. The EntityType 'Shares.Entities.Trade' does not declare a navigation property with the name 'Companies'.

Collectives™ on Stack Overflow

asp.net entity framework code first foreign key not retrieve

2 Answers 2

6 Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

6 Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related