title: Web API using Entity Framework to query by multiple columns
body: <p>Using EF6, I'm creating a Web API project. When I add a Controller, the EntityKey is the default column queried ("Id"), which works fine. I want to add additional columns to query within the same table via the API, which I'm unable to get to work.</p>
  
  <p>For example, I can query Id (/api/CtrlName/123456), but if I want to query via say a Title column, /api/CtrlName?title="value", it always comes back with a NotFound message.</p>
  
  <p>Is there a simple tutorial to set this functionality up within the Controller?</p>
  
  <pre><code>    [ResponseType(typeof(Article))]
      public IHttpActionResult GetArticle(string id)
      {
          Article article = db.Articles.Find(id);
          if (article == null)
          {
              return NotFound();
          }
  
          return Ok(article);
      }
  
      [ResponseType(typeof (Article))]
      public IHttpActionResult GetArticleByTitle(string title)
      {
          Article article = db.Articles.Find(title);
          {
              if (article == null)
                  return NotFound();
          }
  
          return Ok(article);
      }
  
      private bool ArticleExists(string id)
      {
          return db.Articles.Count(e =&gt; e.Id == id) &gt; 0;
      }
  
      private bool ArticleExistsTitle(string title)
      {
          return db.Articles.Count(b =&gt; b.title.Contains(title) ) &gt; 0;
      }
  </code></pre>