InfoQ

News

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

Posted by Jonathan Allen on Dec 01, 2008 04:24 AM

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.

Related Sponsor

Red Gate Software makes ingeniously simple tools for over 500,000 SQL Server and .NET professionals.

No comments

Watch Thread Reply

Educational Content

Bindings, Platforms, and Innovation

This presentation focuses on the Internet and separating myth from fact, history from the future, and the mundane from the imaginative. Bob Frankston presents a vision of what could and should be.

  •  Jul 02, 2009,
  •  

Orchestrating Long Running Activities with JBoss / JBPM

This article explores the use of JBoss and jBPM to implement design solutions that effectively address the issue of orchestrating long running activities.

  •  Jul 01, 2009,
  •  

Neo4j - The Benefits of Graph Databases

This presentation covers the use of graph databases as an optimal solution for data that is difficult to fit in static tables, rapidly evolving data or data that has a lot of optional attributes.

Realistic about Risk: Software development with Real Options

This session introduces Real Options and shows how it can help in running your project. Real Options is a decision-making process that can be used to manage risk.

  •  Jun 30, 2009,
  •  

Communication Flexibility Using Bindings

This article discusses the use of bindings on services and references (including the instance of non-configured bindings) as the means to implement SCA communications in a Web and SOA environment.

  •  Jun 30, 2009,
  •  

Writing DSLs in Groovy

After a short introduction to DSLs, Scott Davis plays with the keyboard showing how to approach the creation of a DSL by typing working snippets of Groovy code that get executed.

Scaling Agile with C/ALM (Collaborative Application Lifecycle Management)

IBM Rational and InfoQ present, Scaling Agile with C/ALM, an eBook showing organizations how to become “finely tuned software delivery machines” by enabling team integration and scaling.

Concurrent Programming with Microsoft F#

Amanda Laucher presents a real life enterprise application written in F#. She shows actual code snippets, explaining design decisions and suggesting how to use some of the F# constructs.