queryguard-dotnet

KO | EN

gitlite — search

#ai-agent #windows #svg #agents #monitoring #golang #claude-code #database #csharp #awesome-list

queryguard-dotnet

(★ 9)

Find repeated EF Core queries and catch query problems in tests. NuGet: https://www.nuget.org/packages/QueryGuard.Testing

File Explorer

ZIP Download

- dotnet-tools.json
- - bug_report.yml
  - config.yml
  - false_positive.yml
  - feature_request.yml
  - provider_report.yml
- - ci.yml
  - codeql.yml
  - dependency-review.yml
  - docs.yml
  - release.yml
- CODEOWNERS
- dependabot.yml
- pull_request_template.md
- release.yml
- action.yml
- publish.sh
- README.md
- - FingerprintBenchmarks.cs
  - Program.cs
  - QueryGuard.Benchmarks.csproj
- Directory.Build.props
- - index.md
- - queryguard-demo.svg
  - queryguard-icon.png
  - queryguard-logo.svg
  - queryguard-social-preview.png
- - README.md
- - public-project-validation.md
- - README.md
- - README.md
- - 0001-public-personal-repo.md
  - 0002-session-propagation.md
  - 0003-detector-terminology.md
  - 0004-parameter-privacy.md
  - 0005-sql-fingerprints.md
  - 0006-aspnet-observe-only.md
  - 0007-stack-trace-policy.md
  - 0008-target-frameworks.md
  - 0009-provider-matrix.md
  - 0010-testing-api.md
  - 0011-versioning.md
  - 0012-trusted-publishing.md
  - 0013-baseline-storage.md
  - README.md
  - toc.yml
- - README.md
- - README.md
- - false-positives.md
  - README.md
- benchmarks.md
- coding-standards.md
- docfx.json
- index.md
- README.md
- releasing.md
- review-checklist.md
- roadmap.md
- testing-strategy.md
- toc.yml
- verify-packages.sh
- - CompanyCatalog.cs
  - Program.cs
  - QueryGuard.SampleApi.csproj
- - BaselineComparisonDemoTests.cs
  - CompanyEndpointDemoTests.cs
  - queryguard-baseline.json
  - QueryGuard.SampleTests.csproj
- Directory.Build.props
- README.md
- - PACKAGE.md
  - QueryGuard.AspNetCore.csproj
  - QueryGuardApplicationBuilderExtensions.cs
  - QueryGuardEventIds.cs
  - QueryGuardMiddleware.cs
  - QueryGuardOptions.cs
  - QueryGuardRouteName.cs
  - QueryGuardServiceCollectionExtensions.cs
- - PACKAGE.md
  - QueryGuard.AspNetCore.Testing.csproj
  - QueryGuardWebApplicationMeasurement.cs
  - WebApplicationFactoryQueryGuardExtensions.cs
- - CommandLine.cs
  - PACKAGE.md
  - Program.cs
  - QueryGuard.Cli.csproj
- - AsyncLocalQueryGuardSessionAccessor.cs
  - CompletedQueryGuardSession.cs
  - IQueryBudgetEvaluator.cs
  - IQueryFingerprintFactory.cs
  - IQueryGuardRedactor.cs
  - IQueryGuardSessionAccessor.cs
  - IQueryGuardSessionActivation.cs
  - ISqlNormalizer.cs
  - PACKAGE.md
  - QueryBudgetEvaluator.cs
  - QueryCommandKind.cs
  - QueryFinding.cs
  - QueryFindingKind.cs
  - QueryFingerprint.cs
  - QueryFingerprintFactory.cs
  - QueryFingerprintGroup.cs
  - QueryGuard.Core.csproj
  - QueryGuardAllowlistEntry.cs
  - QueryGuardAnalyzer.cs
  - QueryGuardAssemblyMarker.cs
  - QueryGuardBaseline.cs
  - QueryGuardBaselineComparison.cs
  - QueryGuardBaselineEntry.cs
  - QueryGuardBaselineFormatException.cs
  - QueryGuardCaptureOptions.cs
  - QueryGuardOrigin.cs
  - QueryGuardOriginFormatter.cs
  - QueryGuardPolicy.cs
  - QueryGuardQueryTag.cs
  - QueryGuardRedactor.cs
  - QueryGuardResult.cs
  - QueryGuardSession.cs
  - QueryGuardSeverity.cs
  - QueryRecord.cs
  - RuleNames.cs
  - SqlNormalizer.cs
  - SqlStringLiteralScanner.cs
