This application was conceived after our use of Microsoft’s
SqlMetal.
What is SqlMetal
- SqlMetal is a code generator.
- It does a nice job of building entity classes based on your database schema.
- It does a lack luster job of organizing the code.
- It builds a single monstrous file which is difficult to navigate.
- It does not preserve your domain knowledge that exists in your database.
- It fails to associate a version number with the database.
SqlTac extends SqlMetal
- Adds additional capabilities to streamline SQL Server-based application development.
- Organization of the source produced, is alphabetically by Sql’s Schema (namespace) and then Table name.
- Provides multiple collapse-able regions
- It preserves your domain knowledge by emitting HTML style comments for:
o a) Database (file header)
o b) Tables (classes)
o c) Columns (Member, Properties)
and
o d) Foreign Keys (entity
sets).
Benefits
- Analyze your risk associated with not capturing domain knowledge.
- Quickly identify which pieces of domain knowledge has not been captured.
- Provides an easy-to-use interface to support capturing your domain knowledge.
- Builds a single SQL script for your entire database.
- Simplifies re-creation of an entire database, not just tables and columns.
- Leverages third party tools to build indispensable help files.
- Supports disseminating your domain knowledge by publishing your help files to the rest of the development staff.