Count list item based on ID

Question

1.00/5 (1 vote)

See more:

i want to find List<> item based on filter like where

SQL

Based on ID Like 
1     a    ajay
1     b    rubi
3     c    rakhi
3     d    reshi
3     f    rail

output
should be
select count from table where id=1
O/p= 2
where id=3
O/P=3

in LINQ how we can implement.

Thanks.

What I have tried:

Nothing

Posted 9-Nov-16 1:35am

Updated 9-Nov-16 16:58pm

v3

Comments

Karthik_Mahalingam 9-Nov-16 8:14am

Not clear, use improve question to add more info.

2 solutions

Add a Solution

Treat my content as plain text, not as HTML

…

Sign in to your account

Download, Vote, Comment, Publish.

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Midi_Mick · Answer 1 · 2016-11-09T16:58:00

IEnumerable has a count extension that takes a func<tsource,bool> parameter, so this becomes as simple as

C#

int count = table.Count(rec=>rec.id == 1);

Posted 9-Nov-16 16:58pm

Comments

Member 11449483 10-Nov-16 1:43am

Thanks.

OriginalGriff · Answer 2 · 2016-11-09T01:49:00

Use Where:

C#

List<string> data = new List<string>() { "hello there", "goodbye", "whoo there" };
var filtered = data.Where(s => s.Contains("o t"));

Returns an enumerable with the first and last strings only.

Posted 9-Nov-16 1:49am

Updated 9-Nov-16 1:50am

v2