LINQ Queries

The performance of LINQ is a key issue for a lot of people in adopting this new tool in their arsenal. A lot of the time they are particularly interested in how LINQ to SQL performs in comparison to a traditional ADO.Net query. The news isn’t all bad. Under the covers LINQ to SQL has to use something to retrieve data, so it’s naturally going to be slower than a direct query mechanism such as ADO.Net. They key here is remembering that LINQ to SQL isn’t just a query tool. It’s an ORM solution, a rapid development tool and a more natural way to query all rolled into one.