title: C# to SQL ExecuteReader() getting stuck
body: <p>When running the below method in my application the app freezes and when I pause VS it seems to be stuck on the line that goes:</p>
  
  <pre><code>SqlDataReader reader = select.ExecuteReader();
  </code></pre>
  
  <p>I've got other SQL methods running fine so I know the connection string is correct, I've double checked the SQL and that's fine. Am I wrong in think the reader variable can not contain the returning value of the scalar function when the ExecuteReader() is called?</p>
  
  <pre><code>public static bool AccountValidation(string username, string password)
  {
      string statement = "select dbo.AccountValidation('" + username + "','" + password + "')";
      SqlCommand select = new SqlCommand(statement, connect);
      connect.Open();
      SqlDataReader reader = select.ExecuteReader();
      string result = reader.ToString();
      connect.Close();
  
      if (result != "true")
      {
          return false;
      }
      else
      {
          return true;
      }
  }
  </code></pre>