ArmedCards.DataAccess.Card.Select.Execute C# (CSharp) Method

Select Class Documentation Show file Open project: kwmcrell/ArmedCards

Execute() public method

Select cards based on a filter

public Execute ( Entities filter ) : List
filter	Entities	The filter used to select cards
return	List

        public List<Entities.Card> Execute(Entities.Filters.Card.Select filter)
        {
            List<Entities.Card> cards = new List<Entities.Card>();

            using (DbCommand cmd = _db.GetStoredProcCommand("Card_Select"))
            {
                _db.AddInParameter(cmd, "@DeckIDs", DbType.Xml, filter.DeckIDs.ConvertCollectionToXML());

                using (IDataReader idr = _db.ExecuteReader(cmd))
                {
                    while (idr.Read())
                    {
                        cards.Add(new Entities.Card(idr));
                    }
                }
            }

            return cards;
        }

Select

Execute

Select