dotnet/efcore

commandTimeout for some query only

Open

#18,895 opened on Nov 14, 2019

View on GitHub
 (12 comments) (2 reactions) (0 assignees)C# (3,376 forks)batch import
area-querycustomer-reportedgood first issueneeds-design

Repository metrics

Stars
 (14,651 stars)
PR merge metrics
 (Avg merge 23d 13h) (154 merged PRs in 30d)

Description

some query may take long time to complete, so I'm wondering if we could have an api for set command out for the long-time query only, not global?

maybe an extension method like follows:

var posts = dbContext.Posts.AsNoTracking()
    .Where(p=>p.Tile == "12131313")
    .WithCommandTimeout(20)
    .ToList();

Contributor guide

Research direction
Investigate how command timeout is currently applied globally (via DbContextOptions) and design an extension method on IQueryable<T> or DbSet<T> to allow per query timeout for long running queries. Consider compatibility with existing global timeout settings and how to pass the timeout to the underlying database command.
Tech stack
csharp
Domain
backend
Issue type
Feature
DifficultyEstimated implementation difficulty for a new contributor, from 1 for very small changes to 5 for expert-level work.
3
Estimated timeA rough time range for an experienced contributor to investigate, implement, test, and prepare a pull request.
1-2 days
Activity statusHow available the issue appears right now: fresh, active, stale, blocked, or waiting on maintainer input.
Active
ClarityHow clearly the issue explains the expected change, acceptance criteria, and next step.
Clear
Prerequisites
C#Entity Framework Core
Newbie friendlinessA 1-100 score estimating how approachable this issue is for first-time contributors.
65