C#?? SQL ?? ?? ??

??: C#? ???? SQL ??? ?? ???? ?? ??? ???? ?? ??? ?? ??? ?? ??? ?? ??? ??? ?? ??? ???? ?? ??? ??? ???? ??? ??? ???? ???. ?? ?? ??? ?? ??? ??? ?? ?? ??? "?? ??"?? ????? ???.

??:

Transact-SQL(Microsoft SQL Server)? ?? SQL Server? ?? Microsoft.SqlServer.Management.SqlParser.Parser ??????? ??? ? ????. ?? ??? ???? 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 Enum (Microsoft.SqlServer.Management.SqlParser.Parser)](https://docs.microsoft.com/en -us/ ??/API/ microsoft.sqlserver.management.sqlparser.parser.tokens?view=sqlparser-7.3)

TOKEN_BEGIN, TOKEN_COMMIT, TOKEN_EXISTS ? ?? ??? ?????.

????: ? ?? ??? ?? ??????: [Microsoft.SqlServer.Management.SqlParser](https://www.nuget.org/packages/Microsoft.SqlServer.Management.SqlParser ).

? ??? C#?? SQL ??? ?? ???? ?? ??? ???? ??? ??????? ?? ?????. ??? ??? PHP ??? ????? ?? ?? ??? ?????!