How to change the type of the persisted class in an inherited model using the EntityFramework

Question

How to change the type of the persisted class in an inherited model using the EntityFramework

Navigation

#1 by (2 votes)

4

I have the following inheritance classes schema, as an example:

public class Veiculo
{
    public int Id { set; get; }
    public string Descricao { set; get; }
}

public class Moto : Veiculo { }

public class Carro : Veiculo { }

That generates the database with the Veiculo table and the columns Id , Descricao and Discriminator .

I have a record that its Discriminator field is set to Moto . That is, when I registered this record I did this using a Moto reference.

How do I transfer this record from type Moto to Carro ?

c# .net entity-framework entity-framework-6

asked by anonymous 02.05.2014 / 04:27

1 answer

How do I access the indexes of a vector returned by a method in java? How can I get the id in classes with equal names?

score 2 · Accepted Answer

Momentarily I solved it manually.

var sql = " Update Veiculo Set Discriminator = @Tipo Where Id = @Id ";

myDbContext.Database.ExecuteSqlCommand(sql,
    new SqlParameter("Tipo", "Carro"),
    new SqlParameter("Id", moto.Id));