title: Implement Smart Search with Entity framework
body: <p>I am trying to implement search functionality in my ApiController. What I am trying to do is : To create api for client that will take a single string as input like <strong>"Nike 2016"</strong>. And my api should return records only from <strong>"Nike" brand</strong> and from <strong>"2016" year</strong>. </p>
  
  <p>Below is my model class. <strong>I am using Entity Framework.</strong></p>
  
  <pre><code>class ProductEntity
      {
          public int Year { get; set; }
          public string TAGS { get; set; }
          public Dimension Dimension { get; set; }
          public int Rating { get; set; }
          public string UserId { get; set; }
          public string Brand { get; set; }
          public double NumberOfFloors { get; set; }
          public string CostOfBuilding { get; set; }
      }
  
      class Dimension
      {
          public double length { get; set; }
          public double width { get; set; }
      }
  </code></pre>
  
  <p>I have tried with searching with "or" keyword in all the columns but with that approach I am worried that api is going to be very slow. I want a scalable approach that wouldn't affect performance.</p>