[Overview]
General SQL Parser .NET version (used in C# and VB.NET) is
valuable because it provides an in-depth and detailed analysis of SQL scripts
for various databases, including Oracle, SQL Server, DB2, MySQL and Access.
Without a complete query parser like this, such a task will be impossible. You
now have the chance to fully incorporate this C# SQL parser and VB.NET SQL
Parser into your products, instantly adding a powerful SQL processing capability
to your .NET programs.
[Features]
Clean up messy SQL codes
Easily integrate SQL formatter into your application for a color coded layout
that is easy to navigate, giving your product a professional feeling.
: If you need to add SQL format/beautify features
in your own program, it's highly recommended to use our SQL formatter
feature in General SQL Parser. It will save you hundreds of hours if not
more!
We know how difficult it is to build a flexible and stable SQL
formatter. If you need to support more than one SQL dialect like
ORACLE, MS SQL SERVER, DB2, MySQL then this
component/library will be the most valuable investment you ever made.
◀ Original SQL
◀ Formatted
SQL
Detect SQL syntax errors
Your application will be able to validate SQL syntax before a database executes
the query. This is very useful especially if your SQL was dynamically built
based on user input.
: SQL syntax check can be done without being
connected to the database server and syntax errors can be found
before executing SQL on your production database server. Database
supports the following: Oracle(PLSQL), SQL Server, MySQL, DB2 and
Access.
Rid SQL injections
Avoid being vulnerable to SQL injection in your ASP.NET or Java application, by
automatically detecting malicious SQL segment with our ready-to-use library.
Retrieve/Refactor table & column name
Precisely determining and renaming every table and column in stored SQL
statements is very complex with a lot of nesting and sub-queries, but we can
make it hassle-free for you.
Find affected SQL objects
Parse out the affect SQL objects in a SQL file that can have many different
types of SQL (select, insert, create, drop, etc), and helping to determine what
is being affected, including but not limited to schema, table, column.
Discover the relationship in DDL
Quickly locate the primary key and/or foreign key in DDL scripts to figure out
the complex relationship among the various tables. Extracted table, attribute
names, data types can be used to generate the CRUD-Statements.
Query parse tree in XML
Parsing SQL is a notoriously difficult task, but we are here to help. You will
be provided with a SQL query parse tree in XML output that will allow you to
further process SQL scripts.
: Sometimes XML output of SQL query tree is a
starting point for doing further processing of SQL script. With the
help of this demo you can generate XML output of SQL script quickly.
You can also modify this demo to create customized XML output to
meet your own standards.
Rewrite and convert SQL
Modify SQL expression/condition in where clause to reconstruct a new filter.
Rewrite Oracle proprietary joins to ANSI SQL compliant joins. Translate SQL
between different databases.
CRUD Reportor
Read complex and large SQL scripts to find out tables have Create, Read, Update,
Delete and Insert operations against them immediately, it's almost impossible to
do that without help with a tool.
Impact and Data Lineage
Determining the impact and data lineage for database objects. capture and
represent column level data lineage between applications; find table/view and
column references and more.
SQL Parser can even do more
We are dedicated to constantly improving our product so it will be easier to use
with more flexibility, making it a valuable asset to your software product.
Here, we have provided you with additional demos that may be helpful to you.