Table name with dot in CodeFirst

Question

I thought that it was a good idea to prefix some of my tables with the name of the area:

MyNewSubProject.Table1
MyNewSubProject.Table2

Unfortunately when I'm going to map these tables with Entity Framework Code First with the model builder:

modelBuilder.Entity<Entity>().ToTable("MyNewSubProject.Table1");

Throws the exception:

(System.Data.Entity.Infraestructure.DbUpdateException)
{"Invalid object name 'MyNewSubProject.Table1'."}

The table name is correct. I've tried to add the schema but no luck. If I remove the dot everything goes great.

Any way to use the dot?

Thanks ;)

Do you imagine to see the dot in SQL or in C# ?

Henk Holterman
– Henk Holterman

2012-03-02 08:20:32 +00:00
Commented Mar 2, 2012 at 8:20 — Henk Holterman
– Henk Holterman, Commented Mar 2, 2012 at 8:20

ntziolis · Accepted Answer · 2012-03-02 08:18:57Z

3

Apparently the DDL commands don't properly wrap the object identifiers.

Try wrapping the Table name in [MyNewSubProject.Table1].

This was a know issue, I assumed this was fixed by now:
http://social.msdn.microsoft.com/Forums/en/adodotnetentityframework/thread/9c5642ad-3e4e-496f-9721-059071d653e3

UPDATE

Apparently you can set the schema seperately like this:

modelBuilder.Entity<Entity>().ToTable("Table1", "MyNewSubProject");

edited Mar 2, 2012 at 8:18

answered Mar 2, 2012 at 8:12

ntziolis

10.2k1 gold badge36 silver badges50 bronze badges

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

2 Comments

Jacob Over a year ago

Thanks a lot Ntziolis. It seems it is not fixed. Unortunately I've tested all combinations with the schema. I have to say that 'MyNewSubProject' it's just a prefix in the table and not a real schema. If I put in schema 'dbo.MyNewSubProject' or 'MyNewSubProject' doesn't work. It's a bad decission use the dot?. If it's a special character in SQL...

ntziolis Over a year ago

yes, if you can eliminate the . do it, it is bad design to use reserved characters for names

Jayanga · Accepted Answer · 2012-03-02 08:18:24Z

3

try the following

modelBuilder.Entity<Entity>().ToTable("Table1","MyNewSubProject");

this will change schema to MyNewSubProject

answered Mar 2, 2012 at 8:18

Jayanga

8876 silver badges15 bronze badges

1 Comment

Jacob Over a year ago

Thanks! Doesn't work :( ... 'MyNewSubProject' it's just a prefix and not a real schema.

Collectives™ on Stack Overflow

Table name with dot in CodeFirst

2 Answers 2

2 Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related