14th September 2023: PostgreSQL 16 Released!

Devart ADO.NET Data Providers Deliver Advanced Model-First and Database-First Support and ...

Posted on 2010-12-13

Devart has recently announced the release of the new versions of dotConnect Data Providers, the database connectivity solutions built over ADO.NET architecture and development frameworks with a number of innovative technologies. Devart ADO.NET Data Providers product line includes high performance data providers for major databases and offer a complete solution for developing database-related applications and web sites. Devart dotConnect provides support for ADO.NET Entity Framework and LinqConnect. LinqConnect is the Devart ORM solution, closely compatible with the Microsoft LINQ to SQL, while extending its functionality with its own features.

With new versions of dotConnect ADO.NET Data providers - dotConnect for Oracle 6.00, dotConnect for MySQL 6.00, dotConnect for PostgreSQL 5.00, and dotConnect for SQLite 3.00 – Devart continues to introduce innovative approaches for ORM model designing and considerably improves the runtime of LinqConnect.

  1. New versions of dotConnects contains new greatly improved ORM solution - LinqConnect

The functionality of LinqConnect ORM was extended by the following:

Now LinqConnect supports Batch Update for DML statements execution on SubmitChanges call, which improves performance of update operations.

New kind of inheritance hierarchy was supported. In addition to Table Per Hierarchy support Table per Type is supported now.

LinqConnect package now includes the new templates for ASP.NET Dynamic Data projects, that allows creation ASP.NET Dynamic Data applications using LinqConnect.

Upgraded LinqConnect ORM supports Parallel LINQ, which offers performance improvements for your applications, using LinqConnect.

Visual Studio Debugger Visualizer was added to LinqConnect to improve readability of SQL code, generated for your LINQ queries, while debugging your application.

  1. Enhanced own ORM model designer - Entity Developer

Entity Developer, that is containing in dotConnect Data Providers, allows developing LINQ to SQL and Entity Framework models based on different database engines. Now it provides advanced Model First support and Update model from database functionality:

Model-First approach implementation in Entity Developer offers automatic synchronization of mapping and storage part with the conceptual part of the model and easy to use wizards for synchronizing database with the model.

Synchronizing Database with the Model

Entity Developer offers you two options for creating database based on your model. You may either generate a create script, that creates a new database, or use Update to Database Wizard that synchronizes an existing database with the model. This wizard makes only necessary changes to the database and retain the data if possible. Even changes inside entity are detected and resulted in ALTER statements, the table doesn't need to be dropped and created again. The wizard displays the tree of the changed objects and their changes, allowing you to choose which database objects need to be synchronized with the model, specify the renamed objects, etc.

Mapping Synchronization

When automatic mapping synchronization is enabled, changes to the conceptual model are automatically applied to its mapping and storage part. For example, when you add a class to the conceptual part, a corresponding table is created in the storage part, and the class is automatically mapped to this table. Even the most complex conceptual part changes are supported - complex types, many-to-many associations, complex hierarchies. All these changes can be automatically reflected in the storage part. However you may make manual changes to the storage part, and they will be preserved when editing conceptual part.

Update From Database Wizard allows synchronizing your model with the database for Entity Framework and LinqConnect in a fast and convenient way. Unlike standard Visual Studio Update Wizard, Entity Developer Update From Database Wizard tries to preserve manual changes to the model where possible. The wizard detects all the database changes that can affect the model, e.g. created and deleted tables and views, their columns and foreign keys, column datatype changes, created and deleted stored procedures and functions, changes to their parameters etc.

Pricing and Availability

We offer a free Express edition for each product from the dotConnect product line.

A Single license price starts from as little as $99.95, and you can always choose the edition that matches your needs best.

To learn more, download trial and free editions or order a license please visit Devart site:


About Devart

Devart is a software development company with 11 years of experience on the software market and over 20 thousands of devoted users.

We specialize in providing comprehensive development and management tools as well as native connectivity solutions for the most popular databases, including Oracle, SQL Server, MySQL, PostgreSQL, InterBase, Firebird, and SQLite.

For additional information about Devart, visit www.devart.com/company/

This post has been migrated from a previous version of the PostgreSQL website. We apologise for any formatting issues caused by the migration.