using MySql.Data.MySqlClient; using System.Threading.Tasks; public async TaskUpdateRowAsync(string name, int age, string email, int id) { using (MySqlConnection conn = new MySqlConnection(myConnectionString)) { await conn.OpenAsync(); MySqlCommand cmd = conn.CreateCommand(); cmd.CommandText = "UPDATE users SET name=@name, age=@age, email=@email WHERE id=@id"; cmd.Parameters.AddWithValue("@name", name); cmd.Parameters.AddWithValue("@age", age); cmd.Parameters.AddWithValue("@email", email); cmd.Parameters.AddWithValue("@id", id); return await cmd.BeginExecuteNonQueryAsync(); } }
using MySql.Data.MySqlClient; using System.Threading.Tasks; public async TaskThis code deletes all rows from a table called "users". The BeginExecuteNonQueryAsync method is called to asynchronously execute the command. The MySqlCommand.BeginExecuteNonQuery method is part of the MySql.Data package library.DeleteAllRowsAsync() { using (MySqlConnection conn = new MySqlConnection(myConnectionString)) { await conn.OpenAsync(); MySqlCommand cmd = conn.CreateCommand(); cmd.CommandText = "DELETE FROM users"; return await cmd.BeginExecuteNonQueryAsync(); } }