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

        public Entities.ActiveConnection Execute(Entities.Filters.ActiveConnection.Select filter)
        {
            Entities.ActiveConnection connection = null;

            using (DbCommand cmd = _db.GetStoredProcCommand("ActiveConnection_SelectById"))
            {
                _db.AddInParameter(cmd, "@ActiveConnectionID", DbType.String, filter.ActiveConnectionID);

                _db.AddInParameter(cmd, "@UserId", DbType.Int32, filter.UserId);

                using (IDataReader idr = _db.ExecuteReader(cmd))
                {
                    while (idr.Read())
                    {
                        connection = new Entities.ActiveConnection(idr);
                    }
                }
            }

            return connection;
        }