InfoQ

News

Meta-data Synchronization Tools for LINQ to SQL and ADO.NET Entity Framework

Posted by Jonathan Allen on Dec 01, 2008

Community
.NET
Topics
IDE
Tags
ADO.NET Entity Framework ,
ORM

The feature list for Huagati DBML/EDMX Tools reads like a defect report for the related Microsoft products. There is no bloat here, everything is a must have for many shops.

LINQ to SQL Features

First up is a no-brainer, updating LINQ to SQL diagrams when the underlying database changes. One would think Microsoft would provide this out of the box, but since they didn't this alone makes this product worth its price.

Huagati's tool is also more intelligent about honoring default constraints such NewID and GetDate. Exclusion rules to prevent unwanted tables and columns from being repeatedly suggested round out this feature.

Since developers might not want to apply the changes right away, the tool can generate a report showing the differences, a comparison report is also available.

Naming Standards

A major problem for both LINQ to SQL and ADO.NET Entity Framework is that it does not handle naming standards. Using Huagati's tool, developers can specify rules such as when to strip off prefixes, how to case property names, and whether to remove underscores.

Documentation

The final feature is again something Visual Studio should have had but does not. The tool can automatically create or update an application's XML documentation using the table and column descriptions from the database.

No comments

Watch Thread Reply

Educational Content

Brian Marick on 4 Challenges and 5 Guiding Values of Agile Software Development

Brian Marick takes us through a quick tour of the most important values and challenges to adopting Agile successfully (they aren't the typical challenges and values we hear in the community).

Are You a Software Architect?

The line between development and architecture is tricky. Does it exist at all? Is an ivory tower actually needed? There's a balance in the middle, but how do you move from developer to architect?

Agile – A Way of Life and Pragmatic Use of Authority

The word 'authority' sometimes produces an allergic response in hard-line agilists. Freedom and authority – both are bad if misused and both are good if used in right spirit for a noble cause.

Getting Started with Grails, Second Edition

"Getting Started with Grails" brings you up to speed on this modern web framework. Companies as varied as LinkedIn, Wired, and Taco Bell are all using Grails. Are you ready to get started as well?

Using ITIL V3 as a Foundation for SOA Governance

Those familiar with only ITIL V2 often scoff at the thought that ITIL could serve as a governance framework for SOA. With ITIL V3, the focus of the framework shifted towards service-orientation.

Adrian Colyer on AspectJ, tc Server and dm Server

SpringSource CTO Adrian Colyer discusses AspectJ, SpringSource's dm Server and tc Server products, OSGi and Scrum.

Adam Wiggins on Heroku

Heroku's Adam Wiggins talks about Rails, Background Jobs, Add-Ons, Ruby, and how Heroku manages to work around Ruby's inefficiencies using Erlang and other languages.

SOA as an Architectural Pattern: Best Practices in Software Architecture

For Grady Booch the foundation of a good architecture is patterns, SOA being just one of many patterns. In this Second Life presentation, Booch attempts to bring more clarity on what architecture is.