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.
Great Plugin for Visual Studio. Great way for generating the Entity Framework Context of multiple databases. I was able to use this to help generate the Models to work with our older systems. There is certainly some room for improvement with this tool.
Given that our databases have been around for a long time and do not follow the typical EF conventions it had a difficult time creating some of the models and properties as it made no modifications. This resulted in the use of reserved words for classes and properties.
This would be a 5 star tool if it were updated to work with EF6.x, and had logic to alter names so that table_name becomes TableName, and table_name_id becomes TableNameId.
Does not function properly with ASP.NET Identity framework when attempting to generate EDMX diagram.
System.Reflection.TargetInvocationException: Exception has been thrown by the target of an invocation. ---> System.TypeLoadException: Could not load type 'System.ComponentModel.DataAnnotations.Schema.IndexAttribute' from assembly 'EntityFramework, Version=184.108.40.206, Culture=neutral, PublicKeyToken=b77a5c561934e089'. at Microsoft.AspNet.Identity.EntityFramework.IdentityDbContext`6.OnModelCreating(DbModelBuilder modelBuilder)
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).