Entity Framework - adding additional properties to model

Question

I'm new to the Entity Framework but I managed to create a database and several models.

Here's my Rider model:

namespace Dash.Data
{
    public partial class Rider
    {
        public int ID { get; set; }
        public int AccountID { get; set; }
        public string Name { get; set; }
    }
}

I also have another partial class to include additional properties:

namespace Dash.Data
{
    public partial class Rider
    {
        public Room Room { get; set; }
    }
}

And this is my context class:

public class DashContext : DbContext
{
    public DashContext()
        : base(Constants.ConnectionString)
    {
        this.Configuration.LazyLoadingEnabled = true;
        this.Configuration.ProxyCreationEnabled = false;
    }

    protected override void OnModelCreating(DbModelBuilder modelBuilder)
    {
        Database.SetInitializer<DashContext>(null);
    }

    public DbSet<Rider> Riders { get; set; }
}

However, when initializing my context I receive this error:

System.InvalidOperationException: 'Unable to determine the principal end of an association between the types 'Dash.Game.Room' and 'Dash.Data.Rider'. The principal end of this association must be explicitly configured using either the relationship fluent API or data annotations.'

Now, I do understand it's thinking that Dash.Game.Room is another field, but I don't want it to treat it like a field, but as a property I'm adding so the class can interact with my program. I want to include the columns inside my first class, and the additional properties in the other one.

How can I achieve this?

You must register Room as a complex type if it contains properties that are mapped to database fields. It's not clear from your question if it does. — Gert Arnold
– Gert Arnold, Commented Apr 9, 2017 at 8:21
By the way, you won't get lazy loading if ProxyCreationEnabled is disabled. — Gert Arnold
– Gert Arnold, Commented Apr 9, 2017 at 8:25

Michael Puckett II · Accepted Answer · 2017-04-09 05:53:03Z

1

public partial class Rider
{
    [NotMapped]
    public Room Room { get; set; }
}

answered Apr 9, 2017 at 5:53

Michael Puckett II

6,7795 gold badges28 silver badges49 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Entity Framework - adding additional properties to model

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related