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

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

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

                using(IDataReader idr = _db.ExecuteReader(cmd))
                {
                    while(idr.Read())
                    {
                        messages.Add(new Entities.ChatMessage(idr, filter.OffsetHours));
                    }
                }
            }

            return messages;
        }