Using MySql.Data with C# while not making a MySqlConnection

Question

The reccomended way to use MySql.Data is to NOT use a MySqlConnection object; as explained in the documentation. This allows for the MySQl.Data API code to handle connection pooling correctly. See: mySQL documentation

So, for example, this code Selects data with the connection string passed in as a parameter.

The MySqlConnection object is created in the background:

        DataSet dataset = new DataSet();
        MySqlDataAdapter adapter = new MySqlDataAdapter("select * from cfx_jobs", _mySqlConnectionString);
        adapter.Fill(dataset);
        return dataset;

I have looked around and I cannot find an example of how to Insert into the database without explicitly creating a MySqlConnection object.

Which method should I use?

if using a DataAdapter, make your changes to the dataset and then call adapter.update(dataset) to update database with any changes — Jon Roberts
– Jon Roberts, Commented Feb 17, 2020 at 17:46
it is best to let the connection pooling system manage all connections. Do not create a globally accessible instance of MySqlConnection and then manually open and close it. Methinks the operative phrase is globally accessible. That said, if you create a 'global' DataAdapter and configure it, it will retain the MySqlCommand object to INSERT, DELETE and UPDATE as well as manage the connection. — Ňɏssa Pøngjǣrdenlarp
– Ňɏssa Pøngjǣrdenlarp, Commented Feb 17, 2020 at 18:33

Richard210363 · Accepted Answer · 2020-02-18 17:27:45Z

0

This is how to do it.

MySqlHelper.ExecuteNonQuery(_mySqlConnectionString, sqlStatement);

answered Feb 18, 2020 at 17:27

Richard210363

8,4266 gold badges41 silver badges67 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Using MySql.Data with C# while not making a MySqlConnection

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related