public IEnumerable <ICharacterStatusEffectTable> Execute(CharacterID id) { var ret = new List <ICharacterStatusEffectTable>(4); using (var r = ExecuteReader(id)) { while (r.Read()) { var item = new CharacterStatusEffectTable(); item.ReadValues(r); ret.Add(item); } } return(ret); }