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

        public Entities.GameRound Execute(Entities.Filters.GameRound.SelectCurrent filter)
        {
            List<Entities.GameRound> gameRounds = new List<Entities.GameRound>();

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

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

            return gameRounds.FirstOrDefault();
        }