Devart Model Designer Delivers Advanced Model-First and Database-First Support to ...
Devart Model Designer Delivers Advanced Model-First and Database-First Support to ADO.NET Entity Framework and LINQ to SQL.
New version of powerful modeling and code generation tool with advanced Model-First support and Update Model from Database functionality. New model designer supports ADO.NET Entity Framework 1 and 4, and LINQ to SQL models and seamlessly integrates with Visual Studio 2008 and 2010.
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 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 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.
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 About Devart: Brief Information About Company