ArmedCards.DataAccess.GamePlayerCard.Select.Execute C# (CSharp) Метод

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

            using (DbCommand cmd = _db.GetStoredProcCommand("GamePlayerCard_Select"))
            {
                _db.AddInParameter(cmd, "@GameID", DbType.Int32, filter.GameID);

                if (filter.UserId.HasValue)
                {
                    _db.AddInParameter(cmd, "@UserId", DbType.Int32, filter.UserId.Value);
                }

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

            return playerCards;
        }