Deadlock on Linq to Entity Framework Core 2.0 Table

async-await asynchronous entity-framework-core linq

Question

I'm getting what I think to be a deadlock when trying to run a bunch of linq queries in parallel.

I am running a Task.WhenAll() on this method:

public async Task<MetabuildScan> GetLatestMetabuildScanAsync(string buildId)
{
    var metabuildScanStatuses = new[] { "Completed", "Referenced" };

    // Get the latest metabuild scan for this image build
    var latestScan = await (from scan in _qsaContext.MetabuildScans
                           where scan.SoftwareImageBuildId == buildId
                           && metabuildScanStatuses.Contains(scan.SIScanStatus)
                           orderby scan.SIScanStartedOn descending
                           select scan).FirstOrDefaultAsync();

    // If there is a related scan, then use that one, else, use the one we just got
    var latestCompletedScanId = latestScan?.RelatedScanId ?? latestScan?.Id;

    return await _qsaContext.MetabuildScans
                 .FirstOrDefaultAsync(scan => scan.Id == latestCompletedScanId);
}

I am getting a System.InvalidOperationException: A second operation started on this context before a previous operation completed. Any instance members are not guaranteed to be thread safe.

_qsaContext was created using Entity-Framework Core.

At first, I thought the FirstOrDefaultAsync would fix my issue (I had a non-asynchronous FirstOrDefault in there at first), but it didn't.

I'm wondering what the best solution to get around this deadlock would be. The table I am selecting from is a large table, so I can't pull the whole table into memory.

1
0
7/7/2018 12:40:24 AM

Fastest Entity Framework Extensions

Bulk Insert
Bulk Delete
Bulk Update
Bulk Merge

Popular Answer

Entity Framework DbContext is not thread safe. You can't run parallel queries against it like you are attempting to do.

If you need to have a shared context for your queries that you'll need to await each one individually and sequentially.

If they don't need a shared context but do need to run in parallel then you'll need to have a separate context for each query.

If using a DI framework, perhaps you can look into making your DbContext Transient (instead of what I'm assuming is Scoped) and injecting that into a query class that will call your query methods.

0
7/10/2018 3:38:54 PM

Related Questions

Entity Framework Core async/wait deadlock when using "one-to-many" relationship and WebApi

I'm encountering a deadlock when using asynchronous implementation of an EF Core provider....Say I have the following models:...public class Player { public string PlayerId { get; set;} public string Name { get; set;} public List<Game> Games { get; set;} } public class Game { public string GameId { get; set; } public string ...
asp.net-web-api async-await c# entity-framework-core rx.net
asked by Tomer Peled

Installing Entity Framework Core 2.0 in a .NET Framework Class Library Project Yields Invalid References

This can be fixed by letting MSBuild autogenerate the necessary binding redirects by explicitly setting these two properties inside the ...csproj... file (You can put the ...<ItemGroup>... as a child element below the root ...<Project>... element or add to an exiting ...<ItemGroup>... without a ...Condition=... attribute):...<PropertyGroup> <Auto...
.net-core-2.0 c# entity-framework-core visual-studio-2017
asked by Martin Ullrich

Execute SQL command in Entity Framework Core 2.0 to delete all data in a table

I want to execute an SQL command from Entity Framework Core 2.0, but I can't figure out how to do so....1.- The reason why I need to, is that I want to delete all data from a database table, and using ...Context.remove... or ...Context.removeRange... would produce many calls to DB (one for each data in the table)....2.- I've read that there is a me...
asp.net-core-2.0 c# entity-framework-core sql
asked by MorgoZ

How to create Table per type inheritance in Entity Framework Core 2.0 code first?

TPT is not in EF Core (yet). See ...The feeling from our team is that TPT is generally an anti-pattern and results in significant performance issues later on. While enabling it may make some folks "happier" to start with it ultimately just leads to issues. We are willing to consider it though, so we're leaving this open and will consider i...
.net-core entity-framework entity-framework-core
asked by David Browne - Microsoft

Table per Type in Entity Framework Core 2.0

You would have to change your Model to look like this, note that you can't use inheritance using this approach:...public class Company { public int CompanyId { get; set; } //... } public class Company { public int CompanyId { get; set; } public string Name { get; set; } //... } public class HeadOffice { [ForeignKey(nameof(Compan...
c# entity-framework entity-framework-core
asked by LuckyLikey

Entity Framework Core 2.0 default value for common property in many tables

I am doing code first EF Core 2.0 migrations. I have few columns which are common across all entities. All entities inherit this class as shown below....How do I set the default value for CreateDate as current date, CreateBy as 'System' and IsDeleted as 0?...public class BaseEntity { public DateTime CreateDate { get; set; } public string C...
asp.net-core-2.0 entity-framework-core
asked by Mukil Deepthi

How to read from a table without a primary key in Entity Framework Core 2.0?

Based on my research in last few days, EF Core's DBSet only works with table with Identity or Primary key. The whole EF Core is based on change tracking and almost always has CRUD in mind, so a key is mandatory. For ad-hoc or read only scenarios, DBSet is not suitable. EF Core team is working on DBQuery type that is supposed to work with table/view...
entity-framework entity-framework-core primary-key sql-server
asked by Samuel An

Create object containing a list using Dynamic Linq Core with Entity Framework 2.0

You'd need to support a subquery on ...Warehouses.... I'll copy the relevant steps listed in ...this answer...:...add the following in ...ParseAggregate...: ...Expression ParseAggregate(Expression instance, Type elementType, string methodName, int errorPos) { // Change starts here var originalIt = it; var originalOuterIt = outerIt; // ...
c# dynamic-linq entity-framework-core list
asked by HeyJude

Entity Framework Core 2.0 many-to-many relationships same table

I'm using ...Entity Framework Core 2.0... to map exist DB, the DB has two tabels: ...Teams... and ...SupportTeam.... ...Team Fields:... ID, Name...TeamSupport...: TeamID (ForeignKey on Team Table), SupportTeamID (ForeignKey on Team Table)...I tried to map them as following:... public class Team { public int Id { get; set; } public stri...
c# entity-framework-core
asked by Shannak

How to specify default property values for owned entity types in Entity Framework Core 2.0?

Assuming you understand what EF Core ...Default Values... are for, and just looking for equivalent of ...Entity<T>().Property(...)... equivalent. ...The owned entities are always configured for each owner type by using the ...ReferenceOwnershipBuilder<TEntity,TRelatedEntity>... class methods. To access this class you either use the result of ...Ow...
asp.net entity-framework-core
asked by Ivan Stoev

Fastest Entity Framework Extensions

Bulk Insert
Bulk Delete
Bulk Update
Bulk Merge
View more on Stack Overflow

Prime Library

Performance

Expression Evaluator

More Projects...

Related

Licensed under: CC-BY-SA with attribution
Not affiliated with Stack Overflow
Licensed under: CC-BY-SA with attribution
Not affiliated with Stack Overflow