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);
}
