Update inherited Entity in Entity Framework 7

Question

I have the following BaseballDbContext class:

public class BaseballDbContext : DbContext
{
   public DbSet<BaseballTeam> teams { get; set; }

   protected override void OnModelCreating(ModelBuilder modelBuilder)
   {
       modelBuilder.Entity<Hitter>();
       modelBuilder.Entity<Pitcher>();
   }
}

And my model classes are:

public class BaseballTeam
{
    public int Id { get; set; }
    public string teamName { get; set; }
    public List<BaseballPlayer> players { get; set; }
}

public abstract class BaseballPlayer
{
    public int Id { get; set; }
    public int age { get; set; }
    public string name { get; set; }
}

public class Hitter : BaseballPlayer
{
    public int homeruns { get; set; }
}

public class Pitcher : BaseballPlayer
{
    public int strikeouts { get; set; }
}

Initially seeded data in the players table:

Now I want to update name and homeruns property of one of the hitters:

BaseballTeam team = _ctx.teams.Include(q => q.players).FirstOrDefault();
Hitter hitter = team.players.OfType<Hitter>().FirstOrDefault();
hitter.name = "Tulowitzki";  //that property will be updated
hitter.homeruns = 399;       //but that will not :(

int i = team.players.FindIndex(q => q.Id == hitter.Id);
team.players[i] = hitter;

_ctx.Update(team);
_ctx.SaveChanges();

After I run the code only player's name got update, but not the homeruns property:

How to update property of both child and parent class ?

This might be worth a shot: _ctx.Entry(team).State = EntityState.Modified put it before the update call. — Cicero
– Cicero, Commented Apr 7, 2016 at 23:27
As I understand that issue is already fixed, and will be available with next release github.com/aspnet/EntityFramework/commit/… — koryakinp
– koryakinp, Commented Apr 8, 2016 at 17:37

Community · Accepted Answer · 2017-05-23 12:26:04Z

2

From this answer but this is a workaround: Save changes to child class properties using base class query with Entity Framework TPH patten :

Do Not track changes using AsNoTracking()

using (var context = new BaseballDbContext())
{
    var team = context.teams.Include(q => q.players).AsNoTracking().FirstOrDefault();
    var hitter = team.players.OfType<Hitter>().FirstOrDefault();
    hitter.name = "Donaldson";
    hitter.homeruns = 999;
    context.Update(team);
    context.SaveChanges();
}

I think you should have a look at the opened issues related to inheritance and may be open a new issue

edited May 23, 2017 at 12:26

CommunityBot

11 silver badge

answered Apr 8, 2016 at 2:57

Thomas

30.5k6 gold badges99 silver badges143 bronze badges

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

1 Comment

Thomas Over a year ago

Sure... That s why maybe you have to open an issue... I think because you are not tracking the changes, when you perform the update the context verify every property on every object but really not sure

Collectives™ on Stack Overflow

Update inherited Entity in Entity Framework 7

1 Answer 1

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related