Does EF Core have a connection pool?

Multi-tenancy and connection pool using EF 6

We have developed a multi-tenant application using EF 4.3 Code First Model, where each tenant will have their own separate database. Since, we are expecting bit high number of tenants, we want to maintain the connection pool across tenants. ...In order to achieve this in EF 4.3 Code First model, we have created 'AppMaster' database and developed ow...

EF Core and big traffic leads to max pool size was reached error

I am adding an alternative answer, in case anyone lands here with a slightly different root cause, as was the case for my .NET Core MVC application....In my scenario, the application was producing these "timeout expired... max pool size was reached" errors due to mixed use of ...async.../...await... and ...Task.Result... within the same controller....

Is this an EF Core bug or an I doing it wrong to update one entity?

I'm using Entity Framework Core together with the repository pattern. To help me out, I coded one base repository with the basic CRUD methods. The update method is as follows:...public void Update(TEntity entity) { var contextEntry = _context.Entry<TEntity>(entity); if (contextEntry.State == EntityState.Dettached) { _context.Att...

EF Core 2.0 connection string in Azure Functions .NET Core

You can use ...Environment.GetEnvironmentVariable.... The keys are "ConnectionStrings:YourKey"...Assuming your local.settings.json looks like the following:...{ "IsEncrypted": false, "Values": { "AzureWebJobsStorage": "UseDevelopmentStorage=true", "AzureWebJobsDashboard": "UseDevelopmentStorage=true" }, "ConnectionStrings": { "s...

Error while doing Migrations EF core 2.0, changing Identity id from string to int

Scenario:...I have received auto generated project in ASP.NET CORE from my colleague. There is auto-generated code for Account/Manage service. This code includes ApplicationUser Class, DBContext and migration folder with 00000000000000_CreateIdentitySchema.cs and 20180323155805_Snapshot.cs. I have been trying to change my User class to have intege...

EF Core with DbContext pool and multi tenancy - database per tenant

I need to solve problem with multi tenancy in entity framework core. Each tenant gets own database (for historical reasons, this can not be changed)....I will use context factory as suggested on many places (...example 1..., ...example 2..., ...example 3...)....My questions are:...can I use context pooling with this approach...can I use ...IMutable...

What is the difference between EF Core Database-First and EF Core Code-First approaches?

I was wondering... since there is no EDMX in EF Core, what is the difference between those 2? And if the major difference would be the possibility to change the database tables, why not use code first then use EF code-first migrations?

'No suitable constructor found for entity type' when doing EF Core migration (SmartEnum)

I am attempting to run ...update-database... to migrate some changes that I made to my db....It all goes well until I get the following error:...No suitable constructor found for entity type 'ReportType'. The following constructors had parameters that could not be bound to properties of the entity type: cannot bind 'id', 'name' in 'ReportType...

.Net Core, Stored Procedures and Connection Pooling

I have a .NET Core Web API service that will call two stored procedures (and nothing else). I am wondering how to accomplish these calls in .NET Core....At first I was thinking about using Entity Framework Core for my database connection. I was considering EF Core because I know it handles a lot of hard bits about connecting to the database (for ex...

EF 6 Connection pool and stored query strings RAM leak

I have 2 problems....First one is that Connection pool and (OracleConnectionImpl) is growing steadily over time, till it reaches out of memory exception. As you can see on the image, it has 90 MB over 3-4 hours of running....I am using short lived contexts everywhere, but it keeps on growing and never clears itself. Is there any way for me to clear...