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 17d 16h) (132 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
Implement an extension method on IQueryable that sets command timeout at the query level. This will require modifying the query pipeline to pass a timeout value to the underlying database command. Review existing global command timeout implementation in DbContextOptionsBuilder and related code in Microsoft.EntityFrameworkCore.Storage namespace. Potential files: DbContextOptionsBuilder.cs, RelationalDatabaseFacadeExtensions.cs, and query compilation classes.
Tech stack
csharpsql
Domain
backenddatabase
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.
Stale
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.
60