[Mono-list] SQL Parser for System.Data

Daniel Morgan danmorg@sc.rr.com
Sat, 11 May 2002 05:18:45 -0400


Anyone have any experience at creating a SQL parser? 
How do I create a SQL parser in C#?  Or is there an open source (as in
X11 free or BSD free) SQL parser already written in C# or Java?

I do understand that the Mono C# compiler (mcs) is written in C# and
uses jay (a Berkeley yacc parser ported to java ported to C#), but other
than that, I have no idea where to begin.  I do not understand jay,
yacc, nor creating language parsers.
 
However, I do need it for System.Data Parameters support (IDbParameter,
SqlParameter, and OleDbParameter).  Parameters are used for passing data
back and forth between .NET programs and stored procedures.  They are
also used for prepared SQL commands and queries that must be precompiled
so it can be executed multiple times without having to recompile the SQL
command.

Thanks,
Daniel