dotnet/efcore

commandTimeout for some query only

Open

#18.895 aberto em 14 de nov. de 2019

Ver no GitHub
 (12 comments) (2 reactions) (0 assignees)C# (3.376 forks)batch import
area-querycustomer-reportedgood first issueneeds-design

Métricas do repositório

Stars
 (14.651 stars)
Métricas de merge de PR
 (Mesclagem média 23d 13h) (154 fundiu PRs em 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();

Guia do colaborador