General SQL Parser .NET Version

General SQL Parser .NET version(can be used in C#, VB.NET) provides in-depth analysis of SQL script of various databases such as Oracle, SQL Server, DB2, MySQL and Access at a detail level that would not be possible without a complete, 100% compatible query parser.

Parsing SQL is a notoriously difficult task because the syntax of SQL of different databases is very ambiguous in a lot of places. Many people have attempted to write a full SQL grammar with parser generate tool and failed.

Now you can fully incorporated this C# SQL parser(or VB.NET SQL Parser) into your product set, adds powerful sql processing capability to your .NET program, including offline SQL syntax check, beautify complex sql code with lots of customizable format options, identify various database objects such as table, column, constraints in sql scripts, modify and rebuild SQL on the fly, translate sql expression into a binary expression tree that ready for your further processing such as creating filter, and you can take full control of SQL with detailed parse tree of the whole input sql.

Features overview

• Offline SQL syntax checking of Oracle, SQL Server, DB2, MySQL and Access.
• Pretty print SQL statements with lots of configurable parameters, make it more readable.
• Identify various database objects such as table, field, relationships between field and table, function, procedure and trigger in sqls.
• Preventing SQL injection/attacks.
• Create/modify different parts of sql, then build/rebuild on the fly.
• Export query parse tree to xml structure for further processing.
• Create different visitors to visit parse tree for any purpose with the full control of all parse tree nodes.
• Generate a list of TCustomSqlStatement objects which represent the corresponding SQL statements that have been parsed.

 

Questions?

If you have any questions about General SQL Parser, You can always send us an email and we'll get back to you within 24 hours.