DbCommand[
^] accepts only reference to your connection and command text (query). Optionally, you can create command from connection itself. Check my example:
using (var sqlConn = new MySqlConnection("your connection string"))
{
sqlConn.Open();
using (var cmd = sqlConn.CreateCommand())
{
cmd.CommandText = "your sql query with @paramName";
cmd.Parameters.AddWithValue("@paramName", null);
var numRows = cmd.ExecuteNonQuery();
var value = cmd.ExecuteScalar();
using (var reader = cmd.ExecuteReader())
{
if (reader.HasRows)
{
while (reader.Read())
{
var colValue = reader.GetString(0);
}
}
}
}
}