title: How to remove DBnull value from lambda query?
body: <p>i have this query </p>
  
  <pre><code>        DataSetTest DB = new DataSetTest();
          DataSetTestTableAdapters.TESTTableAdapter ADPT = new DataSetTestTableAdapters.TESTTableAdapter();
          ADPT.Fill(DB.TEST);
  
           try
          {
              var xx = DB.TEST.Where(s =&gt; s.Name != null).Select(s =&gt; s.Name).ToList();
          }
          catch (Exception ex)
          {
              var x = ex;
          }
  </code></pre>
  
  <p>But it give me this error </p>
  
  <pre><code>{"The value for column 'Name' in table 'TEST' is DBNull."}
  </code></pre>
  
  <p>so how can i allow DBnull value in the list or remove it many thanks in advance fro any help</p>