public async Task <int> CreateAndRunUpdateAsync(string table, string where, string[] fields, params object[] values)
{
return(await OdbcCommands.CreateUpdate(await ConnectAsync(), table, where, fields, values).ExecuteNonQueryAsync());
}
public async Task <int> CreateAndRunInsertAsync(object[] values, string table, string fields)
{
return(await OdbcCommands.CreateInsert(await ConnectAsync(), table, SqlUtility.ToArrayFromCommas(fields), values).ExecuteNonQueryAsync());
}
public async Task <int> CreateAndRunDeleteAsync(string table, string where)
{
return(await OdbcCommands.CreateDelete(await ConnectAsync(), table, where).ExecuteNonQueryAsync());
}
public async Task <ConnectedOdbcDataReader> CreateAndRunCommandAsync(string command, params string[] args)
{
OdbcConnection connection = await ConnectAsync();
return(await RunCommandAsync(connection, OdbcCommands.CreateCommand(connection, command, args)));
}