EF7 Scaffold Existing DB With Column Names = Table Names

Question

I am currently playing around with ASP.net 5 / EF 7 and at this point trying to scaffold my existing DB (~1200 Tables).

Command used: dnx ef dbcontext scaffold "<connstring>" EntityFramework.MicrosoftSqlServer --outputDir Models -a;

Basically it works as intended - but unfortunately there are several Tables (97) which contain a column with the same name as the table, causing a lot of "member names cannot be the same as their enclosing type" errors.

I know that I can change the Classnames manually, that would work but it is a lot of (unnecessary) work + given DB Changes in the future I would have to repeat that step on each new scaffolding.

Dnx ef dbcontext help does not give any hints.

Anyone found an easy workaround yet?

score 2 · Accepted Answer · answered Jan 31 '16 at 11:58

2

This is a know bug in RC1, and has been fixed in RC2 and latest daily builds: https://github.com/aspnet/EntityFramework/pull/3712

answered Jan 31 '16 at 11:58

ErikEJ

40,951
5
75
115

Rename your columns? – ErikEJ Apr 04 '16 at 09:35
still not out :-( in the meantime you can do this http://stackoverflow.com/a/10554917/16940 – Simon_Weaver May 24 '16 at 07:35
RC2 is out - what do you mean "still not out" ? – ErikEJ May 24 '16 at 10:04
How do I find it on nuget? Rc1 is the latest i see. – Simon_Weaver May 24 '16 at 10:05
Name change! Look for Microsoft.EntityFrameworkCore.SqlServer – ErikEJ May 24 '16 at 10:09
Thx. Why can't they put deprecation notices on these old packages – Simon_Weaver May 24 '16 at 10:11
But a nice link to the new package would be very useful. Already ran into this before. It just makes updating to newer stuff much more frustrating than it ought to be – Simon_Weaver May 24 '16 at 19:18
for anyone else getting confused by this here's the announcement of the changes : https://github.com/aspnet/Announcements/issues/144 – Simon_Weaver May 24 '16 at 19:39
also also here https://docs.efproject.net/en/latest/miscellaneous/rc1-rc2-upgrade.html – Simon_Weaver May 24 '16 at 19:43

EF7 Scaffold Existing DB With Column Names = Table Names

1 Answers1