Hi,
ich hab mir ne kleine MySQL Klasse geschrieben. Diese funkioniert auch wunderbar. Bloß bei querys mit Joins stürzt er bei adapter.Fill/adapter.Fillasync ab.
Select Function
PHP Code:
public async Task<DataSet> Select(string query, Dictionary<string, dynamic> parameters)
{
var ds = new DataSet();
_connection = new MySqlConnection(_connectionString);
await _connection.OpenAsync();
_command = new MySqlCommand(query, _connection);
var adapter = new MySqlDataAdapter(_command);
foreach (var param in parameters)
{
_command.Parameters.AddWithValue(param.Key, param.Value);
}
await adapter.FillAsync(ds);
return ds;
}
Query
PHP Code:
private async Task<bool> CheckLinkedAccount(Message msg)
{
const string query = "SELECT * FROM registered_users JOIN apler_users ON registered_users.phone_number = apler_users.phone_number WHERE apler_users.phone_number = ?phone_number AND registered_users.telegram_userID = ?telegram_userID;";
Dictionary<string, dynamic> parameters = new Dictionary<string, dynamic>();
parameters.Add("?phone_number", msg.Contact.PhoneNumber);
parameters.Add("?telegram_userID", msg.From.Id);
using (var mysql = new AsyncMySql())
{
var ds = await mysql.Select(query, parameters);
return false;
}
}
Der Query funktioniert in HeidiSQL.
Kann mir da jemand helfen?