title: How to use Linq to compare two column in Sql
body: <p>Sql Table:</p>
  
  <pre><code>ID      User        Pass
  1       John        09o0s
  2       Jim         bd09d
  </code></pre>
  
  <p>C#:</p>
  
  <pre><code>string u = the user name provided by someone;
  string p = the password provided by someone;
  
  List&lt;DataRow&gt; list = dt.AsEnumerable().ToList();
  
  bool trueor =  list.Any(user =&gt; user.Equals(strU));
  </code></pre>
  
  <p>How can I use Linq to see if the username provided has an entry and if it does, is the password provided match the username.</p>