title: List.Where( "string".Contains()) returns NULL in a LINQ Query
body: <p>My <code>Product</code> class: </p>
  
  <pre><code>public class Product {
   public int Id { get; set; }
   public string NameEnglish { get; set; }
   public string NameItalian { get; set; }
  }
  </code></pre>
  
  <p>My <code>Language</code> class:</p>
  
  <pre><code>public class Language{
    public int Id { get; set; }
    public string LanguageType { get; set; }
  }
  </code></pre>
  
  <p>and I have a method which searches in Products using "Name" properties and returns <code>List&lt;Product&gt;</code>:</p>
  
  <pre><code>List&lt;Product&gt; GetProductsFromSearch(int languageId, string searchedData){
      var products = _contex.Products.ToList();
      switch(languageId) //LanguageId 1 = English , LangaugeId 2 = Italian
      {
         case 1:
              return products.Where(i=&gt;i.NameEnglish.Contains(searchedData)).ToList();
         case 2:
              return products.Where(i=&gt;i.NameItalian.Contains(searchedData)).ToList();
         default:
              return products;
      }
  }
  </code></pre>
  
  <p>The problem is, some of the products "English" or "Italian" name fields are not assigned in Db <strong>yet</strong>, so those are <strong>null</strong> fields.</p>
  
  <p>And program gives error "Object reference not set to an instance of an object".</p>
  
  <p>So I added an extra control which is :</p>
  
  <pre><code>return products.Where(i=&gt; !string.isNullOrEmpty(i.NameEnglish) &amp;&amp; 
  
                            i.NameEnglish.Contains(searchedData)).ToList()
  </code></pre>
  
  <p>But still I got the same <strong>error</strong>. Could someone help please? I got confused, shouldn't it <strong>pass</strong> the <strong>null</strong> fields?</p>
  
  <p><strong>NOTE:</strong>
   I know I should filtering directly in <code>_context.Products.Where(i=&gt;i.NameEnglish.Contains(searchedData)).ToList();</code>
  but this is for my <strong>test</strong> purposes, I'm trying to use "Where", in a "List" type.</p>
  
  <pre><code>Id | NameEnglish | NameItalian
  1  | Ball        | Palla
  2  | Phone       | Telefono
  3  | Tshirt      | NULL
  4  | NULL        | Bicchiere
  </code></pre>
  
  <p><strong>NOTE:</strong> I had 12 rows now I have 4. (It didn't changed the result but I've deleted for you to see my table clearly)</p>