Understanding ForeignKey attribute in entity framework code first

by

The required side of the 1..0 relationship MemberDataSet should not have a FK to DeferredData. Instead, DeferredData‘s PK should also be a FK to MemberDataSet (known as shared primary key)

public class MemberDataSet
{
    [Key]
    [DatabaseGeneratedAttribute(DatabaseGeneratedOption.Identity)]
    public int Id { get; set; }

    public virtual DeferredData DeferredData { get; set; }
}

public class DeferredData
{
    // DeferredData.Id is both the PK and a FK to MemberDataSet
    [Key]
    [DatabaseGenerated( DatabaseGeneratedOption.None )]
    [ForeignKey( "MemberDataSet" )]
    public int Id { get; set; }

    [Required]
    public virtual MemberDataSet MemberDataSet { get; set; }
}

Fluent API:

modelBuilder.Entity<MemberDataSet>()
    .HasOptional( mds => mds.DeferredData )
    .WithRequired()
    .WillCascadeOnDelete();

More Related Contents:

  1. Entity Framework Code First – two Foreign Keys from same table
  2. Why use ICollection and not IEnumerable or List on many-many/one-many relationships?
  3. composite key as foreign key
  4. Validation failed for one or more entities while saving changes to SQL Server Database using Entity Framework
  5. Entity Framework DateTime and UTC
  6. Is it possible to capture a 0..1 to 0..1 relationship in Entity Framework?
  7. Does Entity Framework Code First support stored procedures?
  8. Fluent API, many-to-many in Entity Framework Core
  9. Self-referencing many-to-many recursive relationship code first Entity Framework
  10. EF4 Code First: how to add a relationship without adding a navigation property
  11. Entity Framework Code First Date field creation
  12. Change foreign key constraint naming convention
  13. Create association on non-primary key fields with Entity Framework 4.1 Fluent API
  14. How to remove child one to many related records in EF code first database?
  15. LINQ To Entities does not recognize the method Last. Really?
  16. Bulk-deleting in LINQ to Entities
  17. Entity Framework And Business Objects
  18. Self referencing loop detected – Getting back data from WebApi to the browser
  19. Entity-framework code is slow when using Include() many times
  20. The operation cannot be completed because the DbContext has been disposed using MVC 4
  21. Can we have table without primary key in entity framework?
  22. ASP.NET Core API only returning first result of list
  23. DbContext discard changes without disposing
  24. Group by with multiple columns using lambda
  25. Keyword Not Supported: Metadata
  26. Entity Framework Code First: How can I create a One-to-Many AND a One-to-One relationship between two tables?
  27. Entity Framework: Duplicate Records in Many-to-Many relationship
  28. Register AspNetCore 2.1 Identity system with DbContext interface
  29. Oracle Entity Framework – Generate Entity From Tables in Different Schema
  30. Entity framework – get entity by name

Leave a Comment