dotnet/efcore

commandTimeout for some query only

Open

#18,895 opened on Nov 14, 2019

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

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

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
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.