Foreign keys in entity framework 4.1

by

Both these approaches should work:

public class Product
{
    public int ProductId { get; set; }
    public string Name { get; set; }
    [ForeignKey("Category")]
    public string CId { get; set; }

    public virtual Category Category { get; set; }
}

Or:

public class Product
{
    public int ProductId { get; set; }
    public string Name { get; set; }
    public string CId { get; set; }

    [ForeignKey("CId")]
    public virtual Category Category { get; set; }
}

ForeignKeyAttribute is used to pair navigation property and foreign key property. It contains either the name of related navigation property or the name of related foreign key property.

More Related Contents:

  1. How to map table splitting in EF Code First?
  2. Model First with DbContext, Fails to initialize new DataBase
  3. Getting exact error type in from DbValidationException
  4. Introducing FOREIGN KEY constraint may cause cycles or multiple cascade paths – why?
  5. Ignoring a class property in Entity Framework 4.1 Code First
  6. Using Entity Framework (code first) migrations in production
  7. EF Code First – how to set identity seed?
  8. How to set default value for POCO’s in EF CF?
  9. Entity Framework 6 with SQLite 3 Code First – Won’t create tables
  10. Organizationally, where should I put common queries when using Entity Framework Code First?
  11. MetadataType problem
  12. How to store images using Entity Framework Code First CTP 5?
  13. Validate data using DataAnnotations with WPF & Entity Framework?
  14. What are ‘closures’ in .NET?
  15. How can I compress (/ zip ) and uncompress (/ unzip ) files and folders with batch file without using any external tools?
  16. Will the Garbage Collector call IDisposable.Dispose for me?
  17. In WPF, what are the differences between the x:Name and Name attributes?
  18. Linq to Entities – SQL “IN” clause
  19. When creating a new GUI, is WPF the preferred choice over Windows Forms? [closed]
  20. Why does a System.Timers.Timer survive GC but not System.Threading.Timer?
  21. .NET Events – What are object sender & EventArgs e?
  22. Release generating .pdb files, why?
  23. How do I convert an Excel serial date number to a .NET DateTime?
  24. Cannot install Windows SDK 7.1 on Windows 10
  25. How do I create an event handler for a programmatically created object in VB.NET?
  26. Ensuring json keys are lowercase in .NET
  27. Converting Raw HTTP Request into HTTPWebRequest Object
  28. Usage of EnsureSuccessStatusCode and handling of HttpRequestException it throws
  29. Why exactly isn’t MEF a DI/IoC container?
  30. Using a proxy with .NET 4.5 HttpClient

Leave a Comment