Entity Framework Core Designer

Entity Framework Core currently doesn't have a native visual designer. It has a rather limited database-first approach support, and supposes mostly code first development.

Entity Developer for Entity Framework fills this niche and provides advanced database first and model first support and a number of other features, which aren't even available if EDM Designer for previous Entity Framework versions.

The list of these features includes powerful template-based code generation, ability to test your model with LINQ queries at design-time, advanced support for large models, etc.

Model-First, Database-First, or Mixed

With our Entity Framework Core designer you can use either Model-First or Database-First design approach, or you may mix them in any way you like. Easy-to-use Update From Database and Update To Database wizards allow you to synchronize your model and database in any directions at any moment.

Update From Database Wizard tries to preserve manual changes to the model where possible. The Update From Database and Update To Database wizards detect all the database changes that can affect the model and vice versa, e.g. created and deleted tables and views, their columns and foreign keys, column datatype changes, etc.

All changes are displayed in an easy-to-understand form, and you can select only a part of the changes to apply. When updating database schema, Entity Developer considers database server specificity. It does not try to perform unsupported operations.


Update to Database Wizard

Tweak the Database-First Settings

When using database-first approach, Entity Developer for Entity Framework provides a number of options for creating a model. You may tweak naming rules for the generated names of the classes and their members. Entity Developer allows you to configure case and pluralization, removing and adding of prefixes and suffixes, etc.

After this you may set the default parameters for the generated classes: default assembly and namespace, default schema, cascade style, strategy for accessing a property value, etc.

Powerful Entity Framework Core Designer

Easy to Start, Easy to Use

Designing Entity Framework Core models with Entity Developer is easy and intuitive. Only the most frequently used mapping parameters are accessed through the editor dialog boxes, making our editors simple and easy to understand. If you need more extended mapping tuning, you can find all the available parameters of a model object in the Properties window.

All the mapping is defined visually, you don't need to manually edit the mapping code.

Entity Framework Core Designer Dialog Boxes

Rich Mapping Functionality

Entity Developer for Entity Framework Core supports all features of Entity Framework Core mapping. It supports enums, different kinds of associations, inheritances, table splitting, complex types, etc.

Advanced Drag-and-drop Support

To accelerate model design process, our Entity Framework Core designer provides wide support for drag-and-drop functionality. After you have established a database connection, you may drag database tables and views from the Database Explorer window to your model diagram to create classes for these tables with already defined mapping. To quickly create an inheritance hierarchy in a model, reverse-engineered from a database, you may just drag several properties from the class to create a base or derived class from them.

Keep Your Model Valid

Our Entity Framework Core designer always validates your model while you are editing it. All errors and warnings automatically appear in the Error List window. Error list displays error or warning message and its location.

You can easily navigate to the object that caused an error by double-clicking it in the Error List window. Thus you may find and fix model errors quickly and conveniently.

Design-time validation

Code Generation

Entity Developer has a powerful template-based code generation system that offers a number of ways to configure generation process according to your particular needs.

Entity Developer includes a number of templates for generating code for different cases. It can generate POCO or persitance aware classes in C# or Visual Basic and supports third-party ADO.NET providers for SQL Server, Oracle, MySQL, PostgreSQL, DB2, Firebird, and SQLite.

Our Entity Framework Core designer comes with useful settings for code generation:

  • Entities Output property allows you to specify output folder or output Visual Studio project for generated entities.

  • Context Output property allows you to specify output folder or output Visual Studio project for the generated context class.

  • File Per Class option allows you to choose whether to generate classes either into a single code file or into a separate code file for each persistent class. This setting is used by default.

  • Generate Partial Classes property enables generation of partial classes with a separate file for generated code and a file for user code per class (Code-behind).

Read more

Entity Framework Core Generator Capabilities

Seamless Visual Studio Integration

Entity Developer seamlessly integrates to Visual Studio. The model is created and edited just like any other Visual Studio project item. Code for a model is generated each time you save the model and is automatically placed to the project, containing the model, by default. You may redirect code output to other Visual Studio project if necessary.

Test Your Model at Design-Time

Our Entity Framework Core designer allows viewing and editing data of tables, views, and model entities, create and execute LINQ and Entity SQL queries against the model, eliminating the need for additional applications and reducing time for accessing these operations.

Executing LINQ query against the model

Preparing Test Data

With Entity Developer you may perform viewing and quick editing of the database data from the tables in the Database Explorer. This data is editable, allowing you to quickly insert some data into the database to perform some testing.

Designing and Debugging LINQ and Entity SQL Queries

Our Entity Framework Core designer allows you to execute LINQ or Entity SQL queries directly against the model without the need to write a sample application. You can use our built-in query editor to design queries, which can be saved for future use, and view the returned data and generated SQL.