Linq vs Loop Which is best

Question

2.00/5 (1 vote)

See more:

Hi,
I have a list of Items. I can either use a Linq query or for loop to get the data that is needed by me. But I wanted to know which is Best ?

I think Linq works as same way of creating a loop and parsing the values and extract the data that is given in the query. Correct me if I am wrong..

Posted 2-Sep-13 19:24pm

Prasaad SJ

Add a Solution

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

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)

Sergey Alexandrovich Kryukov · Accepted Answer · 2013-09-02T19:31:00

Solution 1

LINQ. It actually depends on LINQ to what. If this is, for example, LINQ to SQL, your speculations about loop are not correct at all. Apparently, LINQ is translated to SQL query, which is passed to the server part, which is optimized for processing queries, so performance difference could be striking.

—SA

Posted 2-Sep-13 19:31pm

Sergey Alexandrovich Kryukov

Comments

Prasaad SJ 3-Sep-13 5:36am

Hi.. Thanks for the answer. But my question is I have a list, Say 100 items in the list. What is the advantage of using Linq query over the loop here?

Sergey Alexandrovich Kryukov 3-Sep-13 12:16pm

You can time the operation. Even if your loop code takes the same time in this case, LINQ is better because it makes the code more elegant...

Also, I would pay attention not for performance of searching for anything in the list, but to general design of your code and the ways to avoid such search. Maybe you need some redundancy (performance is commonly gained by adding redundancy) and use associative containers (Dictionary, SortedDictionary, SortedList)...

—SA