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); }