public void Analyze_return_null_report_for_parametrized_queries() { var analyzer = new UnparametrizedWhereClausesPerformanceAnalyzer(); var command = DbCommandUtils.CreateCommand("SELECT * FROM Customers WHERE Id=@Id"); var report = analyzer.Analyze(command, TimeSpan.FromSeconds(1)); Assert.Null(report); }
public void Analyze_return_report_if_exist_any_non_parametrized_parameter() { var commandText = "SELECT * FROM [dbo].Customers WHERE FirstName = @Unai AND LastName = 'Zorrilla'"; var analyzer = new UnparametrizedWhereClausesPerformanceAnalyzer(); var command = DbCommandUtils.CreateCommand(commandText); var report = analyzer.Analyze(command, TimeSpan.FromSeconds(1)); Assert.NotNull(report); Assert.Equal(report.Message, Strings.UnparametrizedWhereClause(commandText)); }
public void Analyze_return_report_for_non_parametrized_queries_and_without_formated_whitespaces() { var commandText = "SELECT * FROM [dbo].Customers WHERE FirstName='Unai'"; var analyzer = new UnparametrizedWhereClausesPerformanceAnalyzer(); var command = DbCommandUtils.CreateCommand(commandText); var report = analyzer.Analyze(command, TimeSpan.FromSeconds(1)); Assert.NotNull(report); Assert.Equal(report.Message, Strings.UnparametrizedWhereClause(commandText)); }
public void Analyze_return_report_for_query_with_values_without_quotes() { var commandText = "SELECT * FROM [dbo].Customers WHERE Age= 36"; var analyzer = new UnparametrizedWhereClausesPerformanceAnalyzer(); var command = DbCommandUtils.CreateCommand(commandText); var report = analyzer.Analyze(command, TimeSpan.FromSeconds(1)); Assert.NotNull(report); Assert.Equal(report.Message, Strings.UnparametrizedWhereClause(commandText)); }