how to make one-to-one relation to many tables in EF?Ask Questions

 Posted on 28/07/2018 2:38:56 PM

I want to have one table with pictures for many other objects, lets say for Meals, Ingridents, ...

One Picture is for particular class (say Meal). This way I could have many tables with PictureId as FK, but can't apply this 2nd data annotation attribute.

public class Picture { [Key, ForeignKey("Ingridient"), ForeignKey("Meal")] //<---here I get error public int PictureId { get; set; } //properties public byte[] PictureData { get; set; } public string Name { get; set; } [Required] public virtual Ingridient Ingridient { get; set; } //1 - 1 [Required] public virtual Meal Meal { get; set; } //1 - 1 }

I think I don't follow convention but please tell me how to fix it. Why PictureId can't be a FK in many tables (Meals, Ingridients, ...)

Share On: facebook gplus twitter
Asked by Hardik Bera on 28/07/2018 2:38:56 PM Score: 375 points
Add Comment:


0 Answer

0 Corrected Answers

Post Your Answer


Existing Members

Sign in to your account
Email Address
...or Join us
Download, Vote, Comment, Publish.
Full Name
Email Address
I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the StoodQ newsletters
Guideline to answer a question:

Useful tips to submit your answer
Please read below guidelines before you submit your answer for question.

  • Read and understand question for which you are submitting your answer.
  • Try to avoid grammatical and spell mistake while answering.
  • Do not post any irrelevant information in your answer.
  • Explain your answer with example or any reference link to help who posted question.
  • If you find irrelevant question, please report it to support. Click here to contact support.
  • You agree to the privacy policy and terms of use to submit any contents.

Note: StoodQ is online developers community which helps developer for their difficulty, lets help them with your value contribution.