How To DEALLOCATE PREPARE Statement In C# Using Mysql.Data Client?

hope you guys are fine?

OK.. i am using MySQL.Data client/library to access and use MySQL database. I was using happily it for sometimes on quite a few project. But suddenly facing a new issue that causing me hold on my current project. 🙁

Because current project makes some (looks like it’s a lot) db queries. and i am facing following exception :

Can't create more than max_prepared_stmt_count statements (current value: 16382)

i am closing and disposing the db engine/connection every time i am done with it. But getting damn confused why i am still getting this error.

​here is the sample code just to give you idea.. (trimmed out unnecessary parts)

//this loop call an API with pagination and get API response
while(ContinueSalesOrderPage(apiClient, ref pageNum, days, out string response, window) == true)    
{
    //this handle the API date for the current page, it's normally 500 entry per page, and it throws the error on 4th page
    KeyValueTag error = HandleSalesOrderPageData(response, pageNum, out int numOrders, window);   
}

private KeyValueTag HandleSalesOrderPageData(string response, int pageNum, out int numOrders, WaitWindow window)
{
    numOrders = json.ArrayOf("List").Size;

    //init db
    DatabaseWriter dbEngine = new DatabaseWriter()
    {
        Host = dbHost,
        Name = dbName,
        User = dbUser,
        Password = dbPass,
    };

    //connecting to database
    bool pass = dbEngine.Connect();

    //loop through all the entry for the page, generally it's 500 entries
    for(int orderLoop = 0; orderLoop < numOrders; orderLoop++)
    {
        //this actually handle the queries, and per loop there could be 3 to 10+ insert/update query using prepared statements
        KeyValueTag error = InsertOrUpdateSalesOrder(dbEngine, item, config, pageNum, orderLoop, numOrders, window);
    } 

    //here as you can see, i disconnect from db engine, and following method also close the db connection before hand
    dbEngine.Disconnect();

}

//code from DatabaseWriter class, as you see this method close and dispose the database properly
public void Disconnect()
{
    _CMD.Dispose();
    _engine.Close();
    _engine.Dispose();
}

so, as you can see i close/dispose the database connection on each page processing, but still it shows me that error on 4th page. FYI, 4th page data is not the matter i checked that. If i skip the page and only process the 4th page, it process successfully.

and after some digging more in google, i found prepare statement is saved in database server and that needs to be close/deallocate. But i can’t find any way to do that using MySQL.Data Client 🙁

following page says:

https://dev.mysql.com/doc/refman/8.0/en/sql-prepared-statements.html

A prepared statement is specific to the session in which it was  created. If you terminate a session without deallocating a  previously prepared statement, the server deallocates it  automatically. 

but that seems incorrect, as i facing the error even after closing connection on each loop

so, i am at dead end and looking for some help here? 

thanks in advance

best regards