Huagati DBML Tools 1.64

Huagati DBML Tools 1.64  is an add-in for Visual Studio designed for adding functionality to the Linq2SQL/DBML diagram designer in Visual Studio 2008, and to the ADO.NET Entity Framework designer in Visual Studio 2008 SP1.

It adds options for comparing and synchronizing Linq2SQL designer diagrams with the database, for updating classes and properties generated using the Linq to SQL designer or Entity Framework designer to use .net naming conventions, to update documentation for L2S and EF-generated classes and properties with descriptions from the database, to generating incremental SQL-DDL corresponding to changes in L2S diagrams, and for cleaning up Entity Framework models with orphaned SSDL/CSDL entity sets/types.

Major Features:

1. Features for Linq-to-SQL
   • 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
   • Exclusion lists for tables, columns, foreign keys, types/classes, members/properties and associations/navigation
   •  properties allows flexible rules for what to sync and what to not sync.
   • Customizable rules for auto-generated properties allow columns with default constraints such as NewID, NewSequentialID, GetDate, or custom default constraints  to be treated as auto-generated.
   • Compare Linq-to-SQL diagram with database detects changes and differences betweenthe 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
   • 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
   • Generate DDL with model <-> db differences compares the Linq-to-SQL model with the underlying database and generates SQL DDL corresponding to any differences detected; new/dropped tables, new/dropped columns, primary key changes, new/dropped foreign keys/associations.
   • 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.
   • Generate Required/Optional interfaces adds member properties to all entity classes, providing quick and easy access to required (non-nullable) vs optional (nullable) members.
   • 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.
2. Features for ADO.NET Entity Framework
   • • 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
   • 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. SQL Server 2000, 2005 or 2008 (any edition) is required for the update documentation feature.
   • 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.
   • 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.
   • Generate Required/Optional interfaces adds member properties to all entity classes, providing quick and easy access to required (non-nullable) vs optional (nullable) members.
     

Requirements:

• VS 2008
• SQL Server 2000, 2005 or 2008 (any edition) is required for the Linq-to-SQL features.