I'm developing WPF - EF Core desktop application for multiple users. I have to connect to a MySql server with a limited number of connections. Testing with a single desktop client i see my connections grows 3-4 instances so i'm worry worried about it.
I really dont understand why because my code only calls one instance at the same time.
How i could decrease these numbers? May be MySql maintains a minimun opened connections pool ? Can i force to EF Core to use only one instance for a desktop application instance?
Edit:
It's an Azure MySql database (limited opened connections per instance). I attach an active connections graph. First graphic's part (range values between 4-7) is when i'm using a single desktop user test, then i stop and connections come back to 4.
All my calls are synchronous and with this structure:
using(var context = database.getContext())
{
//Calls to database
db.Savechanges(); // if needed
}