New versions of dotConnect ADO.NET Providers and LinqConnect with Improved Model-First
November 29, 2010
Devart is glad to announce the release of the new versions of ADO.NET data providers,
enhanced database connectivity solutions built over ADO.NET architecture with support
for Entity Framework and LinqConnect ORM solutions. New versions of dotConnect data
providers offer you new greatly improved LinqConnect
2.00 and Entity Developer 3.00.
LinqConnect continues to improve, and now in version 2.00 it has many new features:
- Batch Updates
Now LinqConnect can execute DML statements in batches on SubmitChanges call, which
improves performance of update operations.
- Table Per Type inheritance
New kind of inheritance hierarchy - Table per Type is supported now in addition
to Table Per Hierarchy support.
- ASP.NET Dynamic Data
New templates for ASP.NET Dynamic Data projects are now included into LinqConnect
package. This allows you to create ASP.NET Dynamic Data applications, using LinqConnect.
LinqConnect 2.00 supports Parallel LINQ, which offers performance improvements for
your applications, using LinqConnect.
- Visual Studio Debugger Visualizer for DataQuery objects
Now you can view SQL code, generated for your LINQ queries, while debugging your
application. Debugger visualizer highlights SQL syntax of your query for better
Entity Developer 3.00
The new version of Entity Developer delivers advanced Model First support and Update
model from database functionality.
New Entity Developer provides advanced Model First support for both Entity Framework
1 and 4, for LinqConnect, and for LINQ to SQL. 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.
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.
Updating Model from Database
Update From Database Wizard was the most demanded feature at our
UserVoice forum. The opinion of our users is important to us, so this feature
was implemented in Entity Developer 3.00 as soon as possible.
Update From Database Wizard allows synchronizing your model with the database for
Entity Framework, LinqConnect, and LINQ to SQL 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.
If you need another feature in Entity Developer or LinqConnect, 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.