Entity Framework Reverse POCO Generator - Custom Navigation Property

Question

I'm currently working with a legacy database that's missing a relationship between two tables.

Basically, I have a table of 'Items' and a table of 'Vendors' with their own respective primary keys.

However, the 'Items' table contains a field 'VendorNumber' that is used to map to the 'Vendors' table . This relationship is not enforced in the database, but I'd still like to use 'Vendors' as a navigation property from the 'Items'.

I'm using the 'Reverse POCO Generator', but I'm unable to figure out how to 'force' it to generate the navigation property.

I've tried making another 'ItemConfiguration' partial class that includes the property, but as it's set in the 'ItemConfiguration' constructor, I'm unable to achieve the desired functionality.

Any assistance/insight would be greatly appreciated!

You don't need to use 'reverse POCO generator', just use Fluent API to setup the relationship (msdn.microsoft.com/en-us/library/jj591620(v=vs.113).aspx) — hyankov

TheSoftwareJedi TheSoftwareJedi · Accepted Answer · 2018-06-13T19:15:50

Create a partial class and add the relationship to the Vendor from Item

public partial class Item
{
    public virtual Vendor ItemVendor { get; set; } 
}

Create a partial class for the configuration and inplement the InitializePartial method that the generated partial class calls from the constructor

public partial class ItemConfiguration : System.Data.Entity.ModelConfiguration.EntityTypeConfiguration<Item>
{
    partial void InitializePartial()
    {
        HasOptional(a => a.ItemVendor).WithMany().HasForeignKey(a => a.VendorNumber).WillCascadeOnDelete(false); 
    }
}

Your Item class will now have a ItemVendor field filled out.

Entity Framework Reverse POCO Generator - Custom Navigation Property

1 Answers