Huagati DBML / EDMX Tools 1.95

Huagati DBML/EDMX Tools integrates with Visual Studio and adds useful new functionality to the built-in designers for Linq-to-SQL and Entity Framework in Visual Studio.

Among the features added to Visual Studio by the add-in are: synchronize your Linq-to-SQL models with the underlying database and any database schema changes, compare and synchronize database, SSDL, and CSDL model in Entity Framework 4 models (VS2010), mass-rename Linq-to-SQL and Entity Framework generated entity classes and their members to use .net naming conventions, generate documentation comments for L2S and EF entity classes from the database, generate SQL-DDL scripts from Linq-to-SQL and Entity Framework models. 

1. Update Linq-to-SQL diagram from database automatically updates Linq-to-SQL designer diagrams and generated classes with database changes:
   • New Tables/Views -> creates new classes
   • Dropped Tables/Views -> removes corresponding classes
   • New Columns -> adds new properties
   • Dropped Columns -> removes corresponding properties
   • Columns with changed nullability -> updates member properties accordingly
   • Columns with data type changes -> updates member properties accordingly
   • New Foreign Keys -> adds associations and navigation properties
   • Dropped Foreign Keys -> removes corresponding associations and navigation properties
   • Changed Primary Keys -> updates member properties accordingly
   • New stored procedures or user defined functions -> adds member methods to the datacontext class
   • Dropped stored procedures or user defined functions -> removes member methods from the datacontext class
   • Changed signature (parameters or return value/return type) from stored procedures and UDFs -> updates the signature accordingly in the datacontext
2. Compare Linq-to-SQL diagram with database detects changes and differences between the Linq-to-SQL designer (DBML) and the database and outputs a list of the changes:
   • New Tables
   • Dropped Tables
   • New Columns
   • Dropped Columns
   • Columns with changed nullability
   • Columns with data type changes
   • New Foreign Keys
   • Dropped Foreign Keys
   • Changed Primary Keys
   • New stored procedures or user defined functions
   • Dropped stored procedures or user defined functions
   • Modified stored procedures or user defined functions
3. Standardize Linq-to-SQL class and member names mass updates names of entities and members in Linq-to-SQL designer diagrams and generated classes:
   • Remove/add prefixes/suffixes, e.g. remove leading tbl_, int_, str_
   • Use TitleCaseNames for classes and properties if the database names are all lowercase
   • Remove underscores_in_names
   • Control pluralization / singularization
   • Use regular expressions in addition to built-in naming rules
   • Plug in custom pluralization / singularization or custom name rule code
4. Generate SQL-DDL scripts with model <-> db differences compares the Linq-to-SQL model with the underlying database and generates SQL-DDL scripts corresponding to any differences detected; new/dropped tables, new/dropped columns, primary key changes, new/dropped foreign keys/associations. 
5. Update Linq-to-SQL documentation from database retrieves free-text table and column descriptions, and index definitions from the database and updates the xml documentation and description attributes for Linq-to-SQL generated entity classes and member properties with the same information for inline documentation in Visual Studio's code editor.
6. Generate Required/Optional interfaces adds member properties to all entity classes, providing quick and easy access to required (non-nullable) vs optional (nullable) members.
7. Diagram layout views is a dropdown on the DBML Tools toolbar that allow a Linq-to-SQL model to have more than one diagram layout. New layouts are added using the add view button 
8. The Model Comparer* for Entity Framework 4 compares the database with the SSDL layer of the model, and the SSDL layer with the CSDL layer. It allows differences to be synchronized across the layers selectively, updating only the portions of the model selected by the user while leaving other portions of the model untouched and intact.
9. EDMX file wrapper library: The add-in uses a sophisticated wrapper library, HuagatiEDMXTools, that puts an object model on top of the EDMX, giving easy programmatic access to parsing, creating, modifying and updating EDMX files. This library can be used by licensed users of the add-in for homegrown tools built on top of the EDMX files. 
10. Standardize ADO.NET Entity Data Model class and member names renames ADO.NET Entity Framework designer diagrams and generated classes:
    • Remove/add prefixes/suffixes, e.g. remove leading tbl_, int_, str_
    • Use TitleCaseNames for classes and properties if the database names are all lowercase
    • Remove underscores_in_names
    • Control pluralization/singularization
    • Use regular expressions in addition to built-in naming rules
    • Plug in custom pluralization / singularization or custom name rule code
    • Generate complex types* can generate complex types, grouping commonly occuring entity members together in types reused across all entities sharing the same members.
11. Update ADO.NET Entity Data Model documentation from database retrieves free-text table and column descriptions, and index definitions from the database and updates the xml documentation fields in the EDMX designer with the descriptions.
12. SQL Server 2000, 2005 or 2008 (any edition) is required for the update documentation feature. 
13. Cleanup SSDL/MSL/CSDL** detects unmapped entityset/entitytype definitions in the SSDL and CSDL portion of EDMX files and presents a summary of those inconcistencies along with options for removing unmapped entitysets/types and associations/foreign keys linked to them, or to recreate them in the opposite layer of the EDMX file (CSDL / SSDL), and to create new mappings.
14. Generate DDL (New Database)** generates SQL-DDL for generating a new database from the SSDL (storage) portion of an EDMX file, including tables, primary keys, foreign keys, and indexes corresponding to foreign keys. 
15. Generate Required/Optional interfaces adds member properties to all entity classes, providing quick and easy access to required (non-nullable) vs optional (nullable) members.