End-User Documentation

Retrieve SQL Statements from an Assembly

Retrieve SQL Statements from an Assembly

Retrieval lets you inspect discovered statements without validating them immediately, which is useful for tooling, reporting, or custom test flows.

Steps

  1. Call QueryLens.RetrieveSqlStatementsFromAssembly(assembly).
  2. Inspect the returned SqlStatement instances and their Text, StatementType, and Parameters.
  3. Run additional validation selectively if you only care about a subset of discovered statements.

Example

var statements = QueryLens.RetrieveSqlStatementsFromAssembly(typeof(OrderQueries).Assembly);

Assert.NotEmpty(statements);
Assert.Contains(statements, s => s.StatementType == SqlStatementType.Query);

Related