title: DataTable.Select.Where VB.Net - Delete rows
body: <p>I'm currently pulling information using a query that I'm not allowed to tamper with:</p>
  
  <pre><code>Dim dt As DataTable = BLL.GetData(variable).Tables(0)
  </code></pre>
  
  <p>Immediately afterwards, I'm removing any records where a field begins with a specific value:</p>
  
  <pre><code>For Each dr As DataRow In dt.Rows
      If dr.Item(2).ToString().StartsWith("value") Then
          dr.Delete()
      End If
  Next
  </code></pre>
  
  <p>What I'd really like to do is something like:</p>
  
  <pre><code>dt.Select.Where(field1 =&gt; field1.StartsWith("value")).Delete()
  </code></pre>
  
  <p>I know that is not the syntax of it and I'm probably very off from what it would be like.  The <code>For Each</code> works fine, I'm just trying to "simplify" it.  Any idea?  Any and all help is appreciated.  </p>