title: How can I get the count in linq?
body: <p>I have table called <code>products</code> with columns:</p>
  <pre><code>productid ,
  productname,
  productprice
  categoryid
  </code></pre>
  <p>My problem is I want to get the number of products depending on product name along with details.  I want to show the data in <code>DataGridView</code>. How can I know the number of products for a single product name like below?</p>
  <pre><code>productid        productname          productavailable        productprice
  --------------------------------------------------------------------------
  1                product A            2 products(product A)   100
  2                product B            5 Products(product B)   200
  </code></pre>
  <p>Like the above table I have to display in <code>DataGridView</code>. I am using LINQ and C# and my <code>DbContext</code> name is <code>tsgdbcontext</code>.</p>