public void SprocVisitor()
{
var visitor = new StoredProcVisitor();
TSqlScript script = Parse("StoredProc.sql");
script.Accept(visitor);
Assert.IsTrue(visitor.HasNocountOn);
Assert.IsTrue(visitor.HasTransactionIsolationLevel);
Assert.IsTrue(visitor.HasComments);
}
public override IList<RuleProblem> Analyze(RuleContext context)
{
TSqlScript script = context.ScriptFragment as TSqlScript;
Debug.Assert(script != null, "TSqlScript is expected");
Visitor = new StoredProcVisitor();
script.Accept(Visitor);
if (Visitor.WasVisited && !(Visitor as StoredProcVisitor).HasNocountOn)
{
AddProblem(Resources.SetNoCountOnRule);
}
return Problems;
}
public override IList <RuleProblem> Analyze(RuleContext context)
{
TSqlScript script = context.ScriptFragment as TSqlScript;
Debug.Assert(script != null, "TSqlScript is expected");
Visitor = new StoredProcVisitor();
script.Accept(Visitor);
if (Visitor.WasVisited && !(Visitor as StoredProcVisitor).HasNocountOn)
{
AddProblem(Resources.SetNoCountOnRule);
}
return(Problems);
}
