Huagati DBML/EDMX Tools was designed to be an add-in for Visual Studio that adds functionality to the Linq2SQL/DBML diagram designer in Visual Studio 2008, and to the ADO.NET Entity Framework designer in Visual Studio 2008 SP1.
The add-in adds new menu options for synchronizing Linq-2-SQL designer diagrams with changes in the underlying database, for renaming Linq-to-SQL (DBML) and EF (EDMX) classes and properties to use .net naming conventions, and for adding documentation/descriptions to Linq-to-SQL generated classes from the database properties
Here are some key features of "Huagati DBML / EDMX Tools":
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
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
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
· 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.
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
Requirements:
· Visual Studio 2008
· .NET 3.5
Limitations:
· Limited to 150 tables per DBML or EDMX file.
· The trial license is valid for 30 days from installation.