Explicitly map interface member in Entity Framework 7

c# entity-framework entity-framework-core

Question

I'm attempting to map a class which looks like below but I'm getting an exception regarding the Facility.Projects property being an interface.

The property Facility.Projects is of an interface type IProject. If it is a navigation property manually configure the relationship for this property by casting it to a mapped entity type, otherwise ignore the property from the model.

public class Facility : BaseData
{
    [ForeignKey("ClientId")]
    public Client Owner { get; set; }

    public List<IProject> Projects { get; protected set; }

    public Facility()
    {
        Initialize();
    }

    private void Initialize()
    {
        Projects = new List<IProject>();
    }
}

I've mapped other properties via the OnModelCreating method for the DbContext class that Facility is mapped to but I'm not really seeing anything that seems like the right spot to cast this other than HasColumnType which also appears wrong. 

public class FacilityRepository : BaseRepository<Facility>, IFacilityRepository
{
    protected override void OnModelCreating(ModelBuilder modelBuilder)
    {
        base.OnModelCreating(modelBuilder);

        modelBuilder
            .Entity<Client>()
            .Property(f => f.Id)
            .ForSqliteHasColumnName("ClientId");

        modelBuilder
            .Entity<Project>()
            .Property(x => x.Id)
            .ForSqliteHasColumnName("ProjectId");


        // area where I've tried and failed to find a good spot to do some manual casting
        modelBuilder
            .Entity<Facility>()
            .Property(f => f.Projects)
            .HasColumnType<Project>(new PropertyBuilder());
    }
}

Can anyone point me in the right direction? I've not seen anything in the documentation that might help? Or should I, by rule, not be doing this at all?

1
2
8/22/2016 8:47:41 PM

Fastest Entity Framework Extensions

Bulk Insert
Bulk Delete
Bulk Update
Bulk Merge

Accepted Answer

To do a manual mapping of a one-to-many relationship (this example is just exposing the children on the parent, not vice versa), you can set this up as follows, and then it's pretty straightforward where the cast should be:

        modelBuilder.Entity<ProjectState>()
            .HasMany(h => (ICollection<ProjectRoleState>)h.ProjectRoleStates)
            .WithOne()
            .HasForeignKey(p=>p.ProjectGuid);
3
1/28/2017 10:12:00 PM

Related Questions

Saving AutoMapper mapped Collections of Entities using Entity Framework

Well, I think attaching a graph of entities to the DbContext is not the correct approach, because it forces you to write a lot of code to fix entity states to prevent EF from duplicating your entities....A safer and simpler approach IMO is to load your Region entity from the DbContext, then add/remove Country entities from the Countries collection,...
.net automapper c# entity-framework entity-framework-6
asked by cchdev

How to get Table Name of mapped entity in Entity Framework Core

Using the ...Microsoft.EntityFrameworkCore.Relational... package in 2.X:...var mapping = dbContext.Model.FindEntityType(typeof(YourEntity)).Relational(); var schema = mapping.Schema; var tableName = mapping.TableName; ...This assumes that ...dbContext... is a instance of class that inherits from ...DbContext... and that you have ...YourEntity... co...
.net-core asp.net-core entity-framework-core
asked by Krzysztof Branicki

How to map entities with inheritance - Entity Framework Core 2.0

I have a .net core 2.0 project and I'm using Entity Framework Core 2.0 I want to map an entity that has an inheritance and this inheritance has an inheritance too ...My entity which I want to map in ...[Domain.Project]...:...public class Customer : BaseEntity { public Customer(Name name, DateTime? birthDay, Email email, string password, List<Cr...
.net-core c# entity-framework-core
asked by Italo José

Web Api: Return JSON with EF Included Member Field Count but not Member Object Data

Scenario: Complaint object can have many Votes. In the GET request for All Complaints, I want to return the Vote Count, and not each individual vote object with the Complaint in the API response....Here's the main classes:...//Model: Complaint.cs public class Complaint { public int Id { get; set; } public string Summary { get; set; } pu...
asp.net-core-webapi entity-framework-core
asked by user3612027

Entity Framework Core Explicitly loading related data according to Type of Class

Instead of separate ...Reference... / ...Collection... methods, you can use the more general ...Navigation... method. Unfortunately it has no overload with lambda expressions, so you need to extract the property name manually. Since your method design does not support nested properties, you can get that information from lambda expression body, cast...
.net-core c# entity-framework entity-framework-core
asked by Ivan Stoev

Entity Framework 6 mapping a custom SQL query to an Entity

There are several ways to accomplish what you want to do, using either Entity Framework only or extra tools like ...Dapper...Entity Framework Only:...First you can use ...Linq... to extract the data, I'll look something like this:...var list = from s in Samples join l in SampleLocations on s.Id equals l.LocationId ...
asp.net-mvc c# entity-framework entity-framework-6
asked by Roy Sanchez

No method to map entity to table in entity framework core

You can use the below approach. You have to use ...Table... data annotation....DBContext:...public virtual DbSet<Article> Article { get; set; } protected override void OnModelCreating(ModelBuilder modelBuilder) { base.OnModelCreating(modelBuilder); modelBuilder.Entity<Article>(b => { b.Property(e => e.Property1).HasDefaultValu...
.net c# entity-framework-core
asked by vivek nuna

Net Core: Create Generic Repository Interface Id Mapping for All Tables Auto Code Generation

With T4 Research, answer below. People are free to edit/optimize....<#@ template debug="false" hostspecific="true" language="C#" #> <#@ assembly name="System.Core" #> <#@ import namespace="System" #> <#@ import namespace="System.IO" #> <# DirectoryInfo d = new DirectoryInfo(Path.GetDirectoryName(this.Host.TemplateFile) + @"\Scaffold"); Fil...
.net-core asp.net-core c# entity-framework-core t4
asked by jerrythomas38

Entity Framework Core: how to map different object instances to the same entity?

How could I map different object instances of an entity to the same row into a datatable using Entity Framework Core? ...In another word, how does Entity Framework Core compare entities which are not yet inserted into a database (otherwise I guess it only has to compare the primary key) and figures out that two objects should be mapped to a single...
c# entity-framework-core
asked by XavierAM

Entity Framework - error: the principal end of this association must be explicitly configured

I have a project built on the top of the ASP.NET MVC 5 framework. I am using Entity Framework 6.2 to access data from my database....I have the following two models...public class Entity<T> where T : struct { [Key] public T Id { get; set; } } public class User : Entity<int> { public string FirstName { get; set; } public int Catego...
asp.net-mvc asp.net-mvc-5.1 entity entity-framework entity-framework-6
asked by user12310517

Fastest Entity Framework Extensions

Bulk Insert
Bulk Delete
Bulk Update
Bulk Merge
View more on Stack Overflow

Prime Library

Performance

Expression Evaluator

More Projects...

Related

Licensed under: CC-BY-SA with attribution
Not affiliated with Stack Overflow
Licensed under: CC-BY-SA with attribution
Not affiliated with Stack Overflow