Advantages And Disadvantages Of LINQ

Introduction of LINQ (Language Integrated Query)

Based on the research conducted, the term LINQ is an acronyms that stand for Language Integrated Query. LINQ is tool that mainly used for querying data in the ASP.NET by defining a common programming syntax to query different type of data through using a common language. LINQ syntax is divided into 2 type of syntax which is Lambda (Method) Syntax and Query (Comprehension) Syntax. However, both syntax also involve the use of extension method. Moreover, LINQ can be used to extract data from various data sources such as LINQ to Objects, XML, SQL and etc. as long as the LINQ provider are available. Diagram 1.1 LINQ architecture

The top of the chart shows that the programming language that able

And this is time consuming as LINQ are required to process the whole query and thus the performance is reduced. Another disadvantages of LINQ is that there is an impact to the performance whenever there is presence of complex queries as LINQ needed to process the whole queries in order to run. Therefore, it will be very ineffective of using LINQ when the queries are very complex. Last but not least, another disadvantage is that by using LINQ, we have no good way for viewing permission. As most of the LINQ method are applying static into it, so we cannot really look into the permission of the method. So does the extension method, in order to call it from other class, it had be made static so it available to use from other class.

The main advantages of LINQ:

1. Error check by compiler rather than at a runtime.

2. Simple and easy to learn even for beginner level user.

3. Support for various database such as XML, SQL and etc.

The main disadvantages of LINQ:

1. Required to recompile and redeploy whenever changes are made by user.

2. Impact to performance, high network traffic usage.

3. No clear view of permission.

Requirement to use LINQ:

1. Compiler - .NET 3.5 framework.

2. Visual Studio