New Versions of dotConnect ADO.NET Providers with Entity Developer 5.5!

April 4, 2013

Devart is glad to announce the release of the new versions of ADO.NET data providers, enhanced database connectivity solutions, built over the ADO.NET architecture, that support Entity Framework and LinqConnect ORM solutions. New versions of dotConnect data providers offer you a new version of Entity Developer 5.5 with a large number of improvements and LINQPad support in LinqConnect.

LINQPad Integration

New versions of dotConnect for Oracle, MySQL, PostgreSQL, and SQLite provide a LINQPad driver that allows performing queries against the corresponding databases using LinqConnect ORM models. Both static (for precompiled DataContext) and dynamic (for automatic generation of context and entity classes) drivers are supported.

Code Generation Improvements

Entity Developer 5.5 offers the following new templates:

  • MVC Controller and MVC View Advanced - templates designed for generating an ASP.NET MVC Controller and View for using entity classes in ASP.NET MVC applications. Our MVC View Advanced template offers significant advantages over the standard MVC Scaffolding template. It supports such advanced features as sorting, filtering, and paging.
  • Data Annotations Metadata - generates Data Annotations metadata classes and decorate entity classes and properties with Data Annotations attributes that specify validation rules, data display settings, and define metadata for Windows Communication Foundation, Dynamic data, and WCF RIA Services.
  • Data Transfer Objects - template, designed for generating Data Transfer Object (DTO) classes.

Besides, some other templates were significantly improved. DbContext and POCO templates now have a WCF Data Contract Attributes property for managing generation of DataContract, KnownType, and DataMember attributes for classes and properties. These templates now also have Implement INotifyPropertyChanging and Implement INotifyPropertyChanging properties that control whether the generated classes implement the corresponding interfaces.

DbContext template now can generate one of the following kinds of mapping: attribute mapping (for simple cases), fluent mapping in the OnModelCreating method, and fluent mapping in configuration classes.

Another new feature of code generation is that now you can generate context and entity classes to different namespaces.

Create Model Wizard Improvements

Create Model Wizard was substantially improved. Now it is able to download and install the required 'EnityFramework' Nuget package for Entity Framework 6 models, and for models for Entity Framework 4 and 5 in case they use the DbContext template. It also automatically adds references to Entity Framework specific assemblies to a project when you add a new Devart Entity model to it.

Model First Improvements

Entity Developer 5.5 provides a number of settings to ease the Model First development. It allows you to define a set of properties that will be present in all the new entities, and when you create a new entity, these predefined properties will be added to it automatically.

Model initialization settings now allow you to specify if the string properties should be mapped to columns of unicode data type by default, and to set default facets for all the numeric properties.


Working with attributes is greatly improved. Now it is possible to edit attributes for several selected entities or properties at once. The Attributes page of the Model Settings dialog box has now the refresh button for refreshing the available attribute list for the selected assemblies.

Other Improvements

Generate Database Wizard now can generate DROP statements for database tables before CREATE statements. Update To Database Wizard offers a Recreate Database Tables setting to drop and recreate tables instead of altering them.

When adding a model object (a class, complex type, or enum) from Model Explorer to a diagram, or a table from Database Explorer to a diagram, now you can add them with all the related objects.

If you need another feature in Entity Developer, visit our forum at UserVoice and vote for suggested features or suggest your own one.

If you wish to provide feedback on the new versions, you can do it in our forums or with contact form. There is also a feedback form in the support zone of every product. We are always glad to hear your comments and take into account your development needs.