Change table schema on middle table generated by Entity Framework

Question

I have got model with M:N relation like this:

[Table("Messages", Schema = "public")]
public class Message
{

    public int Id  { get; set; }
    public virtual IList<Phone> Phones{ get; set; }

}

[Table("Phones", Schema = "public")]
public class Phone
{

    public int Id  { get; set; }
    public virtual IList<Message> Messages{ get; set; }

}

So EF generates middle table for me... But default schema of table is not public (it is what i need), but still dbo. And gives me error: schema "dbo" does not exist.

How can I change table schema of MessagePhone table, without creating MessagePhone model class?

score 2 · Accepted Answer · answered May 14 '13 at 23:12

I think it is doable. You will have to override OnModelCreating of your DbContext class and configure with fluent API:

 protected override void OnModelCreating(DbModelBuilder modelBuilder)
 {
     modelBuilder.Entity<Message>().HasMany<Phone>(m => m.Phones).WithMany(p => p.Messages).Map
           (
            x =>
               {
                  x.ToTable("MessagePhone", "public");
               }
           );
 }

You will have to test this, not sure i got all of the syntax right.. Don't have VS here to try it.

nice effort without VS :-) – phil soady May 15 '13 at 16:15 — phil soady, May 15 '13 at 16:15

score 0 · Answer 2 · edited May 23 '17 at 12:13

0

Have you tried it like this?

Basically you create the middle table yourself, and have many-to-one relationships to it. That way, you can specify anything you like about it. The downside is of course, that you cannot just handle the relation like a collection.

edited May 23 '17 at 12:13

Community

1
1

answered May 14 '13 at 23:13

Jan Dörrenhaus

6,581
2
34
45

Change table schema on middle table generated by Entity Framework

2 Answers2