Filter data in dataset using LINQ and get result as list of strings
<p>I have dataset. I am trying to filter it on specific conditions:</p>

<ol>
<li>Column <strong>"display_name"</strong> has values of length <strong>7</strong>  </li>
<li>Column <strong>"display_name"</strong> has values starting with <strong>'N'</strong>  </li>
<li><p>Column "display_name" has values from <strong>1</strong> to <strong>6</strong> characters i.e <strong>substr(1,6)</strong> consists of any character from 0 to 9 </p></li>
<li><p>Then I want to return filtered result in list.  </p></li>
</ol>

<p>My code is as below:</p>

<pre><code> List&lt;DataRow&gt; filteredRows = ds.Tables[0].AsEnumerable()
                  .Where(x =&gt; (x.Field&lt;string&gt;("Display_name").Length==7) &amp;&amp; (x.Field&lt;string&gt;("Display_name").StartsWith("N"))  
</code></pre>

<p>Not able to get correct linq query. My first day of linq, so maybe I am not doing it right way.</p>