Creating Understanding and Educating Programmers, Developers and Technical Communities, one post at a time.

Wednesday, November 9, 2011

Language Integrated Query

LINQ api provide a way to access Object Data, Relational Data, and XML Data. System.LINQ defines more than 50 operators(also called standard query operator and can also be extendable) which are similar to SQL operators. Static type checking allows the assignment of selected result in correct IEnumerable object.

It was also misunderstood in early days of LINQ concept that only database is accessible from API. LINQ can used with any data object which are in main memory. It is really easy to use LINQ and filter item in list instead of writing foreach code and then apply if else conditions.

LINQ to SQL translates query expression into T-SQL It is simple ORM.

Some cool facts about LINQ.

LINQ query does not execute until it is actually use/access by code. This concept is called Deferred Execution. So most operators are lazy.

1 comment:

  1. This is a good article & good site.Thank you for sharing this article. It is help us following categorize:
    healthcare, e commerce, programming, it consulting, retail, manufacturing, CRM, digital supply chain management, Delivering high-quality service for your business applications,
    Solutions for all Industries,
    Getting your applications talking is the key to better business processes,
    Rapid web services solutions for real business problems,
    Web-based Corporate Document Management System,
    Outsourcing Solution,
    Financial and Operations Business Intelligence Solution,