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 / 2010
· .NET 3.5
Limitations:
· Limited to 50 tables per DBML or EDMX file, and four customized layout views per Linq-to-SQL model
· The trial license is valid for 20 days from installation
What's New in This Release: [ read full changelog ]
VS2010:
· All tools: Added support for SQL Server 2012.
· L2S sync: made it easier to change database connection before sync (click on the "advanced" button in the sync options dialog to see the connection string tools).
· EF Model Comparer: fixed issues related to complex type member mapping.
· Various fixes and corrections.
VS2008:
· No changes for the VS2008 version of the add-in.
Find us on Google+
