Lambda group by query with count in mvc5 C#

See more:

C#

LINQ

MVC

lambda

I am writing lambda query to get some details from table. I want to get count of each same records with 'UserID' and 'AssetId'.

My table structure is as follows.

UserID     AssetID      ProductName   ProductLocate
---------------------------------------------------
user1        as1           p1              c1
user1        as1           p2              c2
user1        as1           p3              c3
user2        as2           p4              c4
user2        as2           p5              c5

After querying I want data in the below form

UserID     AssetID      ProductName   ProductLocate Count
----------------------------------------------------------
user1        as1                                     3
user2        as2                                     2
How can I do it?

What I have tried:

I dont know how. My code is not correct right now.