Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Entity Framework - Reuse Complex Type

I have an Entity in Code First Entity framework that currently looks like this:

public class Entity
{
    // snip ...

    public string OriginalDepartment { get; set; }
    public string OriginalQueue { get; set; }

    public string CurrentDepartment { get; set; }
    public string CurrentQueue { get; set; }
}

I would like to create Complex Type for these types as something like this:

public class Location
{
    public string Department { get; set; }
    public string Queue { get; set; }
}

I'd like to use this same type for both Current and Original:

public Location Original { get; set; }
public Location Current { get; set; }

Is this possible, or do I need to create two complex types CurrentLocation and OriginalLocation?

public class OriginalLocation
{
    public string Department { get; set; }
    public string Queue { get; set; }
}

public class CurrentLocation
{
     public string Department { get; set; }
     public string Queue { get; set; }
}
like image 327
Dismissile Avatar asked Mar 29 '12 18:03

Dismissile


1 Answers

It is supported out of box, you do not need to create two complex types.

You can also configure your complex types explicitely with model builder

modelBuilder.ComplexType<Location>();

To customize column names, you should configure them from parent entity configuration

public class Location
{
    public string Department { get; set; }
    public string Queue { get; set; }
}

public class MyEntity
{
    public int Id { get; set; }
    public Location Original { get; set; }
    public Location Current { get; set; }
}

public class MyDbContext : DbContext
{
    protected override void OnModelCreating(DbModelBuilder modelBuilder)
    {
        modelBuilder.ComplexType<Location>();

        modelBuilder.Entity<MyEntity>().Property(x => x.Current.Queue).HasColumnName("myCustomColumnName");
    }
}

This will map MyEntity.Current.Queue to myCustomName column

like image 103
archil Avatar answered Sep 22 '22 00:09

archil