Using Multiple Schemas with Entity Framework 6

Question

I am starting to work with the Entity Framework, and I need some example of how I can define for my tables the Schema’s that each one is contained. My database was created as in the example:

/*schema [Pes] -> relativo ao contexto Pessoa*/
Pes.Pessoa; 
Pes.PessoaFisica; 
Pes.EstadoCivil;  

/*schema [Sis] -> relativo ao contexto do Sistema*/
Sis.Versao;
Sis.Configuracao;
Sis.Usuario;

Starting from this structure, how can I pass to the Entityframework that table Versao defined in the Schema [Sis]?

Answer 1

You can use the Dataannotation Table for that reason

using System.ComponentModel.DataAnnotations.Schema;

[Table("Pes.Pessoa")]
public class Pessoa
{ ... }

Or, if you use Fluentapi, you can do it this way

public class Contexto : DbContext
{
    public DbSet<Pessoa> Pessoas { get; set; }

    protected override void OnModelCreating(DbModelBuilder modelBuilder)
    {
        modelBuilder.Entity<Pessoa>().ToTable("Pessoa", "Pes");            
    }
}

You can also set the schema standard, thus

 modelBuilder.HasDefaultSchema("DefaultSchema");