Doubt in LINQ - Regarding writing Query statements !!!

Question

4.00/5 (1 vote)

See more:

Hello Friends,
Well yesterday I was appearing for an interview when this Question was asked to me for which I was confused to answer.

Question is:

We write query statements in LINQ as:
Consider 'db' as an object of a data context class.

C#

var q =from c in db.Customers select c;

So why do we write the query starting as "from c in ......." instead of simply writing as

C#

Select * from db.Customers

I also answered the interviewer that this is the Syntax to write.But he asked me to answer in more depth.

Posted 2-Nov-12 8:26am

P_Dash

Add a Solution

Comments

Nelek 2-Nov-12 14:38pm

And the question is.... ?

2 solutions

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)

Thomas Daniels · Answer 1 · 2012-11-02T08:39:00

Solution 1

LINQ is made to write SQL queries easier.
For simple queries, like your query, LINQ makes no difference, but if the SQL queries are longer, it's easier to use LINQ.
Have a look here:
http://www.linqpad.net/WhyLINQBeatsSQL.aspx[^]

Posted 2-Nov-12 8:39am

Thomas Daniels

Updated 2-Nov-12 8:40am

v2

Comments

P_Dash 2-Nov-12 14:56pm

Sir, I know it's easy to write complex sql queries in LINQ, but for this why do we start the query with 'from' ?

U've provided a good link, but plz explain me this one, coz i need to answer that interviewer tomorrow.

Thanks

Member 9567055 · Answer 2 · 2012-11-02T08:40:00

Solution 2

i believe "select * from " is the syntax that database understands.

linq is intended to have the flexibility to query the objects similar to database style.

but select "*" will not be understood by linq. in the above query, "from c" ==> from customer object in the list of db.customers select one customer.
may be this should be a query with more filters on it to select a specific customer of certain criteria.

Posted 2-Nov-12 8:40am

Member 9567055

Comments

P_Dash 2-Nov-12 14:46pm

Well I know it's a Simple query.Since my question isn't anything related to how to write query, I used just a simple query.

I just want to know why r we starting the LINQ queries with 'from' ???

fjdiewornncalwe 2-Nov-12 14:58pm

LINQ queries start with "from" because they do. That is how the syntax was designed. It's like asking "Why do sql select queries start with select?"

P_Dash 3-Nov-12 4:36am

Dear, don't get angry.
This is the question asked to me.
When I replied as u...Interviewer said answer me more accurate.