ScriptDOM Succinctly by Joseph D. Booth ISBN 9781642002461, 1642002461 instant download

ScriptDOM Succinctly by Joseph D. Booth ISBN 9781642002461, 1642002461 instant download

Introduction to the ScriptDOM library and its uses.
 
OVERVIEW
ScriptDOM is a hidden gem buried in the .NET Framework for anyone working with SQL. It's a library that parses SQL code and produces a list of tokens and an abstract syntax tree, allowing you to walk through stored procedures and queries clause by clause to make sure they are sound. In this ebook, author Joseph D. Booth guides you through setting up ScriptDOM in a console application and then using it to inspect SQL statements, identify user-defined functions, flag deviances from company standards, and more.
 
TABLE OF CONTENTS
    Introduction
    Getting Started
    Tokens
    Statements
    Visitor Pattern
    Variables
    Select Statement
    Insert Statement
    Update Statement
    Delete Statement
    Functions
    Set Commands
    Dangerous Commands
    Helper Functions
    Generate Script
    SQL Versions
    Interacting with a Database
    Answers
    Conclusion