Features for Linq-to-SQL

Huagati DBML/EDMX Tools adds a new DBML/EDMX Tools menu to Visual Studio 2008's menu bar

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 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

The Update/Compare options dialog gives the user control over what kinds of database changes to take into account in the update and compare functions, and customization of many of the update/compare rules.


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

The renaming options dialog gives the user control over what naming rules to use when mass-updating class- and property names.

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.

After using the documentation add-in on a Linq-to-SQL designer, the generated documentation is displayed in tooltips in the Visual Studio code editor.

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

Features for ADO.NET Entity Framework

Huagati DBML/EDMX Tools adds a DBML/EDMX Tools dropdown menu to Visual Studio 2008's menu bar

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

The renaming options dialog gives the user control over what naming rules to use when mass-updating class- and property names.

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 2005 or 2008 (any edition) is required for the update documentation feature.

Download / Get a license

 Click here to download! Current version: 1.46 released on 14 November 2008

Click here to retrieve a free trial license key.

To install, unzip the download package and run setup.exe.

By installing and using the add-in you agree to be bound by and will abide to the terms of the end user license agreement in the user guide.
 

Licensing Options

Free Trial Limited to 150 tables per DBML or EDMX file. The trial license is valid for 30 days from installation. Click here to retrieve a license key for the free trial edition!

Unlimited No limits imposed. Donate-to-charity license You name the price Identical to the full unlimited license but your money will be donated to the British School of Bangkok's charity fundraising for the Bankoknoiwittaya School in Chiang Rai. 20 licenses available. Offer ends on 22 November 2008 or when the limited quantity has been sold out. Email your donation PayPal receipt to licensing@huagati.com to receive your license. Single user license $119.95 USD Fifteen user license $1,200.00 USD

 
For buyers in Thailand, 7% VAT will be added to the price during PayPal checkout.

Please contact us if you need an invoice, tax invoice or want to pay via bank wire transfer (available for orders within Thailand or for international orders over USD $500).

Download mirrors / alternative download sites:
(Version 1.43)

Support Options

If you have any questions related to the toolkit in any way, please feel free to contact us through:

The Huagati DBML/EDMX Tools Support Forum
The support forum for Huagati DBML/EDMX Tools is located at http://forum.huagati.com/.

You may ask anything related to the add-in whether your question is technical or non-technical. How-to-questions, best practices, L2S/EF general questions, suggestions, feature requests, licensing questions - all questions are welcome.

Email
If you prefer sending us a private email rather than ask your question in the support forum, please do. The email address is support@huagati.com