Help with .NET8 and Connection issue

[rmiranda-or]

Hi
First of all, congrats on the library, it's incredible.

I am facing an issue here using .NET8 which I could not find the solution yet and I am guessing is related to the connection string I am using.
There are what I am using at the moment:

net8.0

ConnString format at the moment, which I am using in my .NET app settings:

server=XXXXXXXX,3306;
User ID=XXXXX;
Password=XXXXXXX;
Database=XXXXXXX;

It's being very intermittent and giving this error:
An error occurred using the connection to database

My startup.cs file I have this, specific version of Aurora MySQL (AWS):
var auroraVersion = ServerVersion.Create(new Version(8, 0, 39), ServerType.MySql);

Appreciate your help.
Thanks,

[alexeygritsenko]

If you want to build a connection string dynamically instead of from a configuration file, use MySqlConnectionStringBuilder
example:

using MySqlConnector;

var builder = new MySqlConnectionStringBuilder
{
    Server = "localhost",
    Port = 3306,
    Database = "testdb",
    UserID = "user",
    Password = "pass",
    SslMode = MySqlSslMode.None
};

string connectionString = builder.ConnectionString;

It works great for me on net8.0 and hasn't caused any disconnects in production for a month. So I think you have an AWS issue.

[adamkirkton]

@rmiranda-or I'm a fellow cloud user of MySQL. In my case it's Google Cloud and I run into this error intermittently as well. The good news is that I believe this is retried automatically. EF will close the connection and try another one and unless there is some larger outage, this works fine. I believe this is just related to the inherent complexity of cloud setups and that there tend to be more transient issues like this where there was some kind of network hiccup that caused what should have been a good connection in the pool to actually have dropped. I have never seen these errors paired with any kind of actual application error, it's just an internal one that can be safely ignored.