November 29, 2010
Extended Model Design and Runtime Capabilities in LINQ to SQL Compatible ORM
Solution from Devart
New version of LINQ to SQL compatible ORM solution with extended
functionality and advanced Model-First support and Update model from
Devart is glad to announce the release of LinqConnect 2.00, the new
version of LINQ to SQL compatible ORM solution with extended functionality
and enhanced own visual model designer - Entity Developer.
LinqConnect supports SQL Server, Oracle, MySQL, PostgreSQL, and SQLite. It
is developed closely to the Microsoft LINQ to SQL technology, while
extending its functionality, thus allowing LINQ to SQL developer to easily
get started with LinqConnect. In addition to LINQ to SQL features,
LinqConnect provides its own advanced functionality.
LinqConnect continues to improve, and now in version 2.00 it has many new
a.. Batch Updates
Now LinqConnect can execute DML statements in batches on SubmitChanges
call, which improves performance of update operations.
b.. Table Per Type inheritance
New kind of inheritance hierarchy - Table per Type is supported now in
addition to Table Per Hierarchy support.
c.. 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.
e.. 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 readability.
The important enhancement in LinqConnect 2.00 is the upgraded model
designer - Entity Developer, that delivers 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.
a.. 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.
b.. 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.
Updating Model from Database
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
A Single license costs $249.95. To learn more about LinqConnect 2.00 please
visit the Devart site: www.devart.com/linqconnect/
Please, feel free to download and try LinqConnect 2.00 from
Users are welcome to write any comments and suggestions about 2.00 on its
support page - http://www.devart.com/linqconnect/support.html
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
For additional information about Devart, visit www.devart.com/company/
|• [NEWS]||Sergey Lazurenko||27 Dec|