/// <summary>
/// Performs analysis and returns a list of problems detected
/// </summary>
/// <param name="ruleExecutionContext">Contains the schema model and model element to analyze</param>
/// <returns>
/// The problems detected by the rule in the given element
/// </returns>
public override IList <SqlRuleProblem> Analyze(SqlRuleExecutionContext ruleExecutionContext)
{
var problems = new List <SqlRuleProblem>();
var sqlObj = ruleExecutionContext.ModelElement;
if (sqlObj == null || sqlObj.IsWhiteListed())
{
return(problems);
}
var fragment = ruleExecutionContext.ScriptFragment.GetFragment(ProgrammingAndViewSchemaTypes);
var tableHintVisitor = new TableHintVisitor();
var queryHintVisitor = new StatementListVisitor();
var joinHintVisitor = new JoinVisitor();
fragment.Accept(tableHintVisitor, queryHintVisitor, joinHintVisitor);
var tableOffenders =
from n in tableHintVisitor.NotIgnoredStatements(RuleId)
where n.HintKind != TableHintKind.NoLock
select n;
var queryOffenders =
from o in queryHintVisitor.NotIgnoredStatements(RuleId)
from o1 in o.Statements
let s = o1 as StatementWithCtesAndXmlNamespaces
where s?.OptimizerHints != null && s?.OptimizerHints.Count > 0
select s;
var joinOffenders =
from j in joinHintVisitor.NotIgnoredStatements(RuleId)
where j is QualifiedJoin &&
((QualifiedJoin)j).JoinHint != JoinHint.None
select j as QualifiedJoin;
problems.AddRange(tableOffenders.Select(o => new SqlRuleProblem(Message, sqlObj, o)));
problems.AddRange(queryOffenders.Select(o => new SqlRuleProblem(Message, sqlObj, o)));
problems.AddRange(joinOffenders.Select(o => new SqlRuleProblem(Message, sqlObj, o)));
return(problems);
}
/// <summary>
/// Performs analysis and returns a list of problems detected
/// </summary>
/// <param name="ruleExecutionContext">Contains the schema model and model element to analyze</param>
/// <returns>
/// The problems detected by the rule in the given element
/// </returns>
public override IList <SqlRuleProblem> Analyze(SqlRuleExecutionContext ruleExecutionContext)
{
var problems = new List <SqlRuleProblem>();
var sqlObj = ruleExecutionContext.ModelElement;
if (sqlObj == null || sqlObj.IsWhiteListed())
{
return(problems);
}
var fragment = ruleExecutionContext.ScriptFragment.GetFragment(ProgrammingAndViewSchemaTypes);
var visitor = new TableHintVisitor();
fragment.Accept(visitor);
var offenders =
from n in visitor.Statements
where n.HintKind == TableHintKind.NoLock
select n;
problems.AddRange(offenders.Select(o => new SqlRuleProblem(Message, sqlObj, o)));
return(problems);
}
