title: Pulling all rows from database then displaying them to a table
body: <p>Ok I have been searching for a day and a half with no luck. I have a simple Microsoft SQL database and I want to pull two rows from then display it in a view. What I have tried so far was </p>
  
  <pre><code> public IEnumerable&lt;Char&gt; FindAllUsers()
          {
              var t = db.Users.SelectMany(c =&gt; c.FirstName).ToList();
  
              List&lt;Char&gt; list = t;
  
              return list;
  
          }
  </code></pre>
  
  <p>I have also tried </p>
  
  <pre><code>IEnumerable&lt;User&gt; name = db.Users
                           .Select(FirstName =&gt; FirstName)
                           .ToList();
              return name;
  
  List&lt;User&gt; name = db.Users
                           .Select(FirstName =&gt; FirstName)
                           .ToList();
  </code></pre>
  
  <p>With no luck. I feel that I am not going about this the right way. Any help would be appreciated. </p>