Retrieve data from db with foreign key constraint

Question

I am getting an error while fetching data from db.The error is like this:-

{"Invalid column name 'Amount_Value'.\r\nInvalid column name 'Amount_Currency'.\r\nInvalid column name 'Amount_Value'.\r\nInvalid column name 'Amount_Currency'."}

Here is my main model of "Deals":-

public class Deal {

   public long ID { get; set; }

   [StringLength(1024),Required]
    public string Title { get; set; }

   public Client Party { get; set; }
   public long PartyID { get; set; }


   public DateTime Created { get; set; }
   public long Version { get; set; }

   [DataType(DataType.MultilineText)]
   public string Notes { get; set; }

   public Money Amount { get; set; }
   public DealKindEnum Mode { get; set; }
  }

Here "Money" is another class which is like this:-

public class Money
{
 [DataType(DataType.Currency)]
 public double Value { get; set; }
 public string Currency { get; set; }
}

I am getting error while using this query:--

var query = from client in db.Clients
 join ra in db.Deals on client.ID equals ra.PartyID
 where (ra.ID == id || id == 0)
 select ra;

So Money is not an Entity => doesn't exist in db ? If it is, I think your property should be virtual. public virtual Money Amount {get;set;} If it's not, you should mark with NotMappedAttribute ([NotMapped] on property) — Raphaël Althaus
– Raphaël Althaus, Commented Apr 2, 2014 at 12:40

Raphaël Althaus · Accepted Answer · 2014-04-02 13:10:12Z

1

EF can't do anything with properties which are not in database. From your comment, Money is not an entity.

So you have to mark the property in Deal class as NotMapped

[NotMapped]
public Money Amount { get; set; }

And EF won't try to get anything from db while querying. Of course, you won't have anything in Amount property, but how could you if it's not in db...

answered Apr 2, 2014 at 13:10

Raphaël Althaus

60.6k6 gold badges106 silver badges127 bronze badges

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

3 Comments

user3206357 Over a year ago

Thanks it worked and please see my another question which I edited in this question only.

Raphaël Althaus Over a year ago

@AkankshaT you should rather let your question as it was and ask a new one. Or anyone looking at this one won't understand anything !

user3206357 Over a year ago

Sorry.I am doing that.

Collectives™ on Stack Overflow

Retrieve data from db with foreign key constraint

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related