title: How to ignore blank lines with linq when importing from CSV.
body: <p>Since I have just started linq, the question may be considered noob</p>
  
  <p>I have a scenario where I have to import  a remote csv and update it in database.</p>
  
  <p>Previously I was using traditional approach i.e reading line by line splitting and the updating.</p>
  
  <p>The query that I have written is as follows</p>
  
  <pre><code>var WItems = 
      ( from ln in File.ReadAllLines(FilePath).Skip(1)
      let columns = ln.Split(',')
      select new
      {
          Style = Convert.ToString(columns[0].Trim()),
          UPC = Convert.ToString(columns[1].Trim()),
          Description = Convert.ToString(columns[2].Trim()),
          FabricContent = Convert.ToString(columns[3].Trim()),
          CareInstruction = Convert.ToString(columns[4].Trim()),
          Color = Convert.ToString(columns[5]),
          Size = Convert.ToString(columns[6].Trim()),
          Price = Convert.ToString(columns[7].Trim()),
          Category = Convert.ToString(columns[8].Trim()),
          SubCategory = Convert.ToString(columns[9].Trim()),
          Stock = Convert.ToString(columns[10].Trim()),
  
      } ).ToList();
  </code></pre>
  
  <p>This query works well when there are no blank lines at the bottom, but throws error if there are blank lines at the bottom. My question is how can i split only those lines Which has something written or which is not blank.</p>