Category Archives: LINQ

What are different methods to write LINQ Query?

There are following three ways to write LINQ Query: Query Expression (Query Syntax) – Query expression syntax is like as SQL query syntax with just a few minor deviations. The result of a query expression is a query object, which is usually a collection of type IEnumerable<T> or IQueryable<T>. This syntax is easy to read and Continue Reading…

What are advantages of LINQ?

There are following advantages of using LINQ: Its Query can be reused. It also allows debugging through .NET debugger. Quick turn around for development. Queries can be dynamically. Tables are automatically created into class. Columns are automatically created into properties. Relationship are automatically appeaded to classes. Lambda expressions are awesome. Data is easy to setup Continue Reading…

What are different flavors of LINQ?

There are following four flavors of LINQ: LINQ to Objects – It enables you to query any in-memory object like as array, collection and generics types. It offers a new way to query objects with many powerful features like filtering, ordering and grouping with minimum code. LINQ to ADO.NET – LINQ to ADO.NET is used to query data from Continue Reading…

What is LINQ and why to use it?

LINQ stands for “Language Integrated Query” and pronounced as “LINK“. LINQ was introduced with .NET Framework 3.5 including Visual Studio 2008, C# 3.0 and VB.NET 2008 (VB 9.0). It enables you to query the data from the various data sources like SQL databases, XML documents, ADO.NET Datasets, Web services and any other objects such as Continue Reading…