CODEWITHSUNDEEP
c#entity-frameworkef-code-firstmany-to-manyjunction-table
Bitz
Bitz

Reputation: 1148

Representing a Junction Table in Entity Framework

I am creating a schema where the following logic applies:

Basically, I've mapped the relationship as a many-to-many relationship using a junction table like so:

sqldbm

In mapping the chart in Code First EF6 (Using SQLite), I have the following objects:

public class Location
{
    [Key, DatabaseGenerated(DatabaseGeneratedOption.Identity)]
    public long LocationId { get; set; }

    [Required]
    public string Country { get; set; }

    [Required]
    public string CityOrProvince { get; set; }

    [Required]
    public string PlaceOrCity { get; set; }

    [Required]
    public string PostalCode { get; set; }
}

public class String
{
    [Key, DatabaseGenerated(DatabaseGeneratedOption.Identity)]
    public long StringId { get; set; }

    [Required]
    public string SearchString { get; set; }
}

public class LocationStringMapping
{
    [Required]
    public string LocationId { get; set; }

    [Required]
    public string StringId { get; set; }

    [Required]
    public DateTime DateScraped { get; set; }
}

I've based what I've done so far on conjecture as I cannot seem to find any concrete information on how a relationship such as this must be built. Normally I'd use a junction table, but that is in vanilla SQL. Is the implementation different in EF?

Am I going to have to cumbersomely manage the LocationStringMapping table by hand or is there some kind of implicit relationship model I don't know about?

Upvotes: 3

Views: 4908

Answers (1)

Slava Utesinov
Slava Utesinov

Reputation: 13488

public class Location
{
    public long LocationId {get;set;}
    public virtual ICollection<LocationStringMapping> LocationStringMappings {get;set;}
    //other
}

public class String
{
    public long StringId {get;set;}
    public virtual ICollection<LocationStringMapping> LocationStringMappings {get;set;}
    //other
}

public class LocationStringMapping
{
    [Key, Column(Order = 0)]
    public long LocationId { get; set; }
    [Key, Column(Order = 1)]
    public long StringId { get; set; }

    public virtual Location Location {get;set;}
    public virtual String String {get;set;}

    public DateTime DateScraped {get;set;}
}

Upvotes: 4

Related Questions