Avatar of iulianchira
iulianchira

asked on 

LINQ vs ADO.NET -- which is faster?

In a gridview I have to display data that comes from 5 different tables. I wrote a method that joins my tables using foreach loops to iterate over the data tables. Now I'm thinking about switching to Linq. There is less code involved (20 lines for the Linq query vs about 200 for classic .net code). However, I'm concerned with the performance, both in terms of speed and memory usage. Is Linq faster, or is it slower?
.NET Programming

Avatar of undefined
Last Comment
iulianchira
ASKER CERTIFIED SOLUTION
Avatar of naspinski
naspinski
Flag of United States of America image

Blurred text
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
Avatar of iulianchira
iulianchira

ASKER

It's not that easy, the tables come from 3 different databases.
Avatar of iulianchira
iulianchira

ASKER

And those databases reside on two different servers. Three of the tables in question I get by using a web service call from the API of the application to which they belong.
.NET Programming
.NET Programming

The .NET Framework is not specific to any one programming language; rather, it includes a library of functions that allows developers to rapidly build applications. Several supported languages include C#, VB.NET, C++ or ASP.NET.

137K
Questions
--
Followers
--
Top Experts
Get a personalized solution from industry experts
Ask the experts
Read over 600 more reviews

TRUSTED BY

IBM logoIntel logoMicrosoft logoUbisoft logoSAP logo
Qualcomm logoCitrix Systems logoWorkday logoErnst & Young logo
High performer badgeUsers love us badge
LinkedIn logoFacebook logoX logoInstagram logoTikTok logoYouTube logo