Preview of useful design-time features for DbContext.
When right-clicking on a C# project, the following context menu function is supported:
1) Reverse Engineer Code First - Generates POCO classes, derived DbContext and Code First mapping for an existing database.
Useful tool ever since first version. But why is the model "Read-only?" Is the underlying XML re-generated constantly and read-only for that reason. Guess I'm just remembering the old modeler for SQLCE in a Winforms project being a complete editor. Was a pretty handy GUI tool.
Unbelievable, only in C #? The VB made Microsoft what it is today, putting the software development within companies without "bit and bytes"'s specialists . It is a shame that there is no longer a direction to a simple development where it's required so.
I don't know why Reverse Engineer function gives below error.
"System.ArgumentException: The modelEntityContainerName parameter 'asdf-dbContext' contains characters that are not valid. at System.Data.Entity.Design.EntityModelSchemaGenerator.Initialize(EntityContainer storeEntityContainer, IEnumerable`1 storeFunctions, String namespaceName, String modelEntityContainerName) at System.Data.Entity.Design.EntityModelSchemaGenerator..ctor(EntityContainer storeEntityContainer, String namespaceName, String modelEntityContainerName) at Microsoft.DbContextPackage.Handlers.ReverseEngineerCodeFirstHandler.ReverseEngineerCodeFirst(Project project)"
Great tool, saves a lot of time, however: 1) it needs to be working as a background operation to prevent disabling visual studio for long periods of time.(2400 tables > 9 hours) 2) should have a dialog to allow the selection of target tables. 3) there is a bug with oracle composite foreign keys, the columns order is wrong, items need to be shifted 1 spot to the left( not always).