title: Count rows of data and display in view ASP.net MVC
body: <p>All i'm trying to do is count how many bookings have requested wheelchair access not sure with the best way....</p>
  
  <pre><code>using (var context = new TalyllynContext()) 
          {
              var count = context.Bookings.SqlQuery(" SELECT * FROM dbo.Booking Where Wheelchair_Access = 'true' ").Count();
          }
          ViewBag.Count = count;
  </code></pre>
  
  <p>This is what i want to happen in the SQL, but not sure how to make the view bag Count display the variable or is there a much better solution</p>
  
  <p>In the view it can be anything as long as it shows the count value !! </p>