- - PACKAGE.md
  - QueryGuard.EntityFrameworkCore.csproj
  - QueryGuardCommandInterceptor.cs
  - QueryGuardDbContextOptionsBuilderExtensions.cs
  - SqlCommandClassifier.cs
- - IQueryGuardReporter.cs
  - PACKAGE.md
  - QueryGuard.Reporting.csproj
  - QueryGuardBaselineMarkdownReporter.cs
  - QueryGuardConsoleReporter.cs
  - QueryGuardJsonReporter.cs
  - QueryGuardJsonReportReader.cs
  - QueryGuardJUnitReporter.cs
  - QueryGuardReporter.cs
  - QueryGuardSarifReporter.cs
- - PACKAGE.md
  - QueryGuard.Testing.csproj
  - QueryGuardAssert.cs
  - QueryGuardBudgetExceededException.cs
  - QueryGuardScope.cs
- Directory.Build.props
- - CatalogDbContexts.cs
  - Program.cs
  - QueryGuard.AspNetCore.Testing.TestApp.csproj
- - QueryGuard.AspNetCore.Testing.Tests.csproj
  - WebApplicationFactoryQueryGuardExtensionsTests.cs
- - InMemoryLogSink.cs
  - QueryGuard.AspNetCore.Tests.csproj
  - QueryGuardMiddlewareTests.cs
  - QueryGuardRouteNameTests.cs
  - RequestIsolationStressTests.cs
  - SampleApplicationFactory.cs
- - CommandLineTests.cs
  - QueryGuard.Cli.Tests.csproj
  - VersionTests.cs
- - AsyncLocalQueryGuardSessionAccessorTests.cs
  - BuildConfigurationTests.cs
  - FalsePositiveFixtureTests.cs
  - FullSqlFingerprintTests.cs
  - ProviderSqlFixtures.cs
  - ProviderStringLiteralTests.cs
  - QueryBudgetEvaluatorTests.cs
  - QueryFindingTests.cs
  - QueryFingerprintFactoryTests.cs
  - QueryFingerprintGroupTests.cs
  - QueryFingerprintTests.cs
  - QueryGuard.Core.Tests.csproj
  - QueryGuardAllowlistTests.cs
  - QueryGuardAnalyzerTests.cs
  - QueryGuardBaselineComparisonTests.cs
  - QueryGuardBaselineTests.cs
  - QueryGuardOriginTests.cs
  - QueryGuardPolicyTests.cs
  - QueryGuardRedactorTests.cs
  - QueryGuardResultTests.cs
  - QueryGuardSessionTests.cs
  - QueryRecordTests.cs
  - SessionIsolationStressTests.cs
  - SqlNormalizerTests.cs
  - StackTraceCaptureTests.cs
  - TestData.cs
- - CommandClassificationTests.cs
  - LongQueryFingerprintTests.cs
  - QueryGuard.EntityFrameworkCore.Tests.csproj
  - QueryGuardCommandInterceptorTests.cs
  - ReadClassificationRegressionTests.cs
  - SampleDbContext.cs
  - UseQueryGuardTests.cs
- - DockerFact.cs
  - MySqlProviderTests.cs
  - PostgreSqlProviderTests.cs
  - QueryGuard.ProviderTests.csproj
  - SqliteProviderSuiteTests.cs
  - SqlServerProviderTests.cs
- - FullSqlFingerprintReportingTests.cs
  - ProviderStringPrivacyTests.cs
  - QueryGuard.Reporting.Tests.csproj
  - QueryGuardBaselineMarkdownReporterTests.cs
  - QueryGuardConsoleReporterTests.cs
  - QueryGuardJsonReporterTests.cs
  - QueryGuardJUnitReporterTests.cs
  - QueryGuardSarifReporterTests.cs
  - ReportFixture.cs
- - OriginReportingTests.cs
  - QueryGuard.Testing.Tests.csproj
  - QueryGuardAssertTests.cs
  - QueryGuardScopeTests.cs
- Directory.Build.props
.editorconfig
.gitattributes
.gitignore
action.yml
CHANGELOG.md
CODE_OF_CONDUCT.md
CONTRIBUTING.md
Directory.Build.props
Directory.Packages.props
global.json
LICENSE
QueryGuard.slnx
README.md
SECURITY.md
SUPPORT.md

# Use via CDN

jsDelivr

jsDelivr serves any public GitHub repository as a CDN with zero setup. Pick a version and a file to get a ready-to-paste link and snippet.

Version

File

Link

Example

// repository documentation

Was this content helpful?

★ 0 (0 ratings)

<h1 align="center">QueryGuard.NET</h1>

<p align="center">
  Find repeated EF Core queries and catch query problems in tests.
</p>

QueryGuard counts database queries and checks them against limits you set.
For example, you can fail a test when the same query runs more than 5 times.

Repeated queries can be a sign of an N+1 problem. Some repeats are expected,
so you can allow them with a reason.

## Quick start

Add this package to your ASP.NET Core test project:

```bash
dotnet add package QueryGuard.AspNetCore.Testing
```

Run a request and check its queries:

```csharp
using Microsoft.AspNetCore.Mvc.Testing;
using QueryGuard;
using QueryGuard.AspNetCore.Testing;
using QueryGuard.Testing;

using var factory = new WebApplicationFactory<Program>();
await using var guard = factory.TrackQueries<Program, AppDbContext>(
    "GET /api/companies",
    QueryGuardPolicy.Create("companies")
        .WithMaxOccurrencesPerFingerprint(5));

var response = await guard.Client.GetAsync("/api/companies");
response.EnsureSuccessStatusCode();

QueryGuardAssert.Passes(await guard.CompleteAsync());
```

Replace `Program`, `AppDbContext`, and the route with your app's values.
This test fails if a query with the same SQL pattern runs more than 5 times.

Works with xUnit, NUnit, MSTest, and TUnit.
For services and background jobs, see the [testing guide](./docs/testing/README.md).

## Packages

| Package | Use |
| --- | --- |
| `QueryGuard.AspNetCore.Testing` | Test ASP.NET Core requests |
| `QueryGuard.Testing` | Test services and background jobs |
| `QueryGuard.AspNetCore` | Track queries during HTTP requests |
| `QueryGuard.Reporting` | Export console, JSON, JUnit, Markdown, or SARIF reports |
| `QueryGuard.Cli` | Save query counts and check for changes in CI |

## Support

- .NET 8 and 10, with EF Core 8 and 10.
- Tested with SQLite, PostgreSQL, SQL Server, and MySQL. See [provider details](./docs/providers/README.md).
- EF Core only. Dapper and raw ADO.NET are not tracked.
- Parameter values and connection strings are not captured. SQL is redacted before reporting.

## Try the sample

```bash
git clone https://github.com/Benziza/queryguard-dotnet.git
cd queryguard-dotnet
dotnet test samples/QueryGuard.SampleTests
```

The sample shows a request that runs 51 queries and a fix that runs just one.

## Learn more

- [Documentation and API reference](https://benziza.github.io/queryguard-dotnet/)
- [Query limits and settings](./docs/configuration/README.md)
- [Save and compare query counts in CI](./docs/baselines/README.md)
- [GitHub Action](./action/README.md)
- [Troubleshooting](./docs/troubleshooting/README.md)
- [Contributing](./CONTRIBUTING.md) · [Report a security issue](./SECURITY.md)

## License

[MIT](./LICENSE). Inspired by [Bullet](https://github.com/flyerhzm/bullet) for Rails.

queryguard-dotnet

File Explorer

# Use via CDN

Was this content helpful?

Recent Feedback

Download README