public async Task RemoveAllAsync(PersistedGrantFilter filter) { var filterEntity = new PersistedGrantFilterEntity(filter); await using var connection = new MySqlConnection(_connectionString); string sql = "delete from tbl_user_persistedgrant where SubjectId = @SubjectId AND SessionId = @SessionId AND ClientId = @ClientId AND Type = @Type"; await connection.ExecuteAsync(sql, filterEntity); }
public async Task <IEnumerable <PersistedGrant> > GetAllAsync(PersistedGrantFilter filter) { var filterEntity = new PersistedGrantFilterEntity(filter); await using var connection = new MySqlConnection(_connectionString); string sql = "select * from tbl_user_persistedgrant where SubjectId = @SubjectId AND SessionId = @SessionId AND ClientId = @ClientId AND Type = @Type"; var result = await connection.QueryAsync <PersistedGrantEntity>(sql, filterEntity); var models = result.Select(x => x.ToDomain()); return(models); }