/// <summary> /// TODO: use sqlite returning statement. /// https://github.com/ericsink/SQLitePCL.raw/issues/416. /// </summary> /// <param name="transaction">The transaction.</param> /// <param name="startsWith">The start string to deleted.</param> public ValueTask <int> DeleteByStartsWithAsync(IDbTransaction transaction, string startsWith) { return(transaction.ExecuteNonQueryAsync( () => DeleteByStartsWithPathCommand, $"{nameof(DatabaseTable)}/{nameof(DeleteByStartsWithPathCommand)}/{TableName}", SqliteTransaction.EscapeLikeContent(startsWith) + "%")); }
public ValueTask <DataRow[]> SelectByStartsWithAsync( IDbTransaction transaction, string startsWith) { return(transaction.ExecuteReaderAsync( () => SelectByStartsWithPathCommand, $"{nameof(DatabaseTable)}/{nameof(SelectByStartsWithPathCommand)}/{TableName}", HandleReaderDataRows, SqliteTransaction.EscapeLikeContent(startsWith) + "%")); }