T-SQL Format C# Code

format.cs

class Program {
    static void Main(string[] args) {
        var query = "select A.ID, A.NAME from (select ID, NAME from BAR) A where A.ID = '1'";
        var parser = new TSql120Parser(false);
        IList<ParseError> errors;
        var parsedQuery = parser.Parse(new StringReader(query), out errors);
        if (errors.Count > 0) {
            foreach (var err in errors) {
                Console.ForegroundColor = ConsoleColor.Red;
                Console.WriteLine(err.Message);
                Console.ResetColor();
            }
        }
        var generator = new Sql120ScriptGenerator(new SqlScriptGeneratorOptions() {
            KeywordCasing = KeywordCasing.Uppercase, 
            IncludeSemicolons = true,
            NewLineBeforeFromClause = true,
            NewLineBeforeOrderByClause = true,
            NewLineBeforeWhereClause = true,
            AlignClauseBodies = false
        });
        string formattedQuery;
        generator.GenerateScript(parsedQuery, out formattedQuery);
        Console.WriteLine(formattedQuery);
    }
}

link.md

• MSDN
• NuGet

nuget.txt

Install-Package Microsoft.SqlServer.TransactSql.ScriptDom

Thank you - really helpful 👍

thanks for you help