@PCSWebLabs I.T. for the I.T. Community

Code Generation Part I – Extract Database Metadata

Overview

[inline][/inline]

This article is the first in a series of code generation articles that will demonstrate the basic concepts of using code and freely available tools to generate code and eliminate hours of tedious and repetitive work. We will in addition, demonstrate how code generation may be used to create consistent code based on architectural patterns. Instead of presenting all of the concepts involved in code generation all at once, we will peacemeal these concepts into major functional areas. These are:

• Extraction of database metadata without the use of SQLDMO or its .NET counterpart SMO
• Using LINQ to XML to format all extracted metadata
• Using XSLT to generate code on the fly
• Using what we've learned with design patterns