Devart ADO.NET Data Providers and LINQ to SQL Compatible ORM Solution Deliver Incredible New Capabilities and Advanced Model-First Support

Devart has recently announced the release of the new versions of dotConnect Data Providers and  LinqConnect 2.00 ORM solution.

dotConnect Data Providers are the enhanced 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. New versions of Devart dotConnect data providers support ADO.NET Entity Framework v.1 and v.4 and LinqConnect.

LinqConnect is the Devart ORM solution, developed closely to Microsoft LINQ to SQL, while extending its functionality with its own advanced features. The new LinqConnect 2.00 has improved runtime and own enhanced visual model designer – Entity Developer.

New versions of dotConnect Data Providers and LinqConnect 2.00 offer developers the new greatly improved Entity Developer 3.00 that provides advanced Model-First and Database-First support.

LinqConnect 2.00

LinqConnect ORM 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.
PLINQ
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 readability.

Entity Developer 3.00

The new version of Entity Developer delivers advanced Model First support and Update model from database functionality.

Model-First
New Entity Developer provides advanced Model First support for both Entity Framework 1 and 4 and for LinqConnect. 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.

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.

dotConnect for Oracle 6.00

[ Download ]

[ New Features ]

dotConnect for MySQL 6.00

[ Download ]

[ New Features ]

dotConnect for PostgreSQL 5.00

[ Download ]

[ New Features ]

dotConnect for SQLite 3.00

[ Download ]

[ New Features ]

LinqConnect 2.00

[ Download ]

[ New Features ]

For additional information about Devart products, visit www.devart.com

Contact Information

Share and Enjoy:
  • Digg
  • Sphinn
  • del.icio.us
  • Facebook
  • Mixx
  • Google
  • TwitThis