C ??? SQL ?? ??

??:

SQL ??? ?? ???? ?? ??? ??? ? ?? ??? ?? ??? ??? ??? ?? ? ???? ?? ? ??? ??? ? ??? ???? ?? ??? ??? ? ????? ?? ?? ??? ?? ??? ??? ?? "?? ??" ??? ????? ???.

??:

????! Transact-SQL(?? Microsoft SQL Server)? ?? Microsoft.SqlServer.Management.SqlParser.Parser ??????? ??? ? ????. ?? SQL Server? ???? ??? ??? ???? Microsoft.SqlServer.Management.SqlParser.dll ????? ???? ????.

??? T-SQL? ???? ?? ???? ?? ???? ? ??? ? ?? ??? ????.

IEnumerable<tokeninfo> ParseSql(string sql)
{
    ParseOptions parseOptions = new ParseOptions();
    Scanner scanner = new Scanner(parseOptions);

    int state = 0,
        start,
        end,
        lastTokenEnd = -1,
        token;

    bool isPairMatch, isExecAutoParamHelp;

    List<tokeninfo> tokens = new List<tokeninfo>();

    scanner.SetSource(sql, 0);

    while ((token = scanner.GetNext(ref state, out start, out end, out isPairMatch, out isExecAutoParamHelp)) != (int)Tokens.EOF)
    {
        TokenInfo tokenInfo =
            new TokenInfo()
            {
                Start = start,
                End = end,
                IsPairMatch = isPairMatch,
                IsExecAutoParamHelp = isExecAutoParamHelp,
                Sql = sql.Substring(start, end - start + 1),
                Token = (Tokens)token,
            };

        tokens.Add(tokenInfo);

        lastTokenEnd = end;
    }

    return tokens;
}

TokenInfo ???? ???? ??? ??? ?? ??? ??????. Tokens? TOKEN_BEGIN, TOKEN_COMMIT, TOKEN_EXISTS? ?? ??? ???? ??????.

??: ? ??????? ?? http://m.miracleart.cn/link/e6e8bbe351bf19f963820a96543f25db?? ??? NuGet ???? ??? ? ????.

? ??? ?? ??? SQL ???? ?? ??? ???? ??? ??? ??? ? ?????? ?? ?????. ??? ??? PHP ??? ????? ?? ?? ??? ?????!