what is the difference between this two queries

Question

0.00/5 (No votes)

See more:

, +

SQL

from x in  Courses
where x.CourseName=="New Course1"
select x

SQL

Courses
   .Where (x => (x.CourseName == "New Course1"))

This two providing same result.
Which one is better in performance, and what is the difference between them .
what you suggest to use.

Thank you

Posted 20-Jan-14 18:30pm

Member 9877910

Add a Solution

3 solutions

Solution 1

It uses different ways to get the same data (obviously). One uses a Linq query, the other uses Linq extensions on the collection.

As far as performance, they are probably both around the same.

Posted 20-Jan-14 18:34pm

Ron Beyer

Comments

Christian Graus 21-Jan-14 0:35am

Beat me by less than a second !!! :-)

Ron Beyer 21-Jan-14 0:41am

And I work on DSL :)

Christian Graus 21-Jan-14 0:47am

Lol

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)

Christian Graus · Accepted Answer · 2014-01-20T18:34:00

Solution 2

The syntax. One is using the syntax that is made to look more like SQL, the other is using a method call ( which can be chained ). They both do the same thing, although there are some things that are easier with one approach or the other, and probably both generate exactly the same SQL, especially with a query as simple as this.

This is LINQ code, so it's one layer removed from the database. The database does not see this, it sees the SQL this gets turned in to.

Posted 20-Jan-14 18:34pm

Christian Graus

Comments

Member 9877910 21-Jan-14 0:40am

Thank for reply
I need to go towards Linq to sql and next entity frame work then which type of querying make me best

Christian Graus 21-Jan-14 0:45am

I use both all the time, you can use either whenever you like.

Karthik_Mahalingam · Accepted Answer · 2014-01-20T18:36:00

Solution 3

First one is the Comprehension query
second one is the Lamda expressions

Lamda is faster than Comprehension query, since the Comprehension query is converted to Lamda expression internally.

Comprehension query is the sql like construction. This will be helpful for the programmers who are more familiar with sql.

Posted 20-Jan-14 18:36pm

Karthik_Mahalingam

Comments

Member 9877910 21-Jan-14 0:59am

I need to go towards Linq to sql and next entity frame work then which type of querying make me best

Karthik_Mahalingam 21-Jan-14 1:24am

http://stackoverflow.com/questions/3293995/what-is-the-difference-between-entity-framework-and-linq-to-sql-by-net-4-0/3294623#3294623

http://jinaldesai.net/linq-to-sql-vs-entity-framework/

http://www.entityframeworktutorial.net/EFvsL2S.aspx