Using multiple Schemas with Entity Framework 6

Question

Using multiple Schemas with Entity Framework 6

Navigation

#1 by (2 votes)

0

I'm starting to work with the Entity Framework, and I need some example of how I can define for my tables the Schemas that each 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;

From this structure, how can I pass to the EntityFramework that the Versao table is defined in Schema [Sis] ?

sql-server c# entity-framework-6

asked by anonymous 07.10.2016 / 21:55

1 answer

Problem with jQuery fadeOut! Error in Git help me please

score 2 · Accepted Answer

You can use DataAnnotation Table for this

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 define the default schema in this way

 modelBuilder.HasDefaultSchema("DefaultSchema");