public void DeleteSetAndAssociatedCards(Set set) { var setId = ExecuteScalarValueQuery<long>(setSchemaBuilder.BuildSelectQuery(new[] {nameof(Set.SetId)}, setSchemaBuilder.CreateCondition(nameof(Set.Code), ConditionOperator.Equals, set), 1)); ExecuteNonQuery(setSchemaBuilder.BuildDeleteQuery( setSchemaBuilder.CreateCondition(nameof(Set.SetId), ConditionOperator.Equals, set))); ExecuteNonQuery(cardSchemaBuilder.BuildDeleteQuery( cardSchemaBuilder.CreateCondition(nameof(Card.Set), ConditionOperator.Equals, set))); }
public IEnumerable <CollectedCard> GetCollection() { return(ExecuteReader(collectionSchema.BuildSelectQuery(new[] { nameof(CollectedCard.Id), nameof(CollectedCard.Name), nameof(CollectedCard.CardQuality), nameof(CollectedCard.Foil), nameof(CollectedCard.MultiverseId), nameof(CollectedCard.SetCode), nameof(CollectedCard.SetName), }), reader => { var id = reader.GetString(0); var name = reader.GetString(1); var cardQuality = (CardQuality)reader.GetInt32(2); var foil = reader.GetBoolean(3); var multiverseId = reader.GetInt32(4); var setCode = reader.GetString(5); var setName = reader.GetString(6); return new CollectedCard(id, name, cardQuality, foil, multiverseId, setCode, setName); })); }