Devart announced the release of Entity Developer for SQL Server 3.00, the new version of powerful visual ORM model designer and code generation tool, that supports ADO.NET Entity Framework 1 and 4, and LINQ to SQL models.
Entity Developer allows you to create and edit models visually, without typing a line of XML code, and supports creating all kinds of mapping. T4-based code generation in Entity Developer is very flexible allowing virtually anything you may want for code generation.
Entity Developer for SQL Server 3.00 allows executing LINQ or ESQL queries against the model, and view/edit data, so you can easily test the mapping.
Now you can use advanced Model-First and Database-First approaches to design ADO.NET Entity Framework 1 and 4, and LINQ to SQL models:
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.
Updating Model from Database
- 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 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.
Pricing and Availability
In spite of new advanced functionality the price of Entity Developer for SQL Server is the same -$99.95.
Please, feel free to download and try Entity Developer for SQL Server 3.00 from http://www.devart.com/entitydevelop...nload.html
Users are welcome to write any comments and suggestions about Entity Developer 3.00 on its support page — http://www.devart.com/entitydevelop...pport.html
Entity Developer 3.00 is also available as a part of LinqConnect and Professional editions of dotConnect for Oracle, dotConnect for MySQL, dotConnect for PostgreSQL, and dotConnect for SQLite. As a part of these solutions Entity Developer supports corresponding databases. About 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 po***r databases, including Oracle, SQL Server, MySQL, PostgreSQL, InterBase, Firebird, and SQLite.
For additional information about Devart, visit www.devart.com/company/