MySqlDataSource source;

// Asynchronous
await source.ExecuteNonQueryAsync("INSERT INTO `table` (`col`) VALUES (@col)", [
    new MySqlParameter("col", value)
]);

// Synchronous
source.ExecuteNonQuery("INSERT INTO `table` (`col`) VALUES (@col)", [
    new MySqlParameter("col", value)
]);

MySqlDataSource source;

// Asynchronous
await foreach( MySqlDataReader reader in source.ReadAsync("SELECT `col` FROM `table`") ) {
    string value = reader.GetString("col");
    
    // ...
}

// Synchronous
foreach( MySqlDataReader reader in source.Read("SELECT `col` FROM `table`") ) {
    string value = reader.GetString("col");
    
    // ...
}

MySqlDataSource source;

// Asynchronous
string[] values = await source.ReadAsync("SELECT `col` FROM `table`")
    .Select(reader => reader.GetString("col"))
    .ToArrayAsync();

// Synchronous
values = source.Read("SELECT `col` FROM `table`")
    .Select(reader => reader.GetString("col"))
    .ToArray();

MySqlDataReader reader;

// TryGet
reader.TryGetString("col", out string? value);
reader.TryGetByte("col", out byte value);
reader.TryGetSByte("col", out sbyte value);
reader.TryGetInt16("col", out short value);
reader.TryGetUInt16("col", out ushort value);
reader.TryGetInt32("col", out int value);
reader.TryGetUInt32("col", out uint value);
reader.TryGetInt64("col", out long value);
reader.TryGetUInt64("col", out ulong value);
reader.TryGetFloat("col", out float value);
reader.TryGetDouble("col", out double value);
reader.TryGetMySqlDateTime("col", out MySqlDateTime value);
reader.TryGetDateTimeOffset("col", out DateTimeOffset value);
reader.TryGetDateTime("col", out DateTime value);
reader.TryGetDateOnly("col", out DateOnly value);

// Nullables
string? value = reader.GetNullableString("col");
byte? value = reader.GetNullableByte("col");
sbyte? value = reader.GetNullableSByte("col");
short? value = reader.GetNullableInt16("col");
ushort? value = reader.GetNullableUInt16("col");
int? value = reader.GetNullableInt32("col");
uint? value = reader.GetNullableUInt32("col");
long? value = reader.GetNullableInt64("col");
ulong? value = reader.GetNullableUInt64("col");
float? value = reader.GetNullableFloat("col");
double? value = reader.GetNullableDouble("col");
MySqlDateTime? value = reader.GetNullableMySqlDateTime("col");
DateTimeOffset? value = reader.GetNullableDateTimeOffset("col");
DateTime? value = reader.GetNullableDateTime("col");
DateOnly? value = reader.GetNullableDateOnly("col");

MySqlDataSource source;

MyObject[] values = await source.ReadAsync("SELECT `col` FROM `table`")
    .SelectMany(reader => reader.GetJsonEnumerableAsync<MyObject>("col"))
    .ToArrayAsync();

await foreach( MySqlDataReader reader in source.ReadAsync("SELECT `col` FROM `table`") ) {
    // MyObject? value = reader.GetJson<MyObject>("col");
    MyObject? value = await reader.GetJsonAsync<MyObject>("col");
}