What is LINQ? Its advantage, disadvantage and types. | ASPMANTRA | Asp.Net,MVC,AngularJs,Jquery,Javascript,Sql Server AND WCF snippets and tutorial

What is LINQ? Its advantage, disadvantage and types.


LINQ stand for Language Integrated Query. LINQ is part of Microsoft .Net Framework in C# and VB language. It was released with .NET 3.5 framework. LINQ is used to Query the data by using syntax similar to SQL.LINQ have the own processing engine for Query. We can also use store procedure is LINQ.
Advantage:
1.       LINQ provide the short codes so programmers have not write too much code for query.
2.       Application check by the complier at runtime for error.
3.       Debug the application easily.
Disadvantage:
1.       There are no clear outlines in LINQ application.
2.       Its complex to understand the advance query using expressions.
3.       Joins are very slow when used in query
Types:
 Basically linq is of three types:
DLINQ: LINQ to Sql formerly called DLINQ. In DLINQ query is performed against the SQL database.
XLINQ: LINQ to XML formerly called XLINQ. In XLINQ query is performed against the the XML data source.
LINQ :LINQ to Object formerly called LINQ. LINQ perform the query against in-memory collection of object.


Related Articles on LINQ:

Ø  How to Bind Dropdownlist in Asp.net using LINQ?

Ø  How to Bind Gridview Data Control in LINQ?

Ø  How to insert data intodatabase using Linq?

Is it helpful?

If yes post your comment to admire my work. You can like me on Facebook, Google+, Linkedin and Twitter via hit on Follow us Button and also can get update follow by Email.

Post a Comment

Nice article love to read the whole new way of your writing this things.

Shan
www.gofastek.com

thanks.....Keep visiting for more articles...http://www.articlemirror.in/2014/01/populate-cascading-dropdown-list-in.html

need some example to describe more

I really enjoyed reading your article. I found this as an informative and interesting post, so i think it is very useful and knowledgeable. I would like to thank you for the effort you have made in writing this article.


edupdf.org

I’m glad I was able to help. Keep visiting for more article.

[blogger]

MKRdezign

Contact Form

Name

Email *

Message *

Powered by Blogger.
Javascript DisablePlease Enable Javascript To See All Widget