Parameterize Schema in Entity Framework 6

Question

I have multiple object and some of them go to one schema "NewObjects" and the other go to "OldObjects" I want to be able to make what the NewObjects Schema is configurable from config file. Is there a way? Here is what I have.

namespace IDJC.Domain
{


    [Table("Agency", Schema = "NewObjects")]
    public class Agency
    {
        public int AgencyId { get; set; }
        public string AgencyName { get; set; }
    }
}

milanio · Accepted Answer · 2015-02-24 21:32:36Z

1

+50

Yes, through fluent api. Check the part: Mapping an Entity Type to a Specific Table in the Database:

For example, if you create a setting in your project (through Properties->Settings) name MySchemaName, you will be able to access it in your DbContext derived class. So when you override OnModelCreating you will be able to do something like:

modelBuilder.Entity<Agency>()  
    .ToTable("Agency", Properties.Settings.Default.MySchemaName);

answered Feb 24, 2015 at 21:32

milanio

4,28227 silver badges34 bronze badges

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

1 Comment

milanio Over a year ago

:) no worries, hope it helps.

Collectives™ on Stack Overflow

Parameterize Schema in Entity Framework 6

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related