Entity Framework Many to many through containing object

by

You can map private properties in EF code-first. Here is a nice description how to do it. In your case it is about the mapping of Subscriber._subscribedList. What you can’t do is this (in the context’s override of OnModelCreating):

modelBuilder.Entity<Subscriber>().HasMany(x => x._subscribedList);

It won’t compile, because _subscribedList is private.

What you can do is create a nested mapping class in Subscriber:

public class Subscriber : IEntity
{
    ...
    private ICollection<HelpChannel> _subscribedList { get; set; } // ICollection!

    public class SubscriberMapper : EntityTypeConfiguration<Subscriber>
    {
        public SubscriberMapper()
        {
            HasMany(s => s._subscribedList);
        }
    }
}

and in OnModelCreating:

modelBuilder.Configurations.Add(new Subscriber.SubscriberMapping());

You may want to make _subscribedList protected virtual, to allow lazy loading. But it is even possible to do eager loading with Include:

context.Subscribers.Include("_subscribedList");

More Related Contents:

  1. ASP.NET MVC – Attaching an entity of type ‘MODELNAME’ failed because another entity of the same type already has the same primary key value
  2. Why does the EF 6 tutorial use asynchronous calls?
  3. How to add/update child entities when updating a parent entity in EF
  4. Validation failed for one or more entities while saving changes to SQL Server Database using Entity Framework
  5. Filter/Search using Multiple Fields – ASP.NET MVC
  6. Non-static method requires a target
  7. Using Asp.Net Identity DataBase first approach
  8. Implementing Audit Log / Change History with MVC & Entity Framework
  9. How to do a Bulk Insert — Linq to Entities
  10. How to group by on 2 child entities and get total of both this child entities?
  11. LINQ to Entities does not recognize the method ‘System.Web.Mvc.FileResult’
  12. When should I create a new DbContext()
  13. Questions about Entity Framework Context Lifetime
  14. The operation cannot be completed because the DbContext has been disposed using MVC 4
  15. Is Deferred Execution in Asp.net MVC View a very bad thing?
  16. Entity vs Model vs View Model
  17. Why is Asp.Net Identity IdentityDbContext a Black-Box?
  18. Export Model to DataTable
  19. ASP.NET Identity – Multiple object sets per type are not supported
  20. How to I apply filter while paginating in Asp.net MVC and entity Framework?
  21. Set database timeout in Entity Framework
  22. Only primitive types or enumeration types are supported in this context
  23. Async PartialView causes “HttpServerUtility.Execute blocked…” exception
  24. Keyword Not Supported: Metadata
  25. Entities VS Domain Models VS View Models
  26. How to create custom additional fields in UserProfile in MVC4
  27. Where to convert business model to view model?
  28. Repository Pattern, POCO, and Business Entities
  29. MVC 4 – Many-to-Many relation and checkboxes
  30. .NET Managing Layers Relationships

Leave a Comment