Skip site navigation (1) Skip section navigation (2)

New Versions of Devart dotConnect ADO.NET Providers for PostgreSQL, Oracle, MySQL, SQLite!

From: Devart <submit(at)devart(dot)com>
To: pgsql-announce(at)postgresql(dot)org
Subject: New Versions of Devart dotConnect ADO.NET Providers for PostgreSQL, Oracle, MySQL, SQLite!
Date: 2011-05-30 14:34:51
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-announce
Devart today revealed details of its latest dotConnect Data Providers
release. DotConnect Data Providers are the enhanced database connectivity
solutions, built over the ADO.NET architecture, that support Entity
Framework and LinqConnect ORM solutions. New versions of products offer the
users significantly enhanced Entity Framework support, new greatly improved
Entity Developer 3.50, and many other improvements. 

	Entity Framework Support Improvements

In the new versions of Devart dotConnect ADO.NET providers for Oracle,
MySQL, PostgreSQL, and SQLite Devart has significantly extended functional
capabilities of Entity Framework by maximally fulfilling requests made by
product users. Users mainly requested new functional features, more
flexibility in behavior and configuration as well as better performance.

To increase performance, Devart provides the functionality of flexibly
configured Batch Updates, gives the possibility of configuring individual
aspects of INSERT/UPDATE/DELETE operations and make it possible to disable

To make software more flexible, solution enables the users to additionally
configure the behavior for dynamic database creation/deletion, which is
quite important after the release of EF 4.1 (Code-First).

Besides, as a workaround for the commonest situations, the users can exclude
the schema (database) name from generated DDL and DML SQL commands and
disable identifier quoting. 

To facilitate the process of development and to cease using simple INSERT
triggers that set values of Identity columns, we make it possible to use
database-specific functions as Default Value when inserting records into

The LINQ to Entities string column search functionality has been extended -
now you may call the full-featured database-specific LIKE function instead
of using three different methods StartsWith(), Contains(), and EndsWith().

Devart has implemented the possibility of saving manually defined
StoreGeneratedPattern of columns in the model's storage part, so that now
the users of dotConnect for Oracle do not have to set StoreGeneratedPattern
manually every time Update from Database Wizard is run in Visual Studio

In dotConnect for Oracle Devart has added a possibility to change the
default NUMBER mapping to .NET types when creating an Entity Framework model
with Entity Data Model Wizard. The NUMBER mapping can be set with the
NumberMappings connection string parameter.
	Entity Developer Improvements
Now, it is possible to add more than one template to the model, register
added templates within the model and store them either in the Entity
Developer resources, or in the specified folder, or together with the model
itself. The so-called "shared" templates can now be easily shared between
different models.

Another new feature in the area of template use and management is the
possibility to exclude templates from the process of code generation by
setting their "enabled" property to "false". This greatly improves the
flexibility of the code generation process.

Template code can be easily edited in the improved built-in T4 editor. T4
editor features extensive intellisense functionality, syntax highlighting,
navigation to definitions and declarations of objects and members, present
in the template file or included files, multilevel template inclusion and
some others.

The range of templates available in Entity Developer is further extended
with the POCO template with XML mapping for LinqConnect and the POCO,
Self-Tracking, DbContext, and Fluent mapping templates for Entity Framework.

Additionally, the Entity Developer application now features, alongside the
FilePerClass option, the EntitiesOutput and ContextOutput functionality that
allows redirecting code generation for entities and appropriate contexts to
any folder or project.

Presently, Entity Developer makes it possible for developers to exclude
classes from being overwritten at each generation; in multi-layered
application development, this allows creating sets of sample classes that
can later be modified as needed. 

The use of extended properties defined directly in template code makes the
process of code generation much more flexible. The developer can customize
the set of properties of any element in the model by declaring extended
properties both in template code and in model properties. For example, you
can add the Generate property to every class and then exclude some classes
from generated code by setting this property in the designer. 

Starting with this version of Entity Developer, developers can select
attributes from all available assemblies, set values of attribute parameters
and assign attributes to classes, properties or contexts of their model.
Assigned attributes and the values of their parameters will be present in
generated code. For example, the System.ComponentModel.DataAnnotation
attributes can be used for validation. 

Lastly, Entity Developer now has runtime support for literals specified in
the 'Default Value' entity field property for LinqConnect models.

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

We offer a free Express edition and fully-functional trial version for each
product from the dotConnect product line.

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  

View this message in context:
Sent from the PostgreSQL - Announce mailing list archive at

pgsql-announce by date

Next:From: St├ęphane A. SchildknechtDate: 2011-05-31 20:54:30
Subject: Slony1-ctl 1.2.0 released
Previous:From: Magnus HaganderDate: 2011-05-30 07:56:13
Subject: Call for papers - PGConf.EU 2011

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group