title: how to convert multiple linq statement to selectmany
body: <p>I am a beginner with LINQ and lambda function's. I was wondering how can i convert multiple linq statement to one statement using selectmany function.</p>
  
  <pre><code>string viewname = (from a in StoredProcedureParameters.Tables[0].AsEnumerable()
                   where a.Field&lt;string&gt;("ViewName") == displayName
                   select a.Field&lt;string&gt;("View")).Single();
  
  DateTime date = (from d in StoredProcedureParameters.Tables[0].AsEnumerable()
                  select d.Field&lt;DateTime&gt;("Date")).First();
  </code></pre>
  
  <p>Thanks for help in advance.</p>