Linq query to Count record in each Group using C# and VB.Net in ASP.Net

Last Reply 5 months ago By pandeyism

Posted 5 months ago

Im having two Table
In table 1:
Im having Column of (id) which is Unique

In table 2 :
Im Having Column Of UserId in which i'm storing the value of (id)
from table one

Now I want to Know the count of (id) in UserId column from table 2.

And whichever (id) has been assigned less time .
I want to make that Id available.

And whichever (id) has been assigned less time--This i will know by using Count.

I have tried alot ..but im not getting such type of Linq query

can u please help

 

 

This question does not have replies that have been liked.