public static RunScriptResult RunScript(string script, string connectionString)
{
var runErrors = new List <string>();
using (TextReader reader = new StringReader(script))
{
TSqlParser parser = new TSql110Parser(true);
TSqlFragment fragment = parser.Parse(reader, out var errors);
if (errors != null && errors.Count > 0)
{
foreach (ParseError error in errors)
{
runErrors.Add($"Line: {error.Line}, Column: {error.Column}: {error.Message}");
}
return(new RunScriptResult {
Errors = runErrors.ToArray()
});
}
SqlScriptGenerator sqlScriptGenerator = new Sql110ScriptGenerator();
if (!(fragment is TSqlScript sqlScript))
{
sqlScriptGenerator.GenerateScript(fragment, out var sql);
if (!ExecuteSql(sql, connectionString, runErrors))
{
return(new RunScriptResult {
Errors = runErrors.ToArray()
});
}
}
public override void ExplicitVisit(InsertStatement node)
{
base.ExplicitVisit(node);
NewStatement.StartPos = node.StartOffset;
NewStatement.Length = node.FragmentLength;
var whyle = BuildWhileStatement(node.InsertSpecification);
var scriptGen = new Sql110ScriptGenerator();
string script;
scriptGen.GenerateScript(whyle, out script);
NewStatement.NewText = script;
}
public override void ExplicitVisit(InsertStatement node)
{
base.ExplicitVisit(node);
NewStatement.StartPos = node.StartOffset;
NewStatement.Length = node.FragmentLength;
var whyle = BuildWhileStatement(node.InsertSpecification);
var scriptGen = new Sql110ScriptGenerator();
string script;
scriptGen.GenerateScript(whyle, out script);
NewStatement.NewText = script;
}
private static SqlScriptGenerator GetGenerator(GenerationOptions options)
{
SqlScriptGenerator generator = null;
switch (options.SqlVersion)
{
case SqlVersion.Sql80:
generator = new Sql80ScriptGenerator();
break;
case SqlVersion.Sql100:
generator = new Sql100ScriptGenerator();
break;
case SqlVersion.Sql110:
generator = new Sql110ScriptGenerator();
break;
case SqlVersion.Sql120:
generator = new Sql120ScriptGenerator();
break;
case SqlVersion.Sql130:
generator = new Sql130ScriptGenerator();
break;
case SqlVersion.Sql140:
generator = new Sql140ScriptGenerator();
break;
case SqlVersion.Sql150:
generator = new Sql150ScriptGenerator();
break;
default:
generator = new Sql90ScriptGenerator();
break;
}
generator.Options.Apply(options);
return(generator);
}
public static string FormatSqlCode(string query)
{
var parser = new TSql110Parser(false);
IList <ParseError> errors;
var parsedQuery = parser.Parse(new StringReader(query), out errors);
var generator = new Sql110ScriptGenerator(new SqlScriptGeneratorOptions()
{
KeywordCasing = KeywordCasing.Uppercase,
IncludeSemicolons = true,
NewLineBeforeFromClause = true,
NewLineBeforeOrderByClause = true,
NewLineBeforeWhereClause = true,
AlignClauseBodies = false
});
string formattedQuery;
generator.GenerateScript(parsedQuery, out formattedQuery);
return(formattedQuery);
}
private void button1_Click(object sender, EventArgs e)
{
TextReader rdr = new StringReader(textBox1.Text);
IList <ParseError> errors = null;
TSql110Parser parser = new TSql110Parser(true);
TSqlFragment tree = parser.Parse(rdr, out errors);
foreach (ParseError err in errors)
{
Console.WriteLine(err.Message);
}
Sql110ScriptGenerator scrGen = new Sql110ScriptGenerator();
string formattedSQL = null;
scrGen.GenerateScript(tree, out formattedSQL);
textBox2.Text = formattedSQL;
rdr.Dispose();
}
