title: How can I make this LINQ query?
body: <p>I have a Dropdownlist that I fill with all consultants.</p>
  
  <p>This is my entities I am using for this LINQ query:</p>
  
  <p><img src="https://i.stack.imgur.com/NX3IN.png" alt="enter image description here"></p>
  
  <p>What I want to do is to get all consultants ids that have a goalcard with Complete_date set. I have no idea how to do this.</p>
  
  <p>Right now I have this following LINQ query to get all consultants ids.</p>
  
  <pre><code>public List&lt;Consultant&gt; GetAllConsultantsByID()
  {
      var allConsultants = from id in db.Consultant
                           select id;
      return allConsultants.ToList();
  }
  </code></pre>
  
  <p>Any kind of help is appreciated</p>
  
  <p>Thanks in advance</p>
  
  <p>Update:</p>
  
  <p>This is how I have to use my Linq method in my Get Action Method:</p>
  
  <pre><code>var consultants = repository.GetAllConsultantsByID();
  model.Consultants = new SelectList(consultants, "Id", "Name");
  </code></pre>