tsql-parser

Library Written in C# For Parsing SQL Server T-SQL Scripts in .Net

Available on Nuget, TSQL.Parser.

Install-Package TSQL.Parser

Current Features

• Full T-SQL token implementation.
• Streaming tokenizer for parsing scripts into tokens.
• Returns tokens of type characters, comments, identifiers, keywords, literals, variables, and operators.
• Handles both single line and multi line comments.
• Select, Insert, Update, Delete, and Merge statement parsers.
• .Net Framework 4.0+ and .Net Core 2.0+ compatible.

Code Samples

• See wiki for simple code examples and output.
• See test cases in project.

Class Documentation

• bruce-dunwiddie.github.io/tsql-parser/

Some Possible Current Uses

• Colorization
• Dependency Parsing
• Parsing comments.
• Find and replace.
• Script validation.

Future Additions

• More statement parsers built on top of tokenizer.

Building From Source

If you're looking to fork the project or build from source, the dependencies below are required for backwards compatibility support.

.Net Framework 4.5.2

• Download and install the .Net Framework 4.5.2 Targeting Pack.

Sandcastle Help File Builder

• Follow instructions for installing the latest SFHB release.
• Update the target .Net Framework on SandcastleDocs project if prompted.