WHAT AND WHY LINQ?

WHAT AND WHY LINQ?

LINQ stands for "Language Integrated Query". MS language developers provided a way to express queries directly in their languages (such as c# and vb)

Benefits of Using LINQ

• Familiar syntax for writing queries.
• Compile-time checking for syntax errors and type safety.
• Improved debugger support.
• IntelliSense support.
• Ability to work directly with XML elements instead of creating a container XML document, as required with W3C DOM.
• In-memory XML document modification that is powerful, yet simpler to use than XPath or XQuery.
• Powerful filtering, ordering, and grouping capabilities.
• Consistent model for working with data across various kinds of data sources and formats

LINQ to Objects

Designed to  query in-memory data collections such as the classes the System.Collections and System.Collections.Generic namespaces

 LINQ to SQL

Designed to work with only SQL Server database , to access SQL Server and SQL Server Express databases through a strongly-typed object layer that you create

LINQ to DataSet

It is an easy and faster way to make querying over cached data faster and easier than the filtering and sorting methods available to a DataSet

LINQ to XML

LINQ to XML enables you to create and modify XML documents easily by using LINQ query expressions instead of XPath or XQuery