Click here to Skip to main content
14,265,748 members

Welcome to the Lounge

   

For discussing anything related to a software developer's life. Technical discussions are encouraged, but click here to ask your programming questions.

The Lounge is rated PG. If you're about to post something you wouldn't want your kid sister to read then don't post it. No flame wars, no abusive conduct, no programming questions and please don't post ads.
 
GeneralRe: LINQ "let" Pin
Marc Clifton8-Jun-16 7:59
protectorMarc Clifton8-Jun-16 7:59 
GeneralRe: LINQ "let" Pin
Richard Deeming8-Jun-16 8:40
mveRichard Deeming8-Jun-16 8:40 
GeneralRe: LINQ "let" Pin
90823658-Jun-16 5:28
member90823658-Jun-16 5:28 
GeneralRe: LINQ "let" Pin
Sander Rossel8-Jun-16 5:51
professionalSander Rossel8-Jun-16 5:51 
GeneralRe: LINQ "let" Pin
Nicholas Marty9-Jun-16 2:53
professionalNicholas Marty9-Jun-16 2:53 
GeneralRe: LINQ "let" Pin
Sander Rossel9-Jun-16 3:43
professionalSander Rossel9-Jun-16 3:43 
GeneralRe: LINQ "let" Pin
Nicholas Marty9-Jun-16 4:40
professionalNicholas Marty9-Jun-16 4:40 
GeneralRe: LINQ "let" Pin
James Curran9-Jun-16 4:18
memberJames Curran9-Jun-16 4:18 
Which "traditional" methods? ADO with DataSets?

From my experience, LINQ is trivially slower (but with added type-safety benefits to offset it).

BUT, linq makes it very easy to write bad queries. Things like, reading an entire table into an array, and then linearly search through it.

SO, it you compare a carefully tuned, DBA written stored procedure against a simple query written by a developer with little experience with databases, well, then, LINQ is going to lose. But, it you compare two well-crafted queries, one in LINQ and one in SQL, then you should be nearly the same (since the LINQ will generate the exact same SQL).
Truth,

James


modified 9-Jun-16 10:53am.

GeneralRe: LINQ "let" Pin
Marc Clifton8-Jun-16 7:57
protectorMarc Clifton8-Jun-16 7:57 
GeneralRe: LINQ "let" Pin
Nish Nishant8-Jun-16 10:02
sitebuilderNish Nishant8-Jun-16 10:02 
GeneralRe: LINQ "let" Pin
Kenneth Haugland8-Jun-16 4:45
professionalKenneth Haugland8-Jun-16 4:45 
GeneralRe: LINQ "let" Pin
Sander Rossel8-Jun-16 5:44
professionalSander Rossel8-Jun-16 5:44 
GeneralRe: LINQ "let" Pin
BillWoodruff8-Jun-16 8:29
mveBillWoodruff8-Jun-16 8:29 
GeneralRe: LINQ "let" Pin
Richard Deeming8-Jun-16 8:52
mveRichard Deeming8-Jun-16 8:52 
GeneralRe: LINQ "let" Pin
BillWoodruff8-Jun-16 12:46
mveBillWoodruff8-Jun-16 12:46 
GeneralRe: LINQ "let" Pin
Mark Whybird8-Jun-16 21:24
memberMark Whybird8-Jun-16 21:24 
GeneralRe: LINQ "let" Pin
Richard Deeming9-Jun-16 1:38
mveRichard Deeming9-Jun-16 1:38 
GeneralRe: LINQ "let" Pin
Nicholas Marty9-Jun-16 2:54
professionalNicholas Marty9-Jun-16 2:54 
GeneralRe: LINQ "let" Pin
Mark Whybird9-Jun-16 13:41
memberMark Whybird9-Jun-16 13:41 
GeneralRe: LINQ "let" Pin
Mark Whybird9-Jun-16 13:40
memberMark Whybird9-Jun-16 13:40 
AnswerRe: LINQ "let" Pin
Nish Nishant8-Jun-16 10:01
sitebuilderNish Nishant8-Jun-16 10:01 
GeneralRe: LINQ "let" Pin
Super Lloyd8-Jun-16 14:55
memberSuper Lloyd8-Jun-16 14:55 
GeneralRe: LINQ "let" Pin
louthy9-Jun-16 10:38
memberlouthy9-Jun-16 10:38 
NewsOverdosing on anti-diarrhea drugs: Only in America Pin
Cornelius Henning8-Jun-16 2:57
professionalCornelius Henning8-Jun-16 2:57 
GeneralRe: Overdosing on anti-diarrhea drugs: Only in America Pin
Mike Hankey8-Jun-16 3:04
professionalMike Hankey8-Jun-16 3:04 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.