dotnet/efcore

commandTimeout for some query only

Open

#18.895 geöffnet am 14. Nov. 2019

Auf GitHub ansehen
 (12 Kommentare) (2 Reaktionen) (0 zugewiesene Personen)C# (3.376 Forks)batch import
area-querycustomer-reportedgood first issueneeds-design

Repository-Metriken

Stars
 (14.651 Stars)
PR-Merge-Metriken
 (Durchschn. Merge 23T 13h) (154 gemergte PRs in 30 T)

Beschreibung

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