DBcontext is getting shared while being registered as Scoped

asp.net-core c# ef-core-2.2 entity-framework-6

Question

I am trying to migrate from ef6 to ef core and started getting below problems

System.InvalidOperationException: 'A second operation started on this context before a previous operation completed. This is usually caused by different threads using the same instance of DbContext, however instance members are not guaranteed to be thread safe. This could also be caused by a nested query being evaluated on the client, if this is the case rewrite the query avoiding nested invocations.'

on:

_dbContext
    .Query<EntityModel>()
    .FromSql(query, new SqlParameter("@userId", userId))
    .ToList();
1
0
4/19/2019 1:19:46 PM

Fastest Entity Framework Extensions

Bulk Insert
Bulk Delete
Bulk Update
Bulk Merge

Accepted Answer

I solved this once by adding MultipleActiveResultSets=true to the connectionstring.

Example:

string connectionString = "Data Source=MSSQL1;" +   
  "Initial Catalog=AdventureWorks;Integrated Security=SSPI;" +  
  "MultipleActiveResultSets=True";

From: https://docs.microsoft.com/en-us/dotnet/framework/data/adonet/sql/enabling-multiple-active-result-sets

Just add it in your appsettings.json connectionstring

1
4/19/2019 1:29:04 PM

Related Questions

Am I crazy for using Entity Framework with an OleDB connection?

The approach you are using to build the EF connection string is correct....BUT......The Entity Framework only works with Providers (i.e. SqlClient) that support something called provider services....The OleDB provider doesn't support 'Provider Services' so you can't use EF with the OleDb (unless you can find a third party OleDb provider with suppor...
c# entity-framework ms-access
asked by Alex James

Which Entity Framework version am I using?

Another way to get the EF version you are using is to open the Package Manager Console (PMC) in Visual Studio and type Get-Package at the prompt. The first line with be for EntityFramework and list the version the project has installed....PM> Get-Package Id Version Description/Release Notes ...
entity-framework
asked by ChrisS

What am I doing wrong with MySQL and Entity Framework?

I got past this error by adding a reference to MySql.Data.Entity.dll (and MySql.Web.dll)
.net entity-framework mysql nullreferenceexception visual-studio-2010
asked by Rami A.

How to identify Dbcontexts (to prevent singleton context for entire application)

The best solution would be to use a ...Unit of Work... to wrap the Data Context, as well as managing the connection lifetime and allowing you to work with multiple Repositories (if you were so inclined to go down that path)....Summary of implementation:...Create an interface (...IUnitOfWork...) which exposes properties for your ...DbSet...'s, as we...
asp.net-mvc c# entity-framework
asked by RPM1984

In System.Data.Entity.dll (Entity Framework), why am I receiving a NullReferenceException?

I got the same problem when accidently loading a Module multiple times in a modular Architecture....Additional, the Module(s) where using 2 copies of the same ...DbContext..., trying to connect one Entity from one Context to another Entity of the other Context....This masked the ...InvalidOperationException... (cannot use an Entity in multiple Trac...
c# entity-framework wpf
asked by FrankM

Why am I getting this "Invalid object name 'dbo.*'" error with MVC4?

I experienced this problem and found a solution, which requires that the User Schema in SQL is that of the dbo schema thus the tables are created with dbo. at the beginning of them, problem solved. ...I am presuming this is a bug that will need fixed by MS.
asp.net-mvc-4 entity-framework visual-studio-2012
asked by Gareth Bow

Error on Cout but i am not using Count in my LINQ exrpression,

Now with EF6 you can have lambda expressions in your Skip and Take parameters, and in fact its better to do so as the SQL Query is cached and re-used on subsequent pages: ...see this article...But you still need to have evaluated the parameter to pass as @Grant does. So the difference being....Skip(() => skipAmount .Take(() => rows)
asp.net-mvc-5 c# entity-framework-6 linq-to-entities
asked by Peter Kerr

AspNet.Identity Custom User and Custom Role should be simple; what am I missing?

Try this way. I had the same issue, you need to provide the id. ... // // POST: /Account/Register [HttpPost] [AllowAnonymous] [ValidateAntiForgeryToken] public async Task<ActionResult> Register(RegisterViewModel model) { if (ModelState.IsValid) { var user = new ApplicationUser() { ...
asp.net-identity asp.net-mvc asp.net-mvc-5 entity-framework entity-framework-6
asked by Peter Hurtony

I am trying to return XML data from Entity Framework

You can use that:... using (SqlConnection con = new SqlConnection(_dbContext.Database.Connection.ConnectionString)) { #region Connection Open SqlCommand cmd = new SqlCommand("mbl_GetCourseMat", con); cmd.CommandType = System.Data.CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@Par1...
c# entity-framework-6 xml
asked by Ergin Çelik

DbContext global scope vs method level scope

There's even a third approach based on manual or automatic ...dependency injection...:...public interface ISomeService { // Interface members } public class SomeService : ISomeService { public SomeService(DbContext dbContext) { DbContext = dbContext; } private DbContext DbContext { get; } } ...Then, ...SomeService..
c# entity-framework entity-framework-6
asked by Matías Fidemraizer

